Oracle Stream - ORACLE initialization or shutdown in progress

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@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@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

Other related posts:

  • » Oracle Stream - ORACLE initialization or shutdown in progress - gidhin joy