Detailed Description and Symptoms
During upgrade from V8 to V9 the upgrade hangs on starting java api process.
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
It is possible that the SID and Service_Name does not match. To verify this, either of these methods should work:
log into to SQL*Plus as the SYS user and enter the following command:
SQL> show parameter service
The following command at the command line will reply with the Services and Instances available on the machine:
Oracle has deprecated the use of the SID and are moving towards using the Service name. In the latest release, of Applications Manager, we ship with the latest version of the JDBC driver which is Oracle compliant.
You should use the full Service name during the installation of Applications Manager and not rely on the Database SID any longer.