Support Article
Upgrade is failing due to TNS:listener error
SA-6166
Summary
Upgrade was failing when attempting to load the UDF library into Oracle. The upgrade was from PRPC 5.5 to PRPC 6.3 SP1.
Error Messages
java] Feb 2, 2015 10:38:29 AM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] WARNING: Encountered database error attempting to load jar into Oracle: Listener refused the connection with the following error:
[java] ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
[java]
[java] Throwable occurred: java.sql.SQLException: Listener refused the connection with the following error:
[java] ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
[java]
[java] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
[java] at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
[java] at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
[java] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
[java] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:402)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:450)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.installJarOnOracle(DatabaseLibraryLoader.java:440)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.main(DatabaseLibraryLoader.java:197)
[java] Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
[java] ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
[java]
[java] at oracle.net.ns.NSProtocol.connect(NSProtocol.java:395)
[java] at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
[java] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
[java] ... 8 more
[java] Feb 2, 2015 10:38:29 AM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] INFO:
[java]
[java]
[java] Encountered database error attempting to load UDF library onto Oracle, clean schema before running again.
[java]
[java]
Steps to Reproduce
Run the upgrade script
Root Cause
User needs to look if the Oracle listener was running and Oracle instance is accessible. User has to verify if they have mapped the correct database details in the SetupDatabase.Properties file.
Resolution
User has rectified the issue with database configurations in the SetupDatabase.Properties file. After mapping valid database name alias, reported issue was resolved.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.