Earlier to this, I used the following commands to compile INVALID objects of any database 1. @?/rdbms/admin/utlrp 2. exec utl_recomp.recomp_parallel(threads=>5) 3. alter package/ procedure compile … comand I found one more utility that will help us to compile the invalids of any particular schema exec dbms_utility.compile_schema(‘<schema_name>’, FAlSE); Ex; exec dbms_utility.compile_schema(‘SCOTT’, FAlSE); We used “FALSE” as […]

Suppressing further error logging of LOG_ARCHIVE_DEST_2. Fri Nov 6 08:45:53 2009 Error 1031 received logging on to the standby Suppressing further error logging of LOG_ARCHIVE_DEST_2. Fri Nov 6 08:50:53 2009 Error 1031 received logging on to the standby Suppressing further error logging of LOG_ARCHIVE_DEST_2. Fri Nov 6 08:55:53 2009 Error 1031 received logging on to […]