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