Listener start/stop with password
Hello:
I set a ´password for the listener in my test database, and i want to create a unix script to start and stop the listener automatically , but i dont know how to set the password ..
Is ther some way to start and stop the listener with password using a unix script .. Can somebody help me??
Thanxs, and merry christmas ...
Marcelo Quesada
:)
Hi..
U can use the following script for auto start & shutdown of listener.
lsnrctl << EOF
set password
start
exit
EOF
Regards
Joe
Last edited by jomon_s; 12-23-2002 at 08:28 AM .
Sorry but its not working ..
here the script "test"
lsnrctl << EOF
set password
papa (password)
stop
exit
EOF
here is the output of test ..
tcssubo1(oracle):/home/oracle:[TCSLAB]
$ test
tcssubo1(oracle):/home/oracle:[TCSLAB]
$
i also test this modification
lsnrctl <
set password
papa
stop
exit
!EOF
but i only got the listener prompt ..
Marcelo Quesada
:)
Originally posted by mquesada
Sorry but its not working ..
here the script "test"
lsnrctl << EOF
set password
papa (password)
stop
exit
EOF
here is the output of test ..
tcssubo1(oracle):/home/oracle:[TCSLAB]
$ test
tcssubo1(oracle):/home/oracle:[TCSLAB]
$
i also test this modification
lsnrctl <
set password
papa
stop
exit
!EOF
but i only got the listener prompt ..
u have use set pswd as
lsnrctl << EOF
set password UR_ENCRIPTED_PSWD(U get this in LISTENER.ora)
stop
exit
EOF
U have to use the encripted pswd(Hex decimal) or binary value(i.e 0 or 1) as parameter to the password.....
Preferably the HEX value that is in the listener.ora file.
Hope this will work
Regards
Abhay.
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width
Bookmarks