Forum Stats

  • 3,770,491 Users
  • 2,253,125 Discussions
  • 7,875,485 Comments

Discussions

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

Tagged:

Answers

  • Pavan Kumar
    Pavan Kumar Member Posts: 11,904 Gold Crown
    edited Jul 27, 2016 12:23AM

    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

This discussion has been closed.