Re: [Q] how to avoid JDBC client connect to database?

  • From: "Richard Ji" <richard.c.ji@xxxxxxxxx>
  • To: mccdba1@xxxxxxxxx
  • Date: Wed, 12 Apr 2006 19:32:03 -0400

If it's JDBC connection coming from outside of the DB, it's no
different.  It's SQL*Net whether (OCI or thin driver) and thus
stopping listener will prevent them from connecting as well.

If you are talking about JDBC connection from within the DB's JVM
through server side driver, then put the DB into restrict mode should
do it.

Richard Ji

On 4/12/06, dba1 mcc <mccdba1@xxxxxxxxx> 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?
--
//www.freelists.org/webpage/oracle-l


Other related posts: