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.1.3 Db is 11.2.0.3

Beauty_and_dBestSep 14 2020 — edited Feb 9 2021

EBS 12.1.3

Db 11.2.0.3

OL 6

Hi ALL,

I am cloning our EBS 12.1.3 , I am at db clone now, but I got error below:

pastedImage_1.png

The log file error is:

Trying to get connection using SID based connect descriptor

getConnection() -->

sDbHost    : ebsdbcrp

sDbDomain  :  oracle.local

sDbPort    : 1571

sDbSid     : PROD

sDbUser    : apps

Trying to connect using SID...

getConnectionUsingSID() -->

JDBC URL: jdbc:oracle:thin:@ebsdbcrp.oracle.local:1571:PROD

Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 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=ebsdbcrp.oracle.local)(PORT=1571))(CONNECT\_DATA=(SERVICE\_NAME=PROD)))

Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 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=ebsdbcrp.oracle.local)(PORT=1571))(CONNECT\_DATA=(SERVICE\_NAME=PROD.oracle.local)))

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)

Please help...

Kind regards,

jc

This post has been answered by Beauty_and_dBest on Sep 15 2020
Jump to Answer
Comments
Post Details
Added on Sep 14 2020
1 comment
173 views