Shulou(Shulou.com)06/01 Report--

RMAN > alter database open resetlogs

Database openedRMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT rowRMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rowsORACLE error from target database:ORA-06553: PLS-801: internal error [56319]

The specific alarm log is as follows.

Completed: alter database open resetlogsSun May 28 22:34:47 2017Errors in file / home/oracle/oracle/admin/SCM2/bdump/scm2_mmon_20272.trc:ORA-06553: PLS-801: internal error [56319] Sun May 28 22:34:47 2017Errors in file / home/oracle/oracle/admin/SCM2/bdump/scm2_mmon_20272.trc:ORA-06553: PLS-801: internal error [56319] Sun May 28 22:34:47 2017Starting background process CJQ0CJQ0 started with pid=19 OS id=21562Sun May 28 22:34:50 2017Errors in file / home/oracle/oracle/admin/SCM2/bdump/scm2_j000_21565.trc:ORA-12012: error on auto execute of job 42567ORA-06553: PLS-ORA-06553: PLS-801: internal error [56319]: Sun May 28 22:34:50 2017Errors in file / home/oracle/oracle/admin/SCM2/bdump/scm2_j001_21567.trc:ORA-12012: error on auto execute of job 42568ORA-06553: PLS-ORA-06553: PLS-801: internal Error [56319]: Sun May 28 22:34:50 2017Errors in file / home/oracle/oracle/admin/SCM2/bdump/scm2_j002_21569.trc:ORA-12012: error on auto execute of job 5329ORA-06544: PL/SQL: internal error Arguments: [ORA-06544: PL/SQL: internal error, arguments: [56319], [] ORA-06553: PLS-801: internal error [56319]], []

This is due to the inconsistency between the software version of Oracle and the database version previously entered by restore. You can fix it as follows. For more information, please see the error handling of restoring 32-bit database to 64-bit instance in RMAN.

SQL > startup upgrade

SQL > @? / rdbms/admin/utlip.sql

SQL > shutdown immediate

SQL > startup

@? / rdbms/admin/utlrp.sql article belongs to reprint article

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.