Re: multi-home servers

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 10 Aug 2011 14:57:42 +0100
Message-ID: <CABe10sZfiWDQbmrojTq0ZRV2_x0q6H3YCw3ZmckhogQ=zv_k3A_at_mail.gmail.com>

Thanks to everyone who replied both on and off list. I've gone down the roll my own route which is remarkably similar to this off list suggestion received today.

I have written my own "super-dbstart" script, using a sort of "extended
> oratab", which knows how to start and stop (in the correct sequence -- i.e.,
> in the order they are listed in the file)
> (*) databases
> (*) listeners
> (*) agents
> (*) OMS servers

The extended oratab has gone in /etc/sysconfig which is a small abuse of the purpose of that directory but I think a justifiable one.

On Tue, Aug 9, 2011 at 2:26 PM, Mercadante, Thomas F (LABOR) < Thomas.Mercadante_at_labor.ny.gov> wrote:

> Niall,****
>
> ** **
>
> I write my own startup script based on the Oracle supplied script.****
>
> ** **
>
> The dbstart script reads the oratab file – right? I still use this basic
> script but have added calls to my own startup scripts for the Listener and
> Oracle agent.****
>
> The Listener startup script sets its own Oracle Home. Same thing with the
> Oracle Agent.****
>
> I figure that I know when I move the Listener from one release to another
> and know that I need to adjust this script to the new Oracle home.****
>
> ** **
>
> Hope this helps.****
>
> ** **
>
> Tom****
>
> ** **
>
> ** **
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Niall Litchfield
> *Sent:* Tuesday, August 09, 2011 9:18 AM
> *To:* Howard Latham
> *Cc:* ORACLE-L
>
> *Subject:* Re: multi-home servers****
>
> ** **
>
> if RMAN isnt seeing remote databases probably you haven't got a single
> location for oracle name resolution configured. You'll either need to do
> that or ensure that your tnsnames file has the correct entries in the
> ORACLE_HOME that you are running the rman executable from. ****
>
> On Tue, Aug 9, 2011 at 2:12 PM, Howard Latham <howard.latham_at_gmail.com>
> wrote:****
>
> Im trying to do just that. Ihave 11g and 10 and trying to get a 10 db up to
> 10.1.0.2 and then to 11g.
>
> The listener seems the biggest problem. When I try to set the home to 10
> from 11 rman cant see remorte databases.
>
> Is there a checklist of EVERYTHING you need to do?
>
> RH Linux Oracle 11 and 10****
>
>
>
>
> ****
>
> On 9 August 2011 14:06, Niall Litchfield <niall.litchfield_at_gmail.com>
> wrote:****
>
> those of you out there running multiple oracle homes, potentially with
> multiple oracle software owners and certainly with multiple listeners on
> Linux. How do you control db and listener startup at boot time? dbstart
> seems entirely inadequate.
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info****
>
>
>
> ****
>
> --
> Howard A. Latham
>
> Sent from my Nokia N97****
>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info****
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 10 2011 - 08:57:42 CDT