But, when they tried connecting using the jdbc url, they were getting a TNS related error (ORA-12xxx).
telnet <scanName> 3843
This has failed for all of the RAC Nodes. ie . The node listener's port is not open to the Apps machine.
telnet <VIP Name> 3921
JOE_humble wrote:Why are you guys using ports for Quest Common Agent and Herodotus Net, for Oracle?
GI Version: 22.214.171.124
Platform : RHEL 5.4
SCAN Listener Port : 3843
Node Listener port in each node : 3921
IBM Websphere guys are trying to connect to our RAC DB. There is a firewall between the DB and the Apps server. They got the network team to open the SCAN Listener's port 3843.The SCAN Listener redirects an incoming connection to a database Listener. That database Listener can in turn redirect the the client to any of the static IP and virtual IP addresses of that cluster (depending on configuration and db service requested by client).
So, If i assign 1521 to both SCAN and Node listener wouldn't there be a collision ?
$ ps -ef | grep tns grid 9345 1 0 Oct26 ? 03:44:32 /u01/app/grid/product/126.96.36.199/bin/tnslsnr LISTENER_SCAN1 -inherit grid 9713 1 0 Oct26 ? 01:48:37 /u01/app/grid/product/188.8.131.52/bin/tnslsnr LISTENER -inherit oracle 23611 23398 0 09:13 pts/1 00:00:00 grep tns
JOE_humble wrote:It is the standard RAC configuration. SCAN Listener uses the SCAN IP. The db Listener uses virtual and static IPs. No collission.
I didn't know that it was technically possible to use the same port for both SCAN Listener and Node listener.
I agree with you on the arbitrary port usage. We can't use 1521 because of our security policy (no default ports should be used anywhere ). Last week , in a meeting someone was suggesting to use ports after 15000.Sorry, but I'm going to be blunt. It. Is. An. Idiotic. Security. Policy.