Home » Server Options » Data Guard » standby testing
standby testing [message #160985] Wed, 01 March 2006 04:44
Messages: 44
Registered: September 2005
Location: Mumbai

hi all
Actually we need to test our standby db by activating it as primary.. we have oracle on solaris 9

I have successfully activated my standby db as primary but during report generation we got problem

So after that I have tried to connect as one of user but it is giving me this error

--- Error during connection

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

Error accessing package DBMS_APPLICATION_INFO
ORA-06553: PLS-801: internal error [56319]

after this error sql prompt is appearing and if I m querying show user it is showing me the particular usr…..

so plz give me some solution for this

I have found some solution from net but I m confused about this…

One solution says u should reinstall dbms_application_info by running standard.sql

One solution says before using package u must run the DBMSUTL.SQL to create DBMS_APPLICATON_INFO

One solution says u should run CATALOG.SQL,CATPPROC.SQL AND UTLPR.SQL

Previous Topic: DataGuard Gui / What is this error
Next Topic: Delete databse?
Goto Forum:

Current Time: Mon Jul 15 09:11:04 CDT 2024