Error Occurred In Applydatabase Rc-50004 on adcfgclone on DB tier (Doc ID 360343.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When attempting to run perl ./bin/adcfgclone.pl dbTier,
the following error occurs.

ERROR
Running Rapid Clone with command:
perl
<RDBMS_ORACLE_HOME>/appsutil/clone/bin/adclone.pl java=<RDBMS_ORACLE_HOME>/appsutil/clone/bin/../jre/1.3.1/jre mode
=apply
stage=<RDBMS_ORACLE_HOME>/appsutil/clone/bin/..component
=dbTier method=CUSTOM
dbctxtg=<RDBMS_ORACLE_HOME>/appsutil/<SID>_<HOST>.xml showProgress contextValidated=true

/etc/oraInst.loc points to an Inventory that does not exist:
/............./oraInventory
Inventory Directory created...
Beginning database tier Apply - Mon Feb 27 15:42:19 2006
Log file located at
<RDBMS_ORACLE_HOME>/appsutil/log/<SID>_<HOST>/ApplyDBTier_02270342.log
RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed

ERROR while running Apply...

ERROR: Failed to execute
<RDBMS_ORACLE_HOME>/appsutil/clone/bin
/adclone.pl

Please check logfile.

Also in the ApplyDBTier_XXXXXXXX.log  file you may see:

ALTER DATABASE RENAME GLOBAL_NAME TO "<SID>.<DOMAIN>"
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 418 cannot be read at this time
ORA-01111: name for data file 418 is unknown - rename to correct file
ORA-01110: data file 418:
'/<DIR>/home/dba/oracle/product/<SID>db/9.2.0/dbs/MISSING00418'


ORA-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s],
[%s], [%s]


Connected.
ORA-01031: insufficient privileges
BEGIN dbms_backup_restore.zeroDbid(0); END;

*
ERROR at line 1:
ORA-01012: not logged on


ORA-01031: insufficient privileges
Connected to an idle instance.
ORA-01081: cannot start already-running ORACLE - shut it down first
CREATE CONTROLFILE REUSE SET DATABASE "<SID>"
*
ERROR at line 1:
ORA-01012: not logged on


alter database open resetlogs
*
ERROR at line 1:
ORA-01012: not logged on


alter tablespace TEMP add tempfile '/<DIR>/ORACLE/<SID>/temp01.dbf' REUSE
*
ERROR at line 1:
ORA-01012: not logged on


alter tablespace TEMP add tempfile '/<DIR>/ORACLE/<SID>/temp01b.dbf' REUSE
*
ERROR at line 1:
ORA-01012: not logged on


alter tablespace TEMP add tempfile '/<DIR>/ORACLE/<SID>/temp01c.dbf' REUSE
*
ERROR at line 1:
ORA-01012: not logged on


ALTER DATABASE RENAME GLOBAL_NAME TO "<SID>.<DOMAIN>"
*
ERROR at line 1:
ORA-01012: not logged on
............................

SP2-0359: memory exhausted
Disconnected
exit_code=1

Checking for errors ...

ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 418 cannot be read at this time
ORA-01111: name for data file 418 is unknown - rename to correct file
ORA-01110: data file 418:
ORA-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s],
ORA-01031: insufficient privileges
ORA-01012: not logged on
ORA-01031: insufficient privileges
ORA-01081: cannot start already-running ORACLE - shut it down first
ORA-01012: not logged on
.................

getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : <HOST>
sDbDomain : <DOMAIN>
sDbPort : <PORT>
sDbSid : <SID>
sDbUser : apps
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@<HOST>.<DOMAIN>:<PORT>:<SID>
Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 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=<HOST>.
<DOMAIN>)(PORT=<PORT>))(CONNECT_DATA=(SERVICE_NAME=<SID>)))
Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 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=<HOST>.
<DOMAIN>)(PORT=<PORT>))(CONNECT_DATA=(SERVICE_NAME=<SID>.<DOMAIN>)))
Exception occurred: java.sql.SQLException: Io exception: Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=153093888)(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:658)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154)
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:513)

STEPS
The issue can be reproduced at will with the following steps:
1. Applied following patches:
AD.I.2(patch 4337683
TXK (FND) AUTOCONFIG TEMPLATE ROLLUP PATCH L patch 4489303
ADX.F patch 3453499
Post AD.I Consolidated 09/01/05 patch 4502904
9iAS 1.0.2.2.2
Developer 6i Patch 17 patch 4183804
Upgrade to J2SE Version 1.4.2 on AIX
Post AD.I Consolidated 09/01/05 patch 4502904

2. Ran adpreclone on source
3. perl ./bin/adcfgclone.pl dbTier

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.