Re: multi-home servers

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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *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@xxxxxxxxx>
> 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@xxxxxxxxx>
> 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

Other related posts: