starting listener on remode node using a script
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: starting listener on remode node using a script

  1. #1
    Join Date
    Feb 2003
    Posts
    7

    starting listener on remode node using a script

    Hi,

    how do i start the listener on a remote host through a shell script.
    i tried rsh,ssh with no success. you can execute other commands using rsh but trying to start the listener throws up:
    ====
    rsh parlxdbp2 /opt/oracle/product/server32/9.2.0/bin/lsnrctl status

    LSNRCTL for Linux: Version 9.2.0.3.0 - Production on 12-DEC-2003 15:22:46
    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
    Message 1053 not found; No message file for product=network, facility=TNS
    ====
    even if i execute a scipt setting up the environment before firing this command i get the same error.

    any ideas?

    thanks
    ajay

  2. #2
    Join Date
    Sep 2003
    Location
    Bangalore
    Posts
    36
    Hi,
    Try creating a small script on the remote host like

    PATH=$HOME/bin:${PATH:-/usr/bin:.}
    export PATH
    PATH=.:$ORACLE_HOME/bin:/opt/bin:/bin:/usr/bin:/usr/ccs/bin
    export ORACLE_HOME=/ora01/app/oracle/product/9.2.0
    /ora01/app/oracle/product/9.2.0/bin/lsnrctl start listener

    rsh -l oracle &

    where:
    a) node is the remote node I'm starting "listener" on,
    b) "rsh_start_listener" is a shell script on node that contains:

    I hope this work, this is not the solution but a work-around.
    Bye

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