Re: oracle listener doesnot startup automatically

dbstart/dbshut are shell scripts and take care about their environments. All they need is oratab. lsnrctl is a binary and requires a proper settings.
Please check if you set a correct environment in .profile (or .cshrc). Or write a wrapper around lsnrctl.

Igor Laletin wrote in message news:<a1edb879.0105311817.1b9fb342_at_posting.google.com>...
> Sunil,
>
> There is no point to set your environment in root's shell. It is not
> passed to 'database' user because you use su with - (dash) option
> (which is correct).
> Please set a proper oracle environment in 'database' .profile.
>
> Also it is better to post into comp.databases.oracle.server
>
> Regards,
> Igor Laletin
>

sdua_at_solutionsny.com (Sunil Dua) wrote in message news:<bc03ebd5.0106041411.3aca1df1_at_posting.google.com>...
> hello there,
>
> My Oracle 8.1.5 server is on a sun machine and is configured to start
> at boot time along with the Listener. It get started but without the
> listener. my scripts are as given below:
>
> File: /etc/init.d/dbstart
> ===========================
> LD_LIBRARY_PATH=/database/LiveExchange/server/bin/oci815_8
> export LD_LIBRARY_PATH
> ORACLE_HOME=/database/installation; export ORACLE_HOME
> ORACLE_SID=LeasingX;export ORACLE_SID
> PATH=$PATH:$ORACLE_HOME/bin; export PATH
> ORACLE_OWNER=1001;export ORACLE_OWNER
> su - database -c "/database/installation/bin/dbstart"
>
> File: /etc/init.d/lsnrstart
> ===========================
> LD_LIBRARY_PATH=/database/LiveExchange/server/bin/oci815_8
> export LD_LIBRARY_PATH
> ORACLE_HOME=/database/installation; export ORACLE_HOME
> ORACLE_SID=LeasingX;export ORACLE_SID
> PATH=$PATH:$ORACLE_HOME/bin; export PATH
> ORACLE_OWNER=1001;export ORACLE_OWNER
> su - database -c "/database/installation/bin/lsnrctl start"
>
> my database user id is "database" and it belongs to "dba" group. root
> also belongs to dba group. Permissions to above said files are as
> follows:
>
> chmod 777 /etc/init.d/dbstart
> chmod 777 /etc/init.d/lsnrstart
> chgrp dba /etc/init.d/dbstart
> chgrp dba /etc/init.d/lsnrstart
>
> and Links are
>
> link /etc/init.d/dbstart /etc/rc3.d/S97ORACLE
> link /etc/init.d/lsnrstart /etc/rc3.d/S98Listnr
>
> Pls. see if you can help me out... any way thanks a lot for reading.
>
> thanks & regards
> Sunil Dua
Received on Tue Jun 05 2001 - 00:19:24 CDT