Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 436 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
QA database won't start after Production-QA sync up

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
Answers
-
Hi,
1. We don't know what is your process of sync-up
2. We have no diea about the parameters -- as from control file you are setting up new database name
3. You are DBA's of your environment -- you should dig up from you side and post the step by step what is the process (not the description of issue)
4. Does the last shutdown went fine ? can you verify shared memory segments
Connected. SQL> SQL> ORA-01081: cannot start already-running ORACLE - shut it down first
Being a DBA basic check is already running how come you perform controlfile ? have you check atleast whether its in nomount ? Basics of DBA
You need to study -- else contact your senior colleagues in your team
- Pavan Kumar N