auto start listener with password
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: auto start listener with password

  1. #1
    Join Date
    Nov 2000
    Posts
    173

    auto start listener with password

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you dont need to set the password when starting the listener.

    you can let the machine kill it on a machine reboot

  3. #3
    Join Date
    Nov 2000
    Posts
    173
    Thanks,

    I will try this out.

  4. #4
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    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):

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

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    dont need a password to start - only stop

  6. #6
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Quote Originally Posted by davey23uk
    dont need a password to start - only stop
    I didn't realise that was the case. Thanks for the info.

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