When you attempt to log into the AppWorx Java client, you get the error
message: ORA 12505 TNS:listener could not resolve SID given in connect
descriptor". In the RmiServer log, you see the following:
java.sql.SQLException:
Io exception: Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=36716544)(ERR=12505)
(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
Troubleshooting Steps
Check
that the sqlnet port number in the tnsnames.ora file and the
JDBCPortNumber in the awenv.ini file match. The sqlnet port is defined
when you install Oracle. The default JDBCPort Number is 1521.
The default location for the tnsnames.ora file is:
UNIX: $ORACLE_HOME/network/admin
Windows: %ORACLE_HOME\network\admin
The default location for the awenv.ini file is:
UNIX: $AW_HOME/site
Windows: %AW_HOME%\site
If
you change the port number, you will need to stop and restart all the
AppWorx processes and the RMI server. For directions on stopping and
starting the processes, see Shutdown and Startup Procedures for the
AppWorx Processes.
In UNIX, you can do a "netstat" and "grep for port" to show whether there is a listener on it.
netstat -a -n|grep 1521
If this none of the information above helps, have your DBA check the Oracle SID and ports.