Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cloning EBS 12.2.9

Beauty_and_dBestNov 14 2019 — edited Feb 9 2021

Hi ALL,

I am cloning EBS 12.2.9 Vision demo instance.

I am starting at database tier first, but I got error below:

Usually database tier easiest part to clone, and I seldom get error in 12.2.8 and below.

But this 12.2.9 is a little bit weird.

    Trying to connect using SID as ServiceName

getConnectionUsingServiceName() -->

    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lcctest2.lccgroup.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS)))

WARNING:     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=lcctest2.lccgroup.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS.lccgroup.com)))

WARNING:     Exception occurred: java.sql.SQLRecoverableException: 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---------------

WARNING: 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:672)

        at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:502)

        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:393)

        at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:116)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

        at java.lang.reflect.Constructor.newInstance(Unknown Source)

        at oracle.apps.ad.clone.util.CloneProcessor.run(Unknown Source)

        at java.lang.Thread.run(Unknown Source)

I tried to check the password of the source instance, and it is apps/apps. Why do I get  ORA-01017: invalid username/password; logon denied?

Please help.....

Kind regards,

jc

This post has been answered by Vishnu Vinnakota on Nov 18 2019
Jump to Answer

Comments

Processing

Post Details

Added on Nov 14 2019
16 comments
861 views