Listener start/stop with password
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Listener start/stop with password

  1. #1
    Join Date
    Nov 2002
    Location
    Argentina
    Posts
    24

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

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore
    Posts
    52
    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.

  3. #3
    Join Date
    Nov 2002
    Location
    Argentina
    Posts
    24
    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
    :)

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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
  •  



Click Here to Expand Forum to Full Width