perl adcfgclone.pl dbTier
Problem Summary
Cloning Error – DB server -WARNING: RC-40201: Unable to connect to Database
Problem Description
——————-ADX Database Utility Finished—————
conn is null
WARNING: RC-40201: Unable to connect to Database TESTPROD.
StackTrace:
java.lang.Exception: Cannot connect to database using DBUtil
at oracle.apps.ad.clone.ApplyDatabase.checkDBConnection(ApplyDatabase.java:3363)
at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:569)
at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:502)
at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:393)
at oracle.apps.ad.clone.ApplyDBTier.(ApplyDBTier.java:116)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at oracle.apps.ad.clone.util.CloneProcessor.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
WARNING: DEBUG: checkDBConnection out()
Testing for RAC enabled context values
prior to listener startup and database restore…
Verifying correctness of adcrdbclone.sql
WARNING: RC-00115: Not able to read system25.dbf
Raised by oracle.apps.ad.clone.ApplyDatabase
WARNING: RC-00115: Not able to read system24.dbf
Raised by oracle.apps.ad.clone.ApplyDatabase
WARNING: RC-00115: Not able to read system23.dbf
Raised by oracle.apps.ad.clone.ApplyDatabase
WARNING: RC-00115: Not able to read system22.dbf
Raised by oracle.apps.ad.clone.ApplyDatabase
WARNING: RC-00115: Not able to read system21.dbf
Raised by oracle.apps.ad.clone.ApplyDatabase
WARNING: RC-00115: Not able to read system20.dbf
Raised by oracle.apps.ad.clone.ApplyDatabase
WARNING: RC-00115: Not able to read system19.dbf
Raised by oracle.apps.ad.clone.ApplyDatabase
WARNING: RC-00115: Not able to read system18.dbf
tarting synchronization of file system Context file and its templates with those in the database
Database connection : Failed
OAM Context editing support feature: Unverified
OAM Customization support feature : Unverified
File system template : /predb/TESTPROD/db/tech_st/12.1.0/appsutil/template/adxdbctx.tmp
Checking for customizations to Context template
Warning: Unable to connect to Database.
If the system is OAM enabled, this may result in loss of customizations.
Looking for custom template at : /predb/TESTPROD/db/tech_st/12.1.0/appsutil/template/custom/adxdbctx.tmp
Custom template : Not Available
Customizations found : None
File system Context file :/predb/TESTPROD/db/tech_st/12.1.0/appsutil/TESTPROD_preproddb.xml
Checking the Context file for possible updates from the Database
Warning: Unable to connect to Database.
If the system is OAM enabled, this may result in loss of customizations and the Context files in DataBase and in the file system may be unsynchronized
===========================================================================
Starting Updates of Context file Sat Jun 04 02:01:48 IST 2022
found context version : 120.52.12020000.14
available update version : 120.52.12020000.14
No updates to apply
Ending Updates of Context file
===========================================================================
Starting Context Value Management System at Sat Jun 04 02:01:48 IST 2022
Using version 120.14.12020000.5
Options:
Force : no
Contextfile : /predb/TESTPROD/db/tech_st/12.1.0/appsutil/TESTPROD_preproddb.xml
Templatefile : /predb/TESTPROD/db/tech_st/12.1.0/appsutil/template/adxdbctx.tmp
ValueUpdateFile : /predb/TESTPROD/db/tech_st/12.1.0/appsutil/template/adcvmdb.xml
Verifying value management system requirements:
ContextFile : VALID
Template File : VALID
ValueUpdateFile : VALID
Parsing the ValueUpdateFile
[ s_contextfile ]
Action : seed
Change reason : Setting the location to what has been specified by user
New value : /predb/TESTPROD/db/tech_st/12.1.0/appsutil/TESTPROD_preproddb.xml
===========================================================================
[ Config tool : /predb/TESTPROD/db/tech_st/12.1.0/appsutil/bin/txkSetADOPPatchSrvName.sh ]
Command : /predb/TESTPROD/db/tech_st/12.1.0/appsutil/bin/txkSetADOPPatchSrvName.sh PASSWORD contextfile=/predb/TESTPROD/db/tech_st/12.1.0/appsutil/TESTPROD_preproddb.xml -exectier=db -promptmsg=hide
Action : execute
SCRIPT RETURNED:
Refer log file /predb/TESTPROD/db/tech_st/12.1.0/appsutil/log/TXK_PATCH_SRV_Sat_Jun_4_02_01_49_2022/txkSetADOPPatchSrvName.log for details
ERROR DESCRIPTION:
(FATAL ERROR
PROGRAM : (/predb/TESTPROD/db/tech_st/12.1.0/appsutil/bin/txkSetADOPPatchSrvName.pl)
TIME : Sat Jun 4 02:01:49 2022
FUNCTION: main::getDBConnectionAsAPPS [ Level 1 ]
ERRORMSG: DB Connection failed.
)
ERRORCODE = 1 ERRORCODE_END
.end std out.
.end err out.
Result : FAILED
===========================================================================
[ Config tool : /predb/TESTPROD/db/tech_st/12.1.0/appsutil/bin/txkCreateEBSPDBService.sh ]
Command : /predb/TESTPROD/db/tech_st/12.1.0/appsutil/bin/txkCreateEBSPDBService.sh PASSWORD contextfile=/predb/TESTPROD/db/tech_st/12.1.0/appsutil/TESTPROD_preproddb.xml -promptmsg=hide
Action : execute
SCRIPT RETURNED:
Refer log file /predb/TESTPROD/db/tech_st/12.1.0/appsutil/log/TXK_CREATE_PDB_SRV_Sat_Jun_4_02_01_50_2022/txkCreateEBSPDBService.log for details
ERROR DESCRIPTION:
(FATAL ERROR
PROGRAM : (/predb/TESTPROD/db/tech_st/12.1.0/appsutil/bin/txkCreateEBSPDBService.pl)
TIME : Sat Jun 4 02:01:50 2022
FUNCTION: main::getDBConnectionAsAPPS [ Level 1 ]
ERRORMSG: DB Connection failed.
)
ERRORCODE = 1 ERRORCODE_END
.end std out.
.end err out.
Solution: Cloning process taken from RMAN Backup, But wrongly started the using perl adcfgclone.pl dbTier
now started perl adcfgclone.pl dbTechStack now working fine.