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
|
|
|