Advertisement

04.02.2008 at 03:31AM PDT, ID: 23288654
[x]
Attachment Details

ora-01033 oracle initialization or shutdown in progress

Asked by Kerbeross in Oracle 8.x

Tags: Oracle, Oracle 8.1.7, 8.1.7, Activating standby database

Hi Experts,
I need to activate my standby database at DR in order to restore a table that was previously destroyed at primary. I had restored COLD backup a day before the incident. Successfully did, I applied some ARClog into the standby db, and also success.
Now i need to activate the db before starting to export out that one table, i then need to login into this standby db using id sc, same password. The problem occured like below.

Please help since I need to recover back this one table URGENTLY, or I'll get fired!

Your all experts help is kindly appreciated.

Thanks in advance.

Start Free Trial
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
The id is oracle
$ id      
uid=1001(oracle) gid=1002(oinstall)
 
Then, entering server manager,
 
$ svrmgrl
 
Oracle Server Manager Release 3.1.7.0.0 - Production
 
Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.
 
Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.0.0 - 64bit Production
 
SVRMGR> connect / as sysdba;
Connected.
 
Starting database...
 
SVRMGR> startup
ORACLE instance started.
Total System Global Area                        281550524 bytes
Fixed Size                                         102076 bytes
Variable Size                                   278081536 bytes
Database Buffers                                  3276800 bytes
Redo Buffers                                        90112 bytes
ORA-01666: controlfile is for a standby database
 
starting db looks normal except the ORA-01666.
 
SVRMGR> exit
Server Manager complete.
 
Trying to login using sc...
 
$ sqlplus sc/sc
 
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 2 17:34:08 2008
 
(c) Copyright 2000 Oracle Corporation.  All rights reserved.
 
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
 
 
Enter user-name: sc
Enter password: 
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
 
 
Enter user-name: sc
Enter password: 
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
 
 
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
 
The problem in bold.
Then, trying to export svmr table...
 
$ exp sc/sc file=sv.dmp tables=svmr
 
Export: Release 8.1.7.0.0 - Production on Wed Apr 2 17:43:52 2008
 
(c) Copyright 2000 Oracle Corporation.  All rights reserved.
 
 
EXP-00056: ORACLE error 1033 encountered
ORA-01033: ORACLE initialization or shutdown in progress
Username: 
Password: 
 
EXP-00056: ORACLE error 1033 encountered
ORA-01033: ORACLE initialization or shutdown in progress
Username: 
Password: 
 
EXP-00056: ORACLE error 1033 encountered
ORA-01033: ORACLE initialization or shutdown in progress
EXP-00005: all allowable logon attempts failed
EXP-00000: Export terminated unsuccessfully
$
 
Loading Advertisement...
 
[+][-]04.02.2008 at 06:18AM PDT, ID: 21262672

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.02.2008 at 06:25AM PDT, ID: 21262745

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.02.2008 at 06:27AM PDT, ID: 21262761

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.02.2008 at 06:21PM PDT, ID: 21269072

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.09.2008 at 05:36AM PDT, ID: 21314179

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Oracle 8.x
Tags: Oracle, Oracle 8.1.7, 8.1.7, Activating standby database
Sign Up Now!
Solution Provided By: Kerbeross
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628