This forum is currently locked. You can't register or post questions at this time. (read more)

Non Default Listeners not starting automatically at boot

All posts relating to Oracle database administration.

Moderator: Tim...

ajit730@gmail.com
Member
Posts: 1
Joined: Sat May 04, 2013 3:37 pm

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 ?

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 10 guests

cron