Thanks

Okay sure... You can call me on my number 7355390388

Okay..I will try to fix this issue

Thank you 😊

Thanks for correcting me.. I missed it

Thank you so much 🥰

Okay sure

Please share your problem in detail.. I will try to provide you the fix.

@@TechDBA_Future oracle listener service doesn't run . I start the service suddenly it will stop itself

An undo log record contains information about how to undo the recent changes by a transaction.

@@TechDBA_Future Thanks for quick response

Thank you so much😊

Thanks

Thanks😊

You can say system global area as well shared global area both...

Thanks

Thanks

Thank you so much😊

Thanks

Thanks

Thank you

Thanks

Thanks

Sure

Posting the sql query here for block corruption check

SELECT e.owner, e.segment_type, e.segment_name SG_Name, e.partition_name, c.file# , greatest(e.block_id, c.block#) corr_start_block# , least(e.block_id+e.blocks-1, c.block#+c.blocks-1) corr_end_block# , least(e.block_id+e.blocks-1, c.block#+c.blocks-1) - greatest(e.block_id, c.block#) + 1 blocks_corrupted , null description FROM dba_extents e, v$database_block_corruption c WHERE e.file_id = c.file# AND e.block_id <= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 >= c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted , 'Segment Header' description FROM dba_segments s, v$database_block_corruption c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest(f.block_id, c.block#) corr_start_block# , least(f.block_id+f.blocks-1, c.block#+c.blocks-1) corr_end_block# , least(f.block_id+f.blocks-1, c.block#+c.blocks-1) - greatest(f.block_id, c.block#) + 1 blocks_corrupted , 'Free Block' description FROM dba_free_space f, v$database_block_corruption c WHERE f.file_id = c.file# AND f.block_id <= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 >= c.block# ORDER BY file#, corr_start_block#;