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