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]
Which two file ?