Oracle Database Discussions

10g 10.2.0.4.0 on AIX

Hi,

I have a dev server with 3 Oracle homes. Each home has multiple instances. I'm testing the dbstart/dbshut scripts and have run into a problem.

Here's my oratab: (it's odd that SID15 is in home1 but bear with me).

SID15:/orasoft/home01/product/10.2.0:Y
SID01:/orasoft/home01/product/10.2.0:N
SID02:/orasoft/home01/product/10.2.0:N
SID03:/orasoft/home01/product/10.2.0:N
SID04:/orasoft/home01/product/10.2.0:N
SID05:/orasoft/home01/product/10.2.0:N
SID06:/orasoft/home02/product/10.2.0:N
SID07:/orasoft/home02/product/10.2.0:N
SID08:/orasoft/home02/product/10.2.0:N
SID09:/orasoft/home02/product/10.2.0:N
SID10:/orasoft/home02/product/10.2.0:N
SID11:/orasoft/home03/product/10.2.0:Y
SID12:/orasoft/home03/product/10.2.0:Y
SID13:/orasoft/home03/product/10.2.0:Y
SID14:/orasoft/home03/product/10.2.0:Y


If I set my $ORACLE_HOME to home3 and run ./dbshut $ORACLE_HOME (from $ORACLE_HOME/bin), the dbshut will try to act on SID15 in home1 because it's =Y in the oratab file. It fails when trying to shut down the listener for SID15 and then the rest of the listeners are not shut down.

dbshut: Stoping Oracle Net Listener
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 02-FEB-2010 13:51:55
Copyright (c) 1991, 2007, Oracle. All rights reserved.
TNS-01101: Could not find service name SID15

If is set SID15 = N then all is well. So, do I need separate oratab files for each or my 3 Oracle homes? Or is there something I'm missing, that may be obvious to everyone else ;-)

My assumption was to have all the oratab entries = Y then do shutdowns and startups like this:

export ORACLE_HOME="/orasoft/home01/product/10.2.0:"
cd $ORACLE_HOME/bin
./dbshut $ORACLE_HOME

then repeat for the remaining two homes.

export ORACLE_HOME="/orasoft/home02/product/10.2.0:"
cd $ORACLE_HOME/bin
./dbshut $ORACLE_HOME

export ORACLE_HOME="/orasoft/home03/product/10.2.0:"
cd $ORACLE_HOME/bin
./dbshut $ORACLE_HOME

Thanks.

Brian