Andreas,
Another way is to change your listener.ora file, so DB listener to listen on
different port from what users are expecting.
Then just use: lsnrctl reload.
Or simple stop the listener.
This way only local users could connect with BEQ protocol, not Net8 clients.
Hope that helps.
Trifon Anguelov
Senior Oracle DBA
http://www.dbaclick.com
"Andreas Wizemann" <AWizemann_at_fvvag.de> wrote in message
news:b0kl2us6u4gjrn2lhp8vnhbjj2hicohdna_at_4ax.com...
> Hi,
> is there an (easy) way to prevent temporarly access to a database
> while there is a specific task running (e.g. a Batch-Job or some kind
> of maintenance) ?
>
> Regards
>
> Andreas Wizemann
- WAS CANCELLED BY =======:
Path: news.sol.net!spool1-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r
From: "Trifon Anguelov" <trifona_at_pacbell.net>
Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
Subject: cmsg cancel <qKdX7.17096$M07.3935796282_at_newssvr14.news.prodigy.com>
Control: cancel <qKdX7.17096$M07.3935796282_at_newssvr14.news.prodigy.com>
Date: Mon, 31 Dec 2001 07:08:15 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.qKdX7.17096$M07.3935796282_at_newssvr14.news.prodigy.com>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009788950 26548 166.102.15.34 (31 Dec 2001 08:55:50 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 31 Dec 2001 08:55:50 GMT
X-Auth-User: 075883238/19dcedb7cd041f26
X-Post-Time: Mon, 31 Dec 2001 07:50:01 GMT
X-Problems-To: abuse_at_prodigy.com
X-No-Archive: yes
Comment: Anarchy! Fuck You!
X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1
X-Unacanc3l: yes
<remainder snipped>
Received on Sat Dec 29 2001 - 00:52:06 CST