ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON [message #73745] |
Wed, 30 June 2004 02:40 |
Jitendra Agrawal
Messages: 71 Registered: December 2003
|
Member |
|
|
Hi,
We are running Oracle 9i on RedHat linux 7.3. Today by mistake the script catalog.sql was executed.
After doing sqlplus /nolog and connecting as sysdba catalog.sql was executed.
I am listing partial output of that command.
create public synonym v$dlm_locks for v_$dlm_locks
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDC_CREATE_CTABLE_BEFORE
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
Grant succeeded.
create or replace view v_$dlm_ress as select * from v$dlm_ress
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDC_CREATE_CTABLE_BEFORE
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
drop public synonym v$dlm_ress
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDC_DROP_CTABLE_BEFORE
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
create public synonym v$dlm_ress for v_$dlm_ress
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDC_CREATE_CTABLE_BEFORE
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
Grant succeeded.
create or replace view v_$hvmaster_info as select * from v$hvmaster_info
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDC_CREATE_CTABLE_BEFORE
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
drop public synonym v$hvmaster_info
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDC_DROP_CTABLE_BEFORE
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
create public synonym v$hvmaster_info for v_$hvmaster_info
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDC_CREATE_CTABLE_BEFORE
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
Grant succeeded.
create or replace view v_$gcshvmaster_info as select * from v$gcshvmaster_info
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDC_CREATE_CTABLE_BEFORE
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
drop public synonym v$gcshvmaster_info
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDC_DROP_CTABLE_BEFORE
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
Now if I try to login as a normal user I get folowing error.
[[oracle@stp oracle]]$ sqlplus crbt/crbt
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 30 16:13:16 2004
(c) Copyright 2001 Oracle Corporation. All rights reserved.
ERROR:
ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
Enter user-name:
Logging as system gives following errors.
[[oracle@stp admin]]$ sqlplus system/manager
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 30 16:14:06 2004
(c) Copyright 2001 Oracle Corporation. All rights reserved.
ERROR:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_OUTPUT
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ERROR:
ORA-04045: errors during recompilation/revalidation of
SYS.DBMS_APPLICATION_INFO
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
Error accessing package DBMS_APPLICATION_INFO
Any help resolving this problem is welcome.
Thanks in advance.
Jeet.
|
|
|
|
|
|
|
|
|