| 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
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
