auto start listener with password

[kburrows]

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

[davey23uk]

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

you can let the machine kill it on a machine reboot

[kburrows]

Thanks,

I will try this out.

[hacketta1]

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):

$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.

[davey23uk]

dont need a password to start - only stop

[hacketta1]

dont need a password to start - only stop

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