Re: Preclone

Posted by ErmanArslansOracleBlog on Mar 29, 2017; 4:27pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Preclone-tp2425p2460.html

Concantrating on this one ->

getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL=''
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : prdc1pdb01-scan
    sDbDomain  : dalkia.net
    sDbPort    : 1521
    sDbSid     : DBOFINP1
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@prdc1pdb01-scan.dalkia.net:1521:DBOFINP1
WARNING:     Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prdc1pdb01-scan.dalkia.net)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DBOFINP1)))
    Connection obtained