Re: Password for Listener and Internal??

Experiences on AIX 4.2.1 and Oracle 7.3.2/7.3.4 (we skipped 3 because the sw got lost in our company)

1 As long as your are either logged in as the oracle owner (preferably oracle) or in the dba group (preferably dba), it won't ask for a password when you connect as internal. Note: if you want sysdba accounts (which act the same way as internal, and which you should do because a) now you be able to use all options of OEM and start/shut from a pc/OEM console and b) rumors are the internal mechanism will be phased out) you must make sure the remote_password_file parameter is set to exclusive. Otherwise you won't be able to connect <username/password> AS SYSDBA 2 Don' t remember where I found this (maybe pulled the complete doc from support.oracle.com), here is how sqlnet works (and it stinks) a) if you have an unencrypted password in listener.ora you can only issue commands like
set password <password>, it MUST be on the same line b) if you have an encrypted password you should issue a set password <RETURN> you will be prompted for a password by the listener. The listener will encrypt the password and compare to the password in listener.ora. If the password is on the same line the listener WON'T encrypt the password. Now here is the 'feature': if you have a shell script like lnsrctl << EOD
set password
oracle
stop listener
EOD
it WON'T work, because the dratted set password command expect this from a proper tty only.
Maybe you can try to reproduce this behavior and someone should verify with support if they intend to change it.
My solution now is to have an unencrypted password and secure the scripts, however I don' really like it.

Hth
Sybrand Bakker, Oracle DBA

satarnag_at_microcad.com wrote:

> Os: 2.6 release 5/98
> Oracle 7.3.3
>
> Hi again,
> First off, thanks to everyone who responded to my last post.
>
> I'm having fun with my new install of 7.3.3 and it's undocumented suprises.
> 2 Questions:
>
> 1) Password for Internal: Durring the Install,I was asked if I would like to
> have a password for Internal user. I said yes and provided a password. After
> the Install, I connected internal and I wasn't prompted for a password and i
> connected fine. Anyone know why??
>
> 2) Durring the install, it prompted me for a password for the Listener. I
> didn't want one, but it asked for one anyway. I had the installer to
> automatically configuire MTS and the Listener. After Install, the Listener
> was up and running. When I went to shut it off (lsnrctl stop), it gave me an
> error and said something like: Listener was unable to recognize password. To
> resolve the problem, I had to comment out the password in the listener.ora
> and restart the database and server. I researched this one all over the web
> and in my books, but I wasn't able to find a document which explains how to
> use the listener with a password. Anyone know how to start and shut off the
> listener using a password?
>
> Thanks in Advance for any responses...
> Satar Naghshineh
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sat Aug 29 1998 - 00:14:07 CDT