FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedFeb 26, '09 at 7:44a
activeFeb 26, '09 at 7:44a
posts1
users1
websiteoracle.com

1 user in discussion

Gidhin joy: 1 post

People

Translate

site design / logo © 2022 Grokbase