Shulou(Shulou.com)05/31 Report--

This article "database ORA-00604 error how to solve" most people do not understand the knowledge points of the article, so Xiaobian summarized the following content for everyone, detailed content, clear steps, has a certain reference value, I hope you can read this article to gain something, let's take a look at this article "database ORA-00604 error how to solve" article bar.

tar install database

Software and DB are not together.

After restoring the backup database with rman

Error message after clearing original data after starting database

Test creation user also reports error

SQL> create user an identified by an;

create user an identified by an

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [],

[]

ORA-06553: PLS-801: internal error [56319]

Cause analysis:

Inconsistency between software and db during upgrade

Manually upgrade the database

Processing: Re-upgrade database

conn / as sysdba

shutdown immediate

startup upgrade

@?/ rdbms/admin/catupgrd.sql

@?/ rdbms/admin/utlip.sql

And then restart the database.

returned to normal

The above is about the content of this article "How to solve the error of ORA-00604 in the database". I believe everyone has a certain understanding. I hope the content shared by Xiaobian will be helpful to everyone. If you want to know more relevant knowledge content, please pay attention to the industry information channel.

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.