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.