Re: Can't login to oracle other than SYSDBA

"after cold backup is finished, all the application processing starts happening and they eventually run out something." Well, if connection to the database is not possible other than AS SYSDBA than application can't connect (it doesn't connect as sysdba. does it?) and process something so hard that it runs out of something.

If you are able to connect as sysdba - check v$session to see if process that is trying to connect hangs somewhere in Oracle (i.e. after session is established). If so than check v$session_wait to see what it's doing. Check AFTER LOGON triggers if any.

Are you doing logons locally or via listener? If listener is used - try to enable trace on listener and check logs. For local connection - you can try OS debugger (strace, tusc, truss, etc.).

-- 
Best regards,
Alex Gorbachev

http://oracloid.blogspot.com
--
http://www.freelists.org/webpage/oracle-l