Home » RDBMS Server » Server Administration » Oracle error when logging into database (10g. OEL 5.5)
Oracle error when logging into database [message #558784] Tue, 26 June 2012 09:51 Go to next message
bbingay
Messages: 5
Registered: June 2012
Junior Member
When I try to log into my db with a specific user I get this message. Below is from the alert log. I can login as system just fine. Anyone know how to figure out what is causing this?

Thanks in advance for the help.

----- Error Stack Dump -----
ORA-00604: error occurred at recursive SQL level 1
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at line 2
Oracle 10g OEL 5.5
Re: Oracle error when logging into database [message #558786 is a reply to message #558784] Tue, 26 June 2012 09:56 Go to previous messageGo to next message
BlackSwan
Messages: 23026
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/


I suspect that a LOGON trigger is broken

BTW, 10g is Marketing Label; not actual Oracle version

post results from SQL below

SELECT * FROM V$VERSION;

[Updated on: Tue, 26 June 2012 09:57]

Report message to a moderator

Re: Oracle error when logging into database [message #558787 is a reply to message #558786] Tue, 26 June 2012 10:09 Go to previous messageGo to next message
bbingay
Messages: 5
Registered: June 2012
Junior Member
I was wrong on the version, Thanks for replying. How would you troubleshoot this? Alert log shows only the errors I posted. BTW this is a test system.

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
Re: Oracle error when logging into database [message #558788 is a reply to message #558787] Tue, 26 June 2012 10:17 Go to previous messageGo to next message
BlackSwan
Messages: 23026
Registered: January 2009
Senior Member
does any LOGON trigger exist?
Re: Oracle error when logging into database [message #558790 is a reply to message #558788] Tue, 26 June 2012 10:25 Go to previous messageGo to next message
bbingay
Messages: 5
Registered: June 2012
Junior Member
I looked in dba_triggers and see LOGON_AUDIT_TRIGGER with a status of enabled.
Re: Oracle error when logging into database [message #558792 is a reply to message #558790] Tue, 26 June 2012 10:35 Go to previous messageGo to next message
gazzag
Messages: 356
Registered: November 2010
Location: Bristol, UK
Senior Member
Examine DBA_TRIGGERS.TRIGGER_BODY as Blackswan originally suggested.
Re: Oracle error when logging into database [message #558793 is a reply to message #558792] Tue, 26 June 2012 10:42 Go to previous messageGo to next message
bbingay
Messages: 5
Registered: June 2012
Junior Member
This is what it shows in trigger_body.

BEGIN
insert into stats$user_log values (
Re: Oracle error when logging into database [message #558795 is a reply to message #558793] Tue, 26 June 2012 11:01 Go to previous messageGo to next message
gazzag
Messages: 356
Registered: November 2010
Location: Bristol, UK
Senior Member
SQL> SET LONG 1000000

Then try again.
Re: Oracle error when logging into database [message #558798 is a reply to message #558795] Tue, 26 June 2012 11:28 Go to previous messageGo to next message
BlackSwan
Messages: 23026
Registered: January 2009
Senior Member
ALTER TRIGGER LOGON_AUDIT_TRIGGER DISABLE;
then try to login again & see if error results
Re: Oracle error when logging into database [message #558807 is a reply to message #558798] Tue, 26 June 2012 12:58 Go to previous message
bbingay
Messages: 5
Registered: June 2012
Junior Member
This solved my problem. This was a test system. I looked at production and it was disabled. Thank you BlackSwan, I really appreciate it.
Previous Topic: Oracle ASM
Next Topic: Reg database migration
Goto Forum:
  


Current Time: Sat Nov 22 04:17:12 CST 2014

Total time taken to generate the page: 0.13443 seconds