If you stop the listener also you stop new jdbc connections, because
the typical JDBC connection string is something like :
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@linux:1521:orcl","test","test");
if you close the listener port the driver could not establish a connection.
Connections already open (jdbc and oci and .net and ....) remain active.
Giovanni
On 4/12/06, dba1 mcc <mccdba1_at_yahoo.com> wrote:
> We have ORACLE database 9iR2 run on UNIX servers.
> Sometime when we doing database maintenance, we don't
> want users connect to DB.
>
> for SQL/net connection I can STOP listener. For JDBC
> client connection, how to avoid it?
>
> Thanks.
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
--------------------------------------------------------------------
Another free oracle resource profiler
http://sourceforge.net/projects/oraresprof/
Now version 0.9
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 12 2006 - 08:30:35 CDT
