How to log onto your database when sysdba fails you

Topics about Databases, Backups, Tuning, Architecture, Systems Management, etc etc.

How to log onto your database when sysdba fails you

Postby bgrenn » Thu Mar 10, 2011 5:26 pm

Here is a great article talking about using -prelim on sqlplus.

http://tech.e2sn.com/oracle/troubleshooting/hang/how-to-log-on-even-when-sysdba-can-t-do-so
It won't allow you to query, but you should at least be able to debug sessions, or even kill sessions if you need to.
bgrenn
 
Posts: 91
Joined: Mon Mar 16, 2009 11:47 am
Location: Rochester, NY

Return to DBA Topics

Who is online

Users browsing this forum: No registered users and 1 guest

cron