Re: Can't login to oracle other than SYSDBA
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: mmrashid@xxxxxxx
- Date: Fri, 9 Jun 2006 20:19:40 +0200
"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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
