Re: newbie listener question

"Didier" <didier.wiroth_at_mcesr.etat.lu> wrote in message news:3fb5062b_1_at_news.vo.lu...
> Hi,
> I've a few question about the oracle listener (9.2.0.1.0).
>
> 1) what does the listener password (set password xyz) exactly protect?
> does that mean you can't connect to the 1521 port anymore with "any"
> other application without submitting a password?
> For example,
> a) are you still able to connect with tomcat and the oracle jdbc thin
> drivers without passwords?
> b) do you need to provide this password to every client/PC that uses
> the "oracle client" to connect to the db?

Setting a password on the listener means that listener operations (such as start and stop) become password protected. That's all. Clients connect as they always did.

> 2) what is extproc and in which cases is it actually used?

It's a way to allow calls from within Oracle out to external procedures. If you'vee writtena really juicy function of your own as (on Windows) a dll, then Oracle can make use of it.

> 3) what is ADMIN_RESTRICTIONS and what exactly does it limit?

Can't recall. Sorry. The other posts you've recived have very good tips on further reading, though, so you should be able to find out for yourself.

Regards
HJR
> I would greatly appreciate if you could also provide me some good
> doc/links about oracle security and stuff related to my questions.
>
> Many many thanks
> Didier
>
>
Received on Fri Nov 14 2003 - 14:02:29 CST