Oracle Stream - ORACLE initialization or shutdown in progress

From: gidhin joy <gidhin_at_gmail.com>
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-l
Received on Thu Feb 26 2009 - 01:44:10 CST

Original text of this message