sqlplus "/ as sysdba" or sqlplus "sys as sysdba" both will let you in even if the archiver is stuck.
RF -----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 8/28/2003 6:29 PM no, the file system was only 43% full the reason log files weren't being written is being the stupid compress archive script turns archiving off before compressing archived log files, then turns it on afterwards. unfortunately, in this one 9;2 instance, it doesn't always want to reenable auto archiving -- in which case the database will eventually hang cause redo logs aren;t being archived. my question is: how do I log into a 9.2 instance to restart auto archiving? >>> [EMAIL PROTECTED] 08/28/03 04:19pm >>> 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. ----- Original Message ----- To: Multiple recipients of list ORACLE-L <mailto:[EMAIL PROTECTED]> Sent: Friday, August 29, 2003 12:24 AM 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) [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 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: Freeman Robert - IL INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
