oracle database appears to hang in Portal when you enable automatic archive --------------------------------------------------------------------------- bash-2.05b$ pwd /oracle/dbtest/9ias/admin/iasdb1/bdump bash-2.05b$ less alert_iasdb1.log ... Tue Nov 18 02:31:16 2003 ORACLE Instance iasdb1 - Can not allocate log, archival required Tue Nov 18 02:31:16 2003 ARCH: Connecting to console port... Thread 1 cannot allocate new log, sequence 25 All online logs needed archiving Current log# 2 seq# 24 mem# 0: /oracle/dbtest/9ias/oradata/iasdb1/redo02.log ... And you cann't bind OID how to fix it: bash-2.05b$ sqlplus "/ as sysdba" SQL*Plus: Release 9.0.1.4.0 - Production on Tue Nov 18 13:29:34 2003 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production With the Partitioning option JServer Release 9.0.1.4.0 - Production SQL> Archive log list; Database log mode Archive Mode Automatic archival Disabled Archive destination /oracle/dbtest/9ias/dbs/arch Oldest online log sequence 22 Next log sequence to archive 22 Current log sequence 24 SQL> Alter system archive log all; System altered. SQL> Archive log list; Database log mode Archive Mode Automatic archival Disabled Archive destination /oracle/dbtest/9ias/dbs/arch Oldest online log sequence 23 Next log sequence to archive 25 Current log sequence 25 And you can bind OID now! bash-2.05b$ pwd /oracle/dbtest/9ias/admin/iasdb1/pfile bash-2.05b$ diff initiasdb1.ora initiasdb1.ora.orig 85,86d84 < log_archive_start=true < Reference --------- ORACLE Instance XXXX - Cannot allocate log. Archival required <http://www.cryer.co.uk/brian/oracle/SYMoixcal.htm> |