• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 760
  • Last Modified:

Connections without listener

We have an application that connects to an Oracle 10g instance via jdbc.
Something is happening such that it appears the connections are being made even though the listener is down.
Can this be so?
How so?
0
xoxomos
Asked:
xoxomos
2 Solutions
 
mohammadzahidCommented:
Listener is only used if connect_descriptor field used when logging in database.

sqlplus> abc/abc@server1111  will invoke listener in DEDICATED and SHARED SERVER mode

sqlplus > abc/abc  will not invoke listener. Oracle uses Net8 connectivity in this case.

0
 
xoxomosAuthor Commented:
Ok.  I'm talking about an applications server on one machine and database server on another so the sqlplus abc/abc would not suffice here would it?
I see a lot about jdbc in listener log.  
0
 
konektorCommented:
when you are on server, where database is, it's enough to have set oracle variables (ORACLE_BASE, ORACLE_HOME) and you can connect to database only using username and pasword, listener can be down, because is not used.
but if your application is on different server than database, you need to go through listener as i know. isn't there any other listener on database server (there might be more than one)?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
linuxoCommented:
Hi,

No need for listiner to connect from the same PC where database is located, Lisener used for remote Call ...

thanks
0
 
Docteur_ZCommented:
Connect to the database and issue a "show parameter local_listener"

Check the adress of the listed listener, if it's not the one you were thinking about.

If nothing is listed, then it's using the listener on default port (1521).
0
 
schwertnerCommented:
No, it is not possible to connect Oracle instance on other machine
without using the Listener.

As Linuxo said it is possible to connect
from the same machine but if only there is one instance or possibly
(I am not sure) to the instance located by ORACLE_SID variable.

But after the Listener made the connection normally it redirects
to created socket connection to other ports of the machine and
also creates Oracle Process thar serves the connection.
So the created connections do need the Listener. It could be down,
but this will make impossible further new connections, not the allready
established.
0
 
xoxomosAuthor Commented:
From the docs Listener Architecture:
"The database server receives an initial connection from a client application through the listener. The listener is an application positioned on top of the Oracle Net foundation layer. "
From the results of some testing here, it seems once that initial connection is made, queries can be made to the database even after listener is shut down at least with JDBC.  TOAD would not do it, but a Cold Fusion program program continued to return results from queries as does an application called Blackboard. (Learning system).  If I try to make a new connection without listener, it does not work.
So I'm wondering if that coincides with what schwertner says here:
"But after the Listener made the connection normally it redirects
to created socket connection to other ports of the machine and
also creates Oracle Process thar serves the connection.
So the created connections do need the Listener. It could be down,
but this will make impossible further new connections, not the allready
established."
0
 
mohammadzahidCommented:
yes, queries can be made to the listener after listener is down. Listener function is to authenticate new connections to the server or dispatcher. Connection that are connected to the database after listener is down or stopped are not effected.

You need to check what session is running SQL statements. This information can be pulling from library cache and by linking those SQL statement with the session id of the SQL executed those SQL.

You can get all this information from V$session, V$SQLtext, V$sqlarea. First get the Session id of user connected thru Coldfusion application.

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now