OraFAQ Forum: Server Administration » Oracle error when logging into database

Home » RDBMS Server » Server Administration » Oracle error when logging into database (10g. OEL 5.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle error when logging into database [message #558784]

Tue, 26 June 2012 09:51

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

Report message to a moderator

Re: Oracle error when logging into database [message #558786 is a reply to message #558784]

Tue, 26 June 2012 09:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

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

Report message to a moderator