There can be scenarios where you will get below error while running utlrpl.sql SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql SELECT dbms_registry_sys.time_stamp(‘utlrp_bgn’) as timestamp from dual                                                                   * ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REGISTRY_SYS ORA-01031: insufficient privileges work around solution for this problem:   SQL> ALTER SYSTEM SET “_system_trig_enabled” = FALSE scope=both; System altered. Now run […]

PROBLEM: If you are trying to take export using exclude option from kshell prompt, then you may get an error as ORA-39071: Value for EXCLUDE is badly formed. SOLUTION: The workaround to avoid this : expdp dumpfile=pdp1037782.dmp logfile=pdp1037782.log schemas=HELLOPDBA directory=EXPORT exclude=TABLE:\”IN (‘PVMERSADDRESS’,’VERSIONS’)\””   SEE ALSO: How to upgrade database from 11g to 12c manually How […]

                    I was getting ORA-00119 and ORA-00132 error while startup nomount a new db.   SQL> startup nomount ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name ‘LISTENER_PROD’   This is because LOCAL_LISTENER parameter was used in the init file and […]

     We were receiving error like MRPO terminated with error 1274,unnamed file added in standby database, when a new data file was added in the primary. Below is the actual error.   Media Recovery Log /uv1019/u341/app/prod/arch/1_68815_799031040.arch File #382 added to control file as ‘UNNAMED00382’ because the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL The file […]