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.<init>(ApplyDatabase.java:366)

     at oracle.apps.ad.clone.ApplyDBTier.<init>(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 :

<DB_LISTENER oa_var="s_db_listener" default=""><Name of the SOURCE DB listener></DB_LISTENER>

ACTION :

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

<DB_LISTENER oa_var="s_db_listener" default=""><Name of the TARGET DB listener></DB_LISTENER>

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 '<SID>_<Hostname>.xml' located under the DB $ORACLE_HOME/appsutil

2. shutdown the target Database

3. execute 'perl adcfgclone.pl dbTier <physical Path to the DB Tier Contextfile>

 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/

++++++1153204.1,1329400.1,1350709.1 & 603104.1 ++++++