Home » Server Options » Data Guard » standby testing
standby testing [message #161741] Mon, 06 March 2006 23:24
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
.......i have tried to run catalog,catproc n utlrp but while runnig this i m getting this error repetedly....
SQL>
@/usr5/oracle/app/oracle/product/9.2.0.1.0/rdbms/admin/standard.sql;
create or replace
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-801: internal error [56319]
create or replace
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-801: internal error [56319]

even while runnig standard.sql i m geting error....

plz help me.....
risy
Previous Topic: Delete databse?
Next Topic: 10g Data Guard Fast Start Failover
Goto Forum:
  


Current Time: Fri Mar 29 04:11:50 CDT 2024