Monthly Archives: May 2009

RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation failed

Problem:

When cloning the database tier of Illuminat HRMS Production, the process fails on 70% with error:

Beginning database tier Apply - Wed May 27 10:12:21 2009
Log file located at /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/ApplyDBTier_05271012.log
RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed
ERROR while running Apply...
 ERROR: Failed to execute adclone.pl
 Please check logfile.
Log file /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/ApplyDBTier_05271012.log showed:
---------------------------------------------------------------
                   ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : ebusinesstest
    sDbDomain  : illuminatnm.com
    sDbPort    : 1523
    sDbSid     : TEST2
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@ebusinesstest.illuminatnm.com:1523:TEST2
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2)))
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2.illuminatnm.com)))
    Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092864)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
    Connection could not be obtained; returning null
-------------------ADX Database Utility Finished---------------
adcrdb.sh started at Wed May 27 10:54:18 AST 2009
The environment settings are as follows ...
       ORACLE_HOME : /u0/oracle/TEST2/test2db/9.2.0
        ORACLE_SID : TEST2
          TWO_TASK :
              PATH : /u0/oracle/TEST2/test2db/9.2.0/Apache/perl/bin:/u0/oracle/TEST2/test2db/9.2.0/bin:/usr/bin:/usr/sbin:/u0/oracle/TEST2/test2db/9.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:../jre/1.3.1/bin:/u0/oracle/testdb/9.2.0/Apache/perl/bin:/usr/kerberos/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:.
   LD_LIBRARY_PATH : /u0/oracle/TEST2/test2db/9.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u0/oracle/TEST2/test2db/9.2.0/ctx/lib
Executable : /u0/oracle/TEST2/test2db/9.2.0/bin/sqlplus
The log information will be written to
        /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/adcrdb_TEST2.txt
Creating the control file for TEST2_ebusinesstest database ...
SQL*Plus: Release 9.2.0.3.0 - Production on Wed May 27 10:54:18 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to an idle instance.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area  581506100 bytes
Fixed Size                   451636 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
Control file created.
Database altered.
Tablespace altered.
Database altered.
Database closed.
Database dismounted.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area  581506100 bytes
Fixed Size                   451636 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
Database mounted.
BEGIN dbms_backup_restore.zeroDbid(0); END;
*
ERROR at line 1:
ORA-01119: error in creating database file
'/u0/oracle/TEST2/test2db/9.2.0/dbs/MISSING00395'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284
ORA-06512: at line 1
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area  581506100 bytes
Fixed Size                   451636 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
Control file created.
Database altered.
Tablespace altered.
Database altered.
old   2:     '/u0/oracle/TEST2/test2db/9.2.0/ctx/lib/libctxx9.&libext'
new   2:     '/u0/oracle/TEST2/test2db/9.2.0/ctx/lib/libctxx9.so'
Library created.
old   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libqsmashr.&libext'
new   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libqsmashr.so'
Library created.
old   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libordim9.&libext'
new   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libordim9.so'
Library created.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
exit_code=0
Checking for errors ...
ORA-01119: error in creating database file
ORA-27037: unable to obtain file status
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284
ORA-06512: at line 1
The database has not been successfully created. Shutting down the instance ...
SQL*Plus: Release 9.2.0.3.0 - Production on Wed May 27 10:57:56 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected.
ORACLE instance shut down.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
.end std out.
.end err out.
---------------------------------------------------------------
                   ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : ebusinesstest
    sDbDomain  : illuminatnm.com
    sDbPort    : 1523
    sDbSid     : TEST2
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@ebusinesstest.illuminatnm.com:1523:TEST2
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2)))
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2.illuminatnm.com)))
    Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092864)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
    Connection could not be obtained; returning null
-------------------ADX Database Utility Finished---------------
RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase
StackTrace:
java.lang.Exception: Control file creation failed
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:469)
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:314)
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:290)
        at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:131)
        at java.lang.reflect.Constructor.newInstance(Native Method)
        at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
        at java.lang.Thread.run(Thread.java:479)

Solution:

The cloning process omits two files that were created since the last adpreclone.pl run. Therefore, run preclone scripts (adpreclone.pl) on the production instance before copying files.

[amazon asin=0070077290&template=iframe image&chan=default]    [amazon asin=1453742735&template=iframe image&chan=default]    [amazon asin=0615238440&template=iframe image&chan=default]

Database Media Recovery of 11i Instance

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:Documents and Settingsoracle>f:
F:>cd oracleproddb9.2.0
F:oracleproddb9.2.0>PROD_hostname.cmd
ECHO is off.
ECHO is off.
Tue 05/19/2009 09:49 AM
PROD_hostname.cmd exiting with status 0
F:oracleproddb9.2.0>sqlplus apps/apps
SQL*Plus: Release 9.2.0.7.0 - Production on Tue May 19 09:49:27 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Enter user-name: / as sysdba
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 831725752 bytes
Fixed Size 454840 bytes
Variable Size 411041792 bytes
Database Buffers 409600000 bytes
Redo Buffers 10629120 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:ORACLEPRODDATASYSTEM01.DBF'
SQL> recover automatic database
Media recovery complete.
SQL> alter database open;
Database altered.
SQL> select * from v$database;
NAME
---------
PROD
SQL>