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

hi all
Actually we need to test our standby db by activating it as primary.. we have oracle 9.2.0.1.0. 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

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


Error accessing package DBMS_APPLICATION_INFO
ERROR:
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: Thu Mar 28 07:50:10 CDT 2024