How to log into a 9.2.0 database that has a hung archiver
Situation: Oracle EE 9.2.0 database on AIX v5.1 tail alert_TOOLS.log: Thu Aug 28 13:46:31 2003ARC0: Evaluating archive log 1 thread 1 sequence 69800ARC0: Beginning to archive log 1 thread 1 sequence 69800Creating archive destination LOG_ARCHIVE_DEST_1: '/u00/oracle/archives/tools_69800.dbf'ARC0: Completed archiving log 1 thread 1 sequence 69800Thu Aug 28 13:46:33 2003Archive Log StopArchiving is disabledShutting down archive processesArchiving is disabledThu Aug 28 13:46:34 2003ARCH shutting downThu Aug 28 13:46:34 2003ARC0: Archival stoppedThu Aug 28 13:46:34 2003ARCH shutting downThu Aug 28 13:46:34 2003ARC1: Archival stoppedThu Aug 28 13:46:39 2003Thread 1 advanced to log sequence 69802 Current log# 2 seq# 69802 mem# 0: /u09/oracle/TOOLS/redo02.logThread 1 advanced to log sequence 69803 Current log# 1 seq# 69803 mem# 0: /u09/oracle/TOOLS/redo01.logThu Aug 28 13:46:48 2003ORACLE Instance TOOLS - Can not allocate log, archival requiredARCH: Connecting to console port...Thread 1 cannot allocate new log, sequence 69804All 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 connectsys 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. DennisDatabase AdministratorCity 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
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 2003ARC0: Evaluating archive log 1 thread 1 sequence 69800ARC0: Beginning to archive log 1 thread 1 sequence 69800Creating archive destination LOG_ARCHIVE_DEST_1: '/u00/oracle/archives/tools_69800.dbf'ARC0: Completed archiving log 1 thread 1 sequence 69800Thu Aug 28 13:46:33 2003Archive Log StopArchiving is disabledShutting down archive processesArchiving is disabledThu Aug 28 13:46:34 2003ARCH shutting downThu Aug 28 13:46:34 2003ARC0: Archival stoppedThu Aug 28 13:46:34 2003ARCH shutting downThu Aug 28 13:46:34 2003ARC1: Archival stoppedThu Aug 28 13:46:39 2003Thread 1 advanced to log sequence 69802 Current log# 2 seq# 69802 mem# 0: /u09/oracle/TOOLS/redo02.logThread 1 advanced to log sequence 69803 Current log# 1 seq# 69803 mem# 0: /u09/oracle/TOOLS/redo01.logThu Aug 28 13:46:48 2003ORACLE Instance TOOLS - Can not allocate log, archival requiredARCH: Connecting to console port...Thread 1 cannot allocate new log, sequence 69804All 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 connectsys 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. DennisDatabase AdministratorCity 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
RE: How to log into a 9.2.0 database that has a hung archiver
not exactly. we have a process here that runs every 15 minutes or so, turns archiving off on each system, compress/moves the archive logs, then turns archiving back on On this system, the archive enable seems tofail. and the database hung because it couldn't automatically archive the logs. if this happens on an 8x or 7x system, I would just svrmgrl -- connect internal -- archive logs all -- (to free the logs) -- then reenable ayto archiving but on this 9.2 system, svrmgrl does not work and neither does connecting as '/ as sysdba', or 'sys as sysdba', or 'system as sysdba' what is the correct method to connect into the system when it is hung for some reason? S Shannon St. DennisDatabase AdministratorCity 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 [EMAIL PROTECTED] 08/28/03 04:04pm Shannon - Help me with the situation. Is this like when the archive disk isfull and Oracle politely waits until you make more space? For that situationI've always just moved some archive logs somewhere else and the databaseimmediately takes off. Is that your situation, or have I missed somethinghere?Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Thursday, August 28, 2003 4:24 PMTo: Multiple recipients of list ORACLE-Lsorryafter checking logs again, the connect / as sysdba command and sqlplus '/ assysdba' hung after issuing the command. a password was never requested.thanksshannon===Situation:Oracle EE 9.2.0 database on AIX v5.1tail alert_TOOLS.log:Thu Aug 28 13:46:31 2003ARC0: Evaluating archive log 1 thread 1 sequence 69800ARC0: Beginning to archive log 1 thread 1 sequence 69800Creating archive destination LOG_ARCHIVE_DEST_1:'/u00/oracle/archives/tools_69800.dbf'ARC0: Completed archiving log 1 thread 1 sequence 69800Thu Aug 28 13:46:33 2003Archive Log StopArchiving is disabledShutting down archive processesArchiving is disabledThu Aug 28 13:46:34 2003ARCH shutting downThu Aug 28 13:46:34 2003ARC0: Archival stoppedThu Aug 28 13:46:34 2003ARCH shutting downThu Aug 28 13:46:34 2003ARC1: Archival stoppedThu Aug 28 13:46:39 2003Thread 1 advanced to log sequence 69802 Current log# 2 seq# 69802 mem# 0: /u09/oracle/TOOLS/redo02.logThread 1 advanced to log sequence 69803 Current log# 1 seq# 69803 mem# 0: /u09/oracle/TOOLS/redo01.logThu Aug 28 13:46:48 2003ORACLE Instance TOOLS - Can not allocate log, archival requiredARCH: Connecting to console port...Thread 1 cannot allocate new log, sequence 69804All online logs needed archiving Current log# 1 seq# 69803 mem# 0: /u09/oracle/TOOLS/redo01.logso the archive hung.on our older 7x and 8x systems, I would do a svrmgrl and connect internalthen I would do an archive log all to archive the logson this 9.2.0 system, I tried sqlplus 'sys as sysdba' --- it hung afterasking for the passwordok... tried sqlplus /nolog --- then connect sys as sysdba -- hung afterasking for passwordok... tried sqlplus '/ as sysdba' -- hung after asking for passwordok... tried sqlplus /nolog -- then connect / as sysdba -- hung after askingfor passwordKilled smon to cause database to crash.sqlplus 'sys as sysdba' -- asked for password -- got the sql prompt -startupeverything worked.I'm glad this is a test database so I could kill it and restartbut what is the correct method to get a sql prompt on a hung database whensvrmgrl and connect internal aren't supported?ThanksShannonShannon St. DennisDatabase AdministratorCity 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 ofits DBA-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: How to log into a 9.2.0 database that has a hung archiver
well... I'm not arguing that they're poorly or well written. the problem is that with this one 9.2.0 instance, occasionally the start arch command will fail, the redo logs fill, and the system hangs. my question -- regardless of how poorly written the scripts are -- is how do I log into a hung 9.2.0 database to reenable archiving when a) I don't have svrmgrl or connect internal and b) all the combinations of sqlplus /nolog, sqlplus 'sys as sysdba', and sqlplus '/ as sysdba' do not work? What is the correct way to log into a hung database? Shannon St. DennisDatabase AdministratorCity 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 [EMAIL PROTECTED] 08/28/03 05:04pm Lemme guess: you're using home brewed shell scripts, not a product that can do it by itself, automagically, like NetBackup, Networker or SyncSort Backup? Well, your problem is that your scripts are badly written. If you're on a Unix box, I'll rewrite them for half what you would pay for Tivoli ior OmniBackup. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shannon St. DennisSent: Thursday, August 28, 2003 6:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: How to log into a 9.2.0 database that has a hung archiver not exactly. we have a process here that runs every 15 minutes or so, turns archiving off on each system, compress/moves the archive logs, then turns archiving back on On this system, the archive enable seems tofail. and the database hung because it couldn't automatically archive the logs. if this happens on an 8x or 7x system, I would just svrmgrl -- connect internal -- archive logs all -- (to free the logs) -- then reenable ayto archiving but on this 9.2 system, svrmgrl does not work and neither does connecting as '/ as sysdba', or 'sys as sysdba', or 'system as sysdba' what is the correct method to connect into the system when it is hung for some reason? S Shannon St. DennisDatabase AdministratorCity 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 [EMAIL PROTECTED] 08/28/03 04:04pm Shannon - Help me with the situation. Is this like when the archive disk isfull and Oracle politely waits until you make more space? For that situationI've always just moved some archive logs somewhere else and the databaseimmediately takes off. Is that your situation, or have I missed somethinghere?Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Thursday, August 28, 2003 4:24 PMTo: Multiple recipients of list ORACLE-Lsorryafter checking logs again, the connect / as sysdba command and sqlplus '/ assysdba' hung after issuing the command. a password was never requested.thanksshannon===Situation:Oracle EE 9.2.0 database on AIX v5.1tail alert_TOOLS.log:Thu Aug 28 13:46:31 2003ARC0: Evaluating archive log 1 thread 1 sequence 69800ARC0: Beginning to archive log 1 thread 1 sequence 69800Creating archive destination LOG_ARCHIVE_DEST_1:'/u00/oracle/archives/tools_69800.dbf'ARC0: Completed archiving log 1 thread 1 sequence 69800Thu Aug 28 13:46:33 2003Archive Log StopArchiving is disabledShutting down archive processesArchiving is disabledThu Aug 28 13:46:34 2003ARCH shutting downThu Aug 28 13:46:34 2003ARC0: Archival stoppedThu Aug 28 13:46:34 2003ARCH shutting downThu Aug 28 13:46:34 2003ARC1: Archival stoppedThu Aug 28 13:46:39 2003Thread 1 advanced to log sequence 69802 Current log# 2 seq# 69802 mem# 0: /u09/oracle/TOOLS/redo02.logThread 1 advanced to log sequence 69803 Current log# 1 seq# 69803 mem# 0: /u09/oracle/TOOLS/redo01.logThu Aug 28 13:46:48 2003ORACLE Instance TOOLS - Can not allocate log, archival requiredARCH: Connecting to console port...Thread 1 cannot allocate new log, sequence 69804All online logs needed archiving Current log# 1 seq# 69803 mem# 0: /u09/oracle/TOOLS/redo01.logso the archive hung.on our older 7x and 8x systems, I would do a svrmgrl and connect internalthen I would do an archive log all to archive the logson this 9.2.0 system, I tried sqlplus 'sys as sysdba' --- it hung afterasking for the passwordok... tried sqlplus /nolog --- then connect sys as sysdba -- hung afterasking for passwordok... tried sqlplus '/ as sysdba' -- hung after asking for passwordok... tried sqlplus /nolog -- then connect / as sysdba -- hung after askingfor passwordKilled smon to cause database to crash.sqlplus 'sys as sysdba' -- asked for password -- got the sql prompt -startupeverything worked.I'm glad this is a test database so I could kill it
Re: How to log into a 9.2.0 database that has a hung archiver
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 - From: Shannon St. Dennis To: Multiple recipients of list ORACLE-L 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 2003ARC0: Evaluating archive log 1 thread 1 sequence 69800ARC0: Beginning to archive log 1 thread 1 sequence 69800Creating archive destination LOG_ARCHIVE_DEST_1: '/u00/oracle/archives/tools_69800.dbf'ARC0: Completed archiving log 1 thread 1 sequence 69800Thu Aug 28 13:46:33 2003Archive Log StopArchiving is disabledShutting down archive processesArchiving is disabledThu Aug 28 13:46:34 2003ARCH shutting downThu Aug 28 13:46:34 2003ARC0: Archival stoppedThu Aug 28 13:46:34 2003ARCH shutting downThu Aug 28 13:46:34 2003ARC1: Archival stoppedThu Aug 28 13:46:39 2003Thread 1 advanced to log sequence 69802 Current log# 2 seq# 69802 mem# 0: /u09/oracle/TOOLS/redo02.logThread 1 advanced to log sequence 69803 Current log# 1 seq# 69803 mem# 0: /u09/oracle/TOOLS/redo01.logThu Aug 28 13:46:48 2003ORACLE Instance TOOLS - Can not allocate log, archival requiredARCH: Connecting to console port...Thread 1 cannot allocate new log, sequence 69804All 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 connectsys 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. DennisDatabase AdministratorCity 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
Windows 2000 Server and processor recommendations
We are going to be installing a small web application in our DMZ. The application was built using JSP, running on an Apache/tomcat configuration. The back end is small ( 1Gb) oracle standard edition database (v9.2.0) We are going to run this on a dual-processor dell server. There will be lots of OLTP (online lookups) but the actual transaction is very small (enter an address and it tells you where your polling station is). We have several options for configuring the server. What would be better? a) Dual Xeon 3.06GHz w/1M cache and 2GB Ram: $8,423 d) Dual Zeon 2.4Ghz w/512K cache and 4Gb Ram : $8,872 is it better to skimp slightly on the cpu's and go for more ram (ie. caching more)? Thanks for any info. Shannon Shannon St. DennisDatabase AdministratorCity 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
Re: convert number to word ???
I got this off of metalink: select to_char( to_date( 1, 'J' ), 'jsp' ) from dual; SQLselect to_char( to_date( 123,'J'), 'jsp') from dual; TO_CHAR(TO_DATE(123,'J') -- one hundred twenty-three SQLselect to_char( to_date( 123,'J'), 'Jsp') from dual; TO_CHAR(TO_DATE(123,'J') -- One Hundred Twenty-Three SQLselect to_char( to_date( 123,'J'), 'JSP') from dual; TO_CHAR(TO_DATE(123,'J') -- ONE HUNDRED TWENTY-THREE I suspect there is an upper limit imposed by some integer conversion or julian date thingy... Shannon Shannon St. DennisDatabase AdministratorCity 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 [EMAIL PROTECTED] 08/22/03 03:19pm Hi,Is there a function that can conver number to word? ef: 100 is ONE HUNDRED, 2003 is TWO THOUSAND ANDTHREE. Thank you in advanced!!!__Do you Yahoo!?Yahoo! Calendar - Free online calendar with sync to Outlook(TM).http://calendar.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Andrea Oracle INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Oracle Metalink
please tell me metalink is down and that they haven't revoked my membership! Shannon St. DennisDatabase AdministratorCity 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