| ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON [message #51763] |
Wed, 12 June 2002 14:20  |
Avishai Geller
Messages: 2
Registered: June 2002
|
Junior Member |
|
|
The following error occurs when I try to connect to oracle9i. This started happening immediately after I ran catalog.sql in the hopes of getting export to work. Does anybody know what could cause this or how to fix it?
Thanks,
avishai
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
|
|
|
|
|
|
|
|
| Re: ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON [message #55160 is a reply to message #51763] |
Wed, 08 January 2003 04:23  |
Peter Milkovits
Messages: 1
Registered: January 2003
|
Junior Member |
|
|
Hello avishai,
we use Oracle 9i (Enterprise Edition Release 9.2.0.1.0) and had exactly the same problem. A login with "normal" users is not possible, but password-file-users like sys can connect to the instance.
If you use the Enterprise Manager Console you will see some invalid objects in the schema of LBACSYS and SYS. If you try to recompile them, it will fail. So try the following:
Connect to the instance as user sys and disable a hidden parameter with:
alter system set "_system_trig_enabled"=false;
Now you can run catalog.sql and catproc.sql if you like. It will work now. But we are still not finished. Now recompile every invalid object like this:
ALTER TRIGGER "LBACSYS"."LBAC$LOGON" COMPILE
ALTER TRIGGER "SYS"."CDC_ALTER_CTABLE_BEFORE" COMPILE
ALTER PACKAGE "LBACSYS"."LBAC_EVENTS" COMPILE PACKAGE
(or via Enterprise Manager Console)
If this is done successfully it is VERY important to switch back the hidden parameter to true with
alter system set "_system_trig_enabled"=true;
You should now be able to connect to the instance with any "normal" user again. At least here it worked. Hope this helps you.
Regards
Peter
|
|
|
|
 ORA-04045: errors during recompilation/revalidation of SGE.sun/io/ByteToCharISO8859_1 [message #150755 is a reply to message #51763] |
Fri, 09 December 2005 08:10 |
aristizabal9
Messages: 2
Registered: December 2005
|
Junior Member |
|
|
Hello, I'm trying to load a java class, and I get this error, I don't know if anyone can help me...
Thanks!!!
C:\oracle\ora92\bin>loadjava -v -f -r -user sge/sge2004@desarrollo "C:\IBM\Prote
ccion\SGEDesarrollo\JavaSource\co\com\personalsoft\sistemaGestionEmpleados\clase
sEmbebidasOracle\ValidarXMLconXSD.java"
arguments: '-v' '-f' '-r' '-user' 'sge/sge2004@desarrollo' 'C:\IBM\Proteccion\SG
EDesarrollo\JavaSource\co\com\personalsoft\sistemaGestionEmpleados\clasesEmbebid
asOracle\ValidarXMLconXSD.java'
creating : source co/com/personalsoft/sistemaGestionEmpleados/clasesEmbebidasOra
cle/ValidarXMLconXSD
loading : source co/com/personalsoft/sistemaGestionEmpleados/clasesEmbebidasOra
cle/ValidarXMLconXSD
creating : co/com/personalsoft/sistemaGestionEmpleados/clasesEmbebidasOracle/Val
idarXMLconXSD
Error while creating co/com/personalsoft/sistemaGestionEmpleados/clasesEmbebidas
Oracle/ValidarXMLconXSD
ORA-04045: errors during recompilation/revalidation of SGE.sun/io/ByteToChar
ISO8859_1
Error while computing shortname of co/com/personalsoft/sistemaGestionEmpleados/c
lasesEmbebidasOracle/ValidarXMLconXSD
ORA-04045: errors during recompilation/revalidation of SGE.sun/io/ByteToChar
ISO8859_1
ORA-06512: at "SYS.DBMS_JAVA", line 213
ORA-06512: at line 1
The following operations failed
source co/com/personalsoft/sistemaGestionEmpleados/clasesEmbebidasOracle/Val
idarXMLconXSD: creation
exiting : Failures occurred during processing
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
