adcfgclone.pl errors

Posted by Abdulselam khan on Mar 30, 2015; 10:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/adcfgclone-pl-errors-tp265.html

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