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
Printable View
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):
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.Code:$ORACLE_HOME/bin/lsnrctl << !
set current_listener listner_name
set password password
start
!
dont need a password to start - only stop
I didn't realise that was the case. Thanks for the info.Quote:
Originally Posted by davey23uk