Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us