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

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_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?

--
http://www.freelists.org/webpage/oracle-l