connectivity issue

From: Chris King <"Chris>
Date: Wed, 20 Jul 2016 17:17:16 +0000 (UTC)
Message-ID: <179393102.2549151.1469035036121.JavaMail.yahoo_at_mail.yahoo.com>



Need your thoughts:
This is on Oracle RAC 11.2.0.4, using scan listener Issue: A new user created on a new system is trying to connect remotely to the Oracle RAC database. The listener.log file indicates the connection is established with a "0" indicating success. However, I put a trigger on the user to dump trace files on logon, and no trace files exist. Also, there are no queries listed for that user in the gv$session + gv$sqlarea. So it looks like the listener indicates user connected successfully, but there is no trace of a connection in the database. The application hangs and eventually returns with a timeout error. We have verified that telnet to the port from the new server to the database server is working. The application uses jdbc, and so we can not test using tnsping or sqlplus.

Has anyone experienced a similar issue before? Any thoughts on what it could be or what further troubleshooting I can do to figure this out? Would listener tracing work on a scan listener?

Thanks in advance.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 20 2016 - 19:17:16 CEST

Original text of this message