ksc_run_java throwing tns listener error when trying to run SQL
I use ksc_run_java com.kintana.core.server.execution.KSCSQLQuery [AS.JDBC_URL] [AS.DB_USERNAME] "[AS.DB_PASSWORD]" "[QUERY_STRING]" etc to run select statements against PPM. I am trying to run the same command but have it connect to our other PPM environments' DB. I changed the commands to reference the other environment with the appropriate JDBC info,id and password. However it throws the error below. We are running on a windows server. I can ssh to the server and issue tnsping, and it resolves to the DB I am trying to connect to. Is this related to environment variables or the profile? Any suggestions on how to troubleshoot this?
ERROR: java.sql.SQLException: Could not connect to the JDBC URL: [jdbc:oracle:thin:@serverxyz.com:1522:dbname]. Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Re: ksc_run_java throwing tns listener error when trying to run SQL
The error is related with the connect descriptor received by the listener. It seems you specified a service name that either has not yet dynamically registered with the listener or has not been statically configured for the listener.
To register the database with the listener
You have two options to register your database with the listener: