How to log into a 9.2.0 database that has a hung archiver -

sorry
after checking logs again, the connect / as sysdba command and sqlplus '/ as sysdba' hung after issuing the command. a password was never requested.  

thanks
shannon

Situation:  

Oracle EE 9.2.0 database on AIX v5.1  

tail alert_TOOLS.log:

Thu Aug 28 13:46:31 2003
ARC0: Evaluating archive log 1 thread 1 sequence 69800 ARC0: Beginning to archive log 1 thread 1 sequence 69800 Creating archive destination LOG_ARCHIVE_DEST_1: '/u00/oracle/archives/tools_698
00.dbf'
ARC0: Completed archiving log 1 thread 1 sequence 69800 Thu Aug 28 13:46:33 2003
Archive Log Stop
Archiving is disabled
Shutting down archive processes
Archiving is disabled
Thu Aug 28 13:46:34 2003
ARCH shutting down
Thu Aug 28 13:46:34 2003
ARC0: Archival stopped
Thu Aug 28 13:46:34 2003
ARCH shutting down
Thu Aug 28 13:46:34 2003
ARC1: Archival stopped
Thu Aug 28 13:46:39 2003
Thread 1 advanced to log sequence 69802
  Current log# 2 seq# 69802 mem# 0: /u09/oracle/TOOLS/redo02.log Thread 1 advanced to log sequence 69803
  Current log# 1 seq# 69803 mem# 0: /u09/oracle/TOOLS/redo01.log Thu Aug 28 13:46:48 2003
ORACLE Instance TOOLS - Can not allocate log, archival required ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 69804 All online logs needed archiving
  Current log# 1 seq# 69803 mem# 0: /u09/oracle/TOOLS/redo01.log  

so the archive hung.  

on our older 7x and 8x systems, I would do a svrmgrl and connect internal
then I would do an archive log all to archive the logs  

on this 9.2.0 system, I tried sqlplus 'sys as sysdba' --- it hung after asking for the password
ok... tried sqlplus /nolog --- then connect sys as sysdba -- hung after asking for password
ok... tried sqlplus '/ as sysdba' -- hung after asking for password ok... tried sqlplus /nolog -- then connect / as sysdba -- hung after asking for password  

Killed smon to cause database to crash.
sqlplus 'sys as sysdba' -- asked for password -- got the sql prompt - startup  

everything worked.  

I'm glad this is a test database so I could kill it and restart but what is the correct method to get a sql prompt on a hung database when svrmgrl and connect internal aren't supported?  

Thanks
Shannon  

Shannon St. Dennis
Database Administrator
City of Regina
(306) 777-7415 (phone)
(306) 777-6804 (fax)

sstdenni_at_cityregina.com  

The degree of normality in a database is inversely proportional to that of its DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Shannon St. Dennis
  INET: SSTDENNI_at_regina.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).