Re: How to log into a 9.2.0 database that has a hung archiver

2003-08-28 Thread Shannon St. Dennis
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

RE: How to log into a 9.2.0 database that has a hung archiver

2003-08-28 Thread Shannon St. Dennis
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

RE: How to log into a 9.2.0 database that has a hung archiver

2003-08-28 Thread Shannon St. Dennis
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 to fail.  and the database hung because it couldn't automatically archive the l

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

2003-08-28 Thread Shannon St. Dennis
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 A

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

2003-08-28 Thread Shannon St. Dennis
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.

Windows 2000 Server and processor recommendations

2003-08-27 Thread Shannon St. Dennis
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

Re: convert number to word ???

2003-08-22 Thread Shannon St. Dennis
I got this off of metalink:   select to_char( to_date( &&1, 'J' ), 'jsp' ) from dual;   SQL> select to_char( to_date( 123,'J'), 'jsp') from dual; TO_CHAR(TO_DATE(123,'J') -- one hundred twenty-three   SQL> select to_char( to_date( 123,'J'), 'Jsp') from dual; T

Oracle Metalink

2003-07-30 Thread Shannon St. Dennis
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