Non Default Listeners not starting automatically at boot

All posts relating to Oracle database administration.

Moderator: Tim...

Non Default Listeners not starting automatically at boot

Postby ajit730@gmail.com » Sat May 04, 2013 3:41 pm

Oracle Database 11.2.0.3
Oracle Enterprise Linux 5.8

Hi Tim,

I need to enable database and listener auto start at boot time in one of the servers. I referred to this article written by you.

http://www.oracle-base.com/articles/lin ... -linux.php

I followed both the methods of writing dbora script which use "su" you mention,

Your method works perfectly well for databases.

But I see that only default listener starting at 1521 port is started. That too, I have to make below changes in dbstart script in the ORACLE_HOME of the listener.

ORACLE_HOME_LISTNER=/u01/app/oracle/product/112/dbhome_1

It does not start if I just mention ORACLE_HOME_LISTNER=$ORACLE_HOME or leave it as it is, which is ORACLE_HOME_LISTNER=$1 or something like that.

Why this is so ? How to overcome this issue and make sure that all configured listeners are started? Is there any workaround other than installing Oracle Restart ?
ajit730@gmail.com
Member
 
Posts: 1
Joined: Sat May 04, 2013 3:37 pm

Re: Non Default Listeners not starting automatically at boo

Postby Tim... » Sat May 04, 2013 9:07 pm

Hi.

OK. So you now you have to add in extra lines for your custom listener configurations. For example, if you listeners called "listener_orcl1" and "listener_orcl2", you would do this.

Code: Select all
case "$1" in
    'start')
        # Start the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
        su $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start listenrer_orcl1"
        su $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start listenrer_orcl2"
        su $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
        touch /var/lock/subsys/dbora
        ;;
    'stop')
        # Stop the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
        su $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME"
        su $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop listenrer_orcl1"
        su $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop listenrer_orcl2"
        rm -f /var/lock/subsys/dbora
        ;;
esac


Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 9 guests

cron