Cloning Error – DB server -WARNING: RC-40201: Unable to connect to Database

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.

ADOP (Online Patch ) 12.2 Steps

Leave a Comment

Your email address will not be published.