Home » RDBMS Server » Server Utilities » ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON
ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON [message #73745] Wed, 30 June 2004 02:40 Go to next message
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.

Report message to a moderator

Re: ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON [message #73747 is a reply to message #73745] Wed, 30 June 2004 03:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
please try this.

do a clean shutdown.
set _system_trig_enabled = false in initsid.ora.
start the instance with this initsid.ora and open the database.
login "sys as sysdba"
run catalog.sql again.
if everything is good, remove the _system_trig_enabled parameter from initsid.ora and bounce the database.

Report message to a moderator

Re: ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON [message #73749 is a reply to message #73747] Wed, 30 June 2004 03:45 Go to previous messageGo to next message
Jitendra Agrawal
Messages: 71
Registered: December 2003
Member
Thnx a ton Mahesh,

This solved my probelm

Regards,
Jeet.

Report message to a moderator

Re: ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON [message #73763 is a reply to message #73745] Mon, 05 July 2004 23:34 Go to previous messageGo to next message
Satheesh Babu.S
Messages: 35
Registered: July 2004
Member
This error is because your using label security. If you don't want then drop the lable security option.

Thanks and Regards,
Satheesh Babu.S
Bangalore.

Report message to a moderator

Re: ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON [message #74326 is a reply to message #73747] Mon, 15 November 2004 22:25 Go to previous messageGo to next message
Maneesh Hari Disawal
Messages: 1
Registered: November 2004
Junior Member
This solved my problem too!
Thanks for your help.

-Maneesh Hari

Report message to a moderator

Re: ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON [message #323835 is a reply to message #73745] Thu, 29 May 2008 12:02 Go to previous messageGo to next message
paolinchi
Messages: 1
Registered: May 2008
Location: Ecuador
Junior Member
Thank's a lot... The solution works for me too. Smile

Report message to a moderator

Re: ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON [message #346123 is a reply to message #73745] Sat, 06 September 2008 05:11 Go to previous message
san_kosale
Messages: 1
Registered: March 2008
Location: Mumbai, India.
Junior Member
Hi,

Thanks for the Solution.

Sanjay k..

Report message to a moderator

Previous Topic: Volume manager
Next Topic: error during dump import: ORA-24170 when drop user
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 09:35:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.