Symptoms

Error running perl adcfgclone.pl dbTier

---------------------------------------------------------------
                       ADX Database Utility
    ---------------------------------------------------------------
    
    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_user>
        Trying to connect using SID...
    getConnectionUsingSID() -->
        JDBC URL: jdbc:oracle:thin:@host:port:sid
        Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    SVR4 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=xxx)(PORT=port))(CONNEC_DATA=(SERVICE_NAME=xxx)))
        Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    SVR4 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=xxx)(PORT=port))(CONNEC_DATA=(SERVICE_NAME=xxx)))
        Exception occurred: java.sql.SQLException: Io exception: Connection
    refused(DESCRIPTION=(TMP=)(VSNNUM=xxx)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
        Connection could not be obtained; returning null
    
    -------------------ADX Database Utility Finished---------------
    
    adcrdb.sh started at date()
    
    The environment settings are as follows ...
    
           ORACLE_HOME : 
            ORACLE_SID : 
              TWO_TASK :
                  PATH :
           LD_LIBRARY_PATH :
       
    Executable : <RDBMS ORACLE_HOME>/bin/sqlplus
    
    The log information will be written to
      <RDBMS ORACLE_HOME>/appsutil/log/CONTEXT_NAME/adcrdb_SID.txt    
    
    Creating the control file for SID_hostname database ...    
    
    SQL*Plus: Release 9.2.0.6.0 - Production on date()
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    ERROR:
    ORA-03113: end-of-file on communication channel     
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ERROR:
    ORA-03113: end-of-file on communication channel       
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    SP2-0640: Not connected
    SP2-0640: Not connected
    SP2-0640: Not connected
    SP2-0640: Not connected
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ERROR:
    ORA-03113: end-of-file on communication channel       
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    SP2-0640: Not connected
    SP2-0641: "EXECUTE" requires connection to server
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ERROR:
    ORA-03113: end-of-file on communication channel       
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    SP2-0640: Not connected
    SP2-0640: Not connected
    SP2-0640: Not connected
    SP2-0640: Not connected
    SP2-0640: Not connected
    exit_code=0    
    Checking for errors ...    
    ORA-03113: end-of-file on communication channel
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ORA-03113: end-of-file on communication channel
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ORA-03113: end-of-file on communication channel
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ORA-03113: end-of-file on communication channel
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    The database has not been successfully created. Shutting down the instance ...
    
    SQL*Plus: Release 9.2.0.6.0 - Production on date()    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.    
    ERROR:
    ORA-03113: end-of-file on communication channel        
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist    
    .end std out.    
    .end err out......
-------------------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:469)
 at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:314)
 at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:290)
 at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:131)
 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:484)