Oracle Stream - ORACLE initialization or shutdown in progress
Date: Thu, 26 Feb 2009 13:14:10 +0530
Message-ID: <97e490bc0902252344l74230822y484003f66d699d6_at_mail.gmail.com>
Dear All,
I have configured Oracle stream for one of the table and ran into some issues,
Configuration was done without any issues but after starting the apply process, changes in source is not reflecting in destination.
As i start troubleshooting,found below messages from bdump trace files,
error 1033 in job queue process
ORA-01033: ORACLE initialization or shutdown in progress
ORA-02068: following severe error from VISTDEV
*ORA-01033: ORACLE initialization or shutdown in progress*
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7224
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7502
ORA-06512: at "SYS.DBMS_AQADM", line 978
ORA-06512: at line 1
Just for checking I tried to connect to destination database from sqlplus and seen a very abnormal behavior,
*$ sqlplus strmadmin/strmadmin_at_vistdev*
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 26 11:58:41 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
ERROR: ORA-01033: ORACLE initialization or shutdown in progress
Enter user-name: ^C
$
*$ sqlplus strmadmin/strmadmin_at_vistdev*
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 26 11:58:46 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> select open_mode from v$database;
OPEN_MODE
READ WRITE Anybody faced similar problem,Please help
Thanks,
Gidhin
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 26 2009 - 01:44:10 CST