Home » Server Options » Data Guard » Error accessing package DBMS_APPLICATION_INFO
Error accessing package DBMS_APPLICATION_INFO [message #175623] Sat, 03 June 2006 09:17
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member


hello everbody
we need to test our standby database converting it in primary and need to check whethere reports are generating or not.....

we have installed oracle 92010(64 bit) on solaris 8(64 bit) on both side

Every time we i m able to successfully activate standby
db as primary but during report generation we got problem

So after that I have tried to connect as one of user in
new primary db but it is giving me this
error(at this time old primary db is shutdown) .


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


i have applied this steps to solve this problem

1. reinstall dbms_application_info by running standard.sql
2. run the DBMSUTL.SQL to create DBMS_APPLICATON_INFO
3. run CATALOG.SQL,CATPPROC.SQL AND UTLPR.SQL


so i have run that script catalog.sql n catproc.sql.....but while runnig
this script i got some error...


these are the errors occured while runnig CATALOG.SQL,CATPPROC.SQL AND
UTLPR.SQL and standard.sql



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]

so, i thought there is some problem with above
.sql script may be it is invalid so we have
reinstall oracle software. and configure standby
db again..

but after converting standby to primary i m getting same
errors. we have also reinstalled os at standby side but problem is still there

steps which i have followed to convert standby db to primary db

1. took a cold backup of standby db so we can revert back.
2. archived and applied up to last sequence of archive log files from
primary
3. now both db's are down
4. startup nomount(at standby)
5. alter database mount standby database(at standby )
6. recover standby database(at standby)
7. alter database activate standby database(at standby)
8. shutdown immediate(at standby )
9. starup(at standby)
now standby db is become primary db and primary db is down.

plz give me a solution because we r trying to solve this since last 4 months
Previous Topic: Standby Swtich over
Next Topic: logical standby method for applying SQL to primary ?
Goto Forum:
  


Current Time: Fri Mar 29 02:44:35 CDT 2024