adcfgclone.pl errors

[Abdulselam khan]

I am getting errors when running the adcfgclone.pl Script

adcfgclone.pl can not create tns correct .  
 
Log file :

ADX Database Utility
---------------------------------------------------------------

getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL=''
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    :xxxxxxxx
    sDbDomain  : xxxxxxx
    sDbPort    :
    sDbSid     : ORADEV
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@xxxxxx.com::ORADEV
WARNING:     Exception occurred: java.sql.SQLException: Invalid number format for port number
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxxx.com)(PORT=))(CONNECT_DATA=(SERVICE_NAME=ORADEV)))
WARNING:     Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxxxxx.com)(PORT=))(CONNECT_DATA=(SERVICE_NAME=ORADEV.xxxxxxxx.com)))
WARNING:     Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection



*******FATAL ERROR*******
PROGRAM : (/u01/install/APPSDEVEL/fs2/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkManageDBConnectionPool.pl)
TIME    : Mon Mar 30 10:18:11 2015
FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]
ERRORMSG: Invalid APPS database user credentials. No updates Performed



adgendbc.sh started at Mon Mar 30 10:18:56 EEST 2015
SQL*Plus: Release 10.1.0.5.0 - Production on Mon Mar 30 10:18:57 2015
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12533: TNS:illegal ADDRESS parameters



Creating the DBC file...
java.sql.SQLException: No suitable driver found for
Database connection to  failed
ADD call failed with exit code 1
Updating Server Security Authentication
java.sql.SQLRecoverableException: IO Error: Invalid number format for port number
Database connection to jdbc:oracle:thin:@host_name:port_number:database failed
Updating Server Security Authentication failed with exit code 1
Restoring DBC file from backed up location /u01/install/APPSDEVEL/fs2/inst/apps/ORADEV_xxxxxxxxx/appltmp/TXK/ORADEV_Mon_Mar_30_10_18_2015.dbc

[ErmanArslansOracleBlog]

Please send me the complete inputs that you have entered while running the adcfgclone.pl.

[Abdulselam khan]

Target System Instance Top set to /u01/install/APPSDEVEL/fs2/inst/apps/ORADEV_xxxxxxxx

Target System Port Pool [0-99] : 1

Checking the port pool 1
done: Port Pool 1 is free
Report file located at /u01/install/APPSDEVEL/fs2/inst/apps/ORADEV_xxxxxxxxx/admin/out/portpool.lst
Complete port information available at /u01/install/APPSDEVEL/fs2/inst/apps/ORADEV_xxxxxxxxxx/admin/out/portpool.lst

[Abdulselam khan]

Do you want to add a node (yes/no) [no] :

Enter the full path of Run File System Context file : /u01/install/APPSDEVEL/fs1/inst/apps/ORADEV_xxxxxxxxxxxx/appl/admin/ORADEV_xxxxxxxxx.xml

Target System File Edition type [run] : patch

[Abdulselam khan]

I am attaching the log of post clone

[ErmanArslansOracleBlog]

You didnt attach the logfile?

[ErmanArslansOracleBlog]

Anyways,

Please check  the following and paste the contents here;

select * from FND_DATABASES;

select * from FND_DATABASE_SERVICES;

[Abdulselam khan]

sorry  I am attaching the log of post clone again
also I attached result of quqeries ApplyAppsTier_03301508.log
FND_DATABASE_SERVICES.png
FND_DATABASES;.png

[ErmanArslansOracleBlog]

Check the contextfile from the database;

I mean ; the table FND_OAM_CONTEXT_FILES

select * from FND_OAM_CONTEXT_FILES and open the xml file using an editor like TOAD.
Check to see if the s_dbhost is not null there?

[ErmanArslansOracleBlog]

You didnt reply, but here is the action plan.. It s worth to try..

Take a backup of fnd_oam_context_files
truncate fnd_oam_context_files
execute and autoconfig in the run edition
retry postclone.

[Abdulselam khan]

thanks for your feedbacks Erman
I truncated table fnd_oam_context_files  and execute autoconfig
thanks to you issue resolved

[Roshan]

I got same issue and its resolved. Thanks very much.
When I run the adop with downtime command it says run ETCC dbcheck
 for database node.
when i run it it remains stuck at
The opatch utility is at the required version.

[ErmanArslansOracleBlog]

This is another issue , which should be investigated using a new forum entry, but I will answer it from here for this time.

You are running checkDBPatch.sh right?

So, in checkDBPatch.sh , the following commands should be running just after "The opatch utility is at the required version."

# get the list of patches
 $OPATCH lspatches -bugs > ${oplist}
 exit_code=$?
 
 if test "$exit_code" != "0" ; then
     printf "\nError running opatch. Error code : ${exit_code}\n"| tee -a $LOGFILE
     printf "\n\nTherefore, cannot check bugfixes applied to the Database ORACLE_HOME."| tee -a $LOGFILE
     rm -rf ${PTCH_TMP}  
     printf "\nExiting.\n"| tee -a $LOGFILE
     exit 1
 fi


Well, it must be stuch while running the command opatch lspatches -bugs
Please check that command , execute it manually, maybe it is because of your environment or maybe it is an inventory problem.
Just execute it manually and see if there is a problem, if not check your environment and this document:
How To Run The 12.2 EBS Technology Code Level Checker (ETCC) ? (Doc ID 2008451.1)

[Roshan]

Thank very much for the advice Erman. I checked the inventory. It was permission problem. i gave it root permission and oracle home was not attached.

[Roshan]

what was the reason for truncating FND_OAM_CONTEXT_FILES table and running autoconfig? as an apps dba, do we need to know all the fnd tables?

[ErmanArslansOracleBlog]

That table stores the context_files. There are stored there as versioned .
So if there is a problem with the context file, a truncating it may resolve, because in some cases, autoconfig read the context_files from there. (especially when there are no context files yet, such as during cloning operation)

There is no need to truncate it everytime. This instruction that I gave to you was only for your specific case.
As Apps DBA you don't need to know all the fnd-tables. But if you know then, you become a wise apps dba :)

[Roshan]

The table contains the path of context files and template. If there is no context files during cloning it uses the template to build a new one?

[ErmanArslansOracleBlog]

Did you check the table?
Did you read the defitinion which is publicly available?

FND_OAM_CONTEXT_FILES stores all context files and metadata file belongs to the application instance. Each Row contains context name, actual context file, and version of file. There will be one metadata file for the entire Applications instance.

Also Check this note Autoconfig Reverts To Old Context File Values (Doc ID 357922.1)


Note that, there is a column named "text" there. It is a clob and context file contents are stored there.
See its defitinion below;

->
Columns

Name Datatype Length Mandatory Comments
NAME VARCHAR2 (512) Yes Context Name parsed from context file
VERSION VARCHAR2 (30) Yes File version parsed from file
PATH VARCHAR2 (1024) Yes Full file path
LAST_SYNCHRONIZED DATE
Yes Last upload or download time
TEXT CLOB (4000) Yes File contents
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column
NODE_NAME VARCHAR2 (30) Yes Node name where context file is located
STATUS VARCHAR2 (1)
status of writing back file to file system
SERIAL_NUMBER NUMBER

serial number used for comparing file system contents with db contents
EDIT_COMMENTS VARCHAR2 (2000)
user specified comments
CTX_TYPE VARCHAR2 (1) Yes used to specify context file for Database/Apps

[Roshan]

Thanks. I checked the table.