Automatic startup of listener on Solaris 8 fails !
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Automatic startup of listener on Solaris 8 fails !

  1. #1
    Join Date
    Jan 2002
    Posts
    30

    Automatic startup of listener on Solaris 8 fails !

    I have oracle 8i R2 on Solaris 8 Intel. I have exact same problem by which, oracle database would start with dbora script but listener would not auto start.If I try with lsnrctl start on command prompt it does start.I think it give message of "No such file or directory"
    when I do " su - oracle -c "$ORACLE_HOME/bin/lsnrctl start"

    Can somebody tell me what I am missing ?

    Thanks for help.
    Oracle0
    Oracle (6*OCP)
    9i DBA,8iDBA,8iDBO,8DBA
    6/6i Developer,2000DeveloperR2,
    RHCE

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    have you looked messages in /var ?

  3. #3
    Join Date
    Jan 2002
    Posts
    30
    Yes I have, I don't see anything strange there too.

    Pando, I searched the post just below this one. And I see jiong too had this problem crop up. You can gp through it to make some sense.

    I have played with TNS_ADMIN, can it be ORA_NLS33 directory.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Most likely, your $ORACLE_HOME is not defined...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jan 2002
    Posts
    30
    It is defined. I checked it with echo too. It is as follows:

    ORA_HOME=/opt/oracle/product/8.1.6
    ORA_OWNER=oracle
    if [ ! -f $ORA_HOME/bin/dbstart ]
    then
    echo "Oracle startup: cannot start"
    exit
    fi
    case "$1" in
    start)
    su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
    su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
    ;;
    stop)
    su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
    su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
    ;;
    esac
    Oracle0
    Oracle (6*OCP)
    9i DBA,8iDBA,8iDBO,8DBA
    6/6i Developer,2000DeveloperR2,
    RHCE

  6. #6
    Join Date
    Jan 2002
    Posts
    30
    Jeff, How-come database is starting with same ORA_HOME and not listener. If you guys can look at another post by jiong, he seems to have the same problem, which Nagesh fixed by adding entry into dbstart. I don't like his solution. I think it might be bug or something. I can start listener manually but not with my script.

    Any ideas !!
    Oracle0

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If you can start the listener manually but not with your script, the problem is with your script.

    What does the listener.log say on startup?
    What does /var/adm/messages say on startup?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    May 2002
    Posts
    2,645
    dbstart does not work with Oracle 8.1.6. You have to modify your script. See note 98418.1 on MetaLink. Here is the header of the note:

    "dbstart" is a shellscript used on Unix platforms to start databases listed in the "oratab" file. It is often called from system startup scripts.

    The "dbstart" script shipped with all versions of Oracle up to and including 8.1.6 does not start any 8.1.6 instances if they are down. "dbstart" will report "Database warm started" rather than starting the instance. This problem only affects 8.1.6 (or later) instances.

  9. #9
    Join Date
    Jan 2002
    Posts
    30
    I know the problem of dbstart. You have to change line 64 entry to /JServer. It works fine. I am talking of lsnrctl start as part of auto start script at run level 3.
    Oracle0
    Oracle (6*OCP)
    9i DBA,8iDBA,8iDBO,8DBA
    6/6i Developer,2000DeveloperR2,
    RHCE

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If you're getting "No such file or directory", then most likely your shell can't find the lsnrctl program.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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