----- Original Message -----
Sent: Friday, August 29, 2003 12:24
AM
Subject: 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)
[EMAIL PROTECTED]
The degree of normality in a database is inversely proportional to that
of its DBA
