auto start listener with password

Hi,

Oracle 9.2
UNIX AIX 5.2

I have password protected my listeners and am having trouble automating the startup and shutdown.

Does anyone have an example of a script to start/stop the listener when using a password?

Thanks,
Kathy

you dont need to set the password when starting the listener.

you can let the machine kill it on a machine reboot

Thanks,

I will try this out.

You mention that you also want to automate startup. One way of achieving this would be to manually add an PASSWORDS_listener_name entry to listener.ora, specfiying a password in cleartext. Do not use the netmgr or the set_password command. I think this script should work (not got access to my 9iR2 ServiceGuard package control script at the moment):

Code:

---

$ORACLE_HOME/bin/lsnrctl << !
set current_listener listner_name
set password password
start
!

---

Naturally you should make sure that your listener.ora file and your shell script are fully locked down at the OS level permissions wise and that they stay that way.

dont need a password to start - only stop

Quote:

---

Originally Posted by davey23uk

dont need a password to start - only stop

---

I didn't realise that was the case. Thanks for the info.