java.lang.Exception: Control file creation failed : RC-00118: Error occurred during creation of database

RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation failed / RC-00118 'Error occurred during creation of database
Error : in ApplyDBTier_01291502.log file

Exception occurred: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sudb2.corp.singiri.com)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=SUP1.corp.singiri.com)))
    Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

    Connection could not be obtained; returning null

-------------------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.doConf(ApplyDatabase.java:635)
     at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:473)
     at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:366)
     at oracle.apps.ad.clone.ApplyDBTier.(ApplyDBTier.java:110)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
     at java.lang.reflect.Constructor.newInstance(Constructor.java:501)
     at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
     at java.lang.Thread.run(Thread.java:637)


Solution A:

Step 1: To verify the apps password is valid ,which you provided by Target server while running adcfgclone.pl on dbTier

(Or)

Workaround:

1. Modify the Contextfile 'CTXORIG.xml', whcih is created by the pre-cloning script, which is found under the Database $ORACLE_HOME/appsutil/clone/context/db directory :

ORIGINAL :


ACTION :

UPDATE the file with the SID name of the TARGET Instance, e.g. TEST :


Please Note :
The modification can be implemented after the pre-cloning STEPS - before STARTING the 'adcfgclone dbTier' . This works best when done on the target system, after you have copied the files from source.

If the Clone has already failed, the workaround/solution would be :

1. correct the s_db_listener value in the Target context file named '_.xml' located under the DB $ORACLE_HOME/appsutil
2. shutdown the target Database
3. execute 'perl adcfgclone.pl dbTier

 Error B:

System parameter file is $RDBMS_ORACLE_HOME/network/admin/clone_dbclone/listener.ora
Log messages written to $RDBMS_ORACLE_HOME/network/admin/clone.log
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCclone))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux IA64 Error: 1: Operation not permitted
 
Solution B :


Please Apply the following solution:

1- change permission /var/tmp/ . oracle

[root@dbclone tmp]# chmod -R 777 .oracle/