Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

QA database won't start after Production-QA sync up

a05121c6-8166-41ea-b52d-c08865f07c96Jul 26 2016 — edited Jul 27 2016

For a test activity we asked the server team to sync up qa to production. The server has a HP Unix file system and a total of 4 databases. 3 of them started successfully but 1 failed. A similar activity was performed in 2014 which was successful. Logs for both activity are provided below. Can someone help me with this ?

Logs for 2014 when the activity was successful

Database dismounted.

ORACLE instance shut down.

SQL> SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production


* Renaming Database from shppr2 to shpqapr2 *


SQL*Plus: Release 9.2.0.7.0 - Production on Fri May 23 10:13:55 2014

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL> SQL> ORACLE instance started.

Total System Global Area 572485320 bytes

Fixed Size 736968 bytes

Variable Size 335544320 bytes

Database Buffers 234881024 bytes

Redo Buffers 1323008 bytes

SQL> Control file created.

SQL> Database altered.

SQL> SQL> Database closed.

Logs for 2016 when the database won't start

Database dismounted.

ORACLE instance shut down.

SQL> SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production


* Renaming Database from shppr2 to shpqapr2 *


SQL*Plus: Release 9.2.0.7.0 - Production on Tue Jul 26 10:41:27 2016

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected. SQL> SQL> ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> CREATE CONTROLFILE REUSE set DATABASE "SHPQAPR2" RESETLOGS ARCHIVELOG * ERROR at line 1: ORA-01012: not logged on

SQL> alter database open resetlogs * ERROR at line 1: ORA-01012: not logged on

SQL> SQL> ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-01089: immediate shutdown in progress - no operations are permitted

SQL> Disconnected

fail 1 ## 10:41:29 ## ERROR... Errors found when changing the SID of the database check file ->/home/oracle/renamedb/tmp/tmp2.23976.1 logout

Comments

Vishal Gupta

Anyone seen this error?

Hi VishalGupta,

1/Which version of SQLDeveloper are you using the recent 4.0 EA or the Production 3.2.2?

2/I have not seen the error you mention (unless there is a typing error in the command).

3/There was a problem with 3.2.2 - need to set the PATH otherwise SQLDeveloper may get confused with another version of SQLDeveloper stored in /opt and referenced elsewhere in the PATH ('which sqldeveloper' to see where it is)

4/I had to use a full path for the file name i.e. /tmp/vg.html on my test case (which did not reproduce your issue) (*)

5/'force_print' in html script output is a bug

(*)export PATH=`pwd`:$PATH ; bash ./sdcli reports generate -report z -db DB_NAME -file /tmp/zzq4.html

Oracle SQL Developer

Copyright (c) 1997, 2013, Oracle and/or its affiliates. All rights reserved.

Java asserts are enabled!

Success!

-Turloch

SQLDeveloper Team

Vishal Gupta

Turloch,

Thanks for the reply.  I was using SQL Developer 4.0 EA1. I noticed that my problem was because of the space in the report name. See following link.

SQLDev4 - sdcli - space in report name (Linux/Mac)

Regards,

Vishal Gupta

http://blog.vishalgupta.com

Barry Mcgillin-Oracle
Answer

Vishal,

Youre right. I just fixed this under bug 17221719

B

Marked as Answer by Vishal Gupta · Sep 27 2020
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 24 2016
Added on Jul 26 2016
1 comment
360 views