Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to log into a 9.2.0 database that has a hung archiver -
Hi!
Was your file system full? If yes, then additional audit files couldn't be written under ?/rdbms/audit and that's why you could'nt log on anymore.
Tanel.
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: Tanel Poder INET: tanel.poder.003_at_mail.ee 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).Received on Thu Aug 28 2003 - 17:19:28 CDT
![]() |
![]() |