New services in cluster (new Oracle instance)

[Geronimo Marchan]

Hi,

We have a ServiceGuard cluster conformed by 2 rp5470 with hp-ux 11.11. In this moment we have one instance of oracle, which this defined in the package, now i need startup other new instance of oracle but using the same package to startup this. This is posible?

I think that I have two options and I tried these:

1.- I modified the scripts to startup the old instance so that startup the new instance too. The startup worked without problem but I had problems with the monitor of the new instance.

or

2.- create the new service, but this implies to modify the configuration file of the package, this means that I must execute cmapplyconf with the new configuration file of the package? and to create news files to startup de new instance (toolkit new, .sh, .conf, mon, etc.)?


please I need his advice, thanks.

[Chan 007]

Hi,

I recon you should create a new package for this. As you know by any change your new instance is not running and you monitor that too, it may take your primary instance to the next server.
Better create a new package for the new instance.

Yes if involves few changes now, but you don't have to worry about both failing in one time.

007

[Jeff_Traigle]

What problem did you have with the monitor script? Is it the Oracle Toolkit one or something home grown? Either way, you'd need some kind of loop in it to check each ORACLE_SID. Can't recall if the Toolkit script has that ability already coded or not... been since August since I took the Serviceguard class and played with that.

I'd personally tend to want to create a separate package for the new database though. If you start them both and monitor them from a single package, a failure of either database will result in both being failed to an adoptive node. Might not be the optimal solution for HA purposes.

[Geronimo Marchan]

Hi chan,

To create a new package means to create a new Vg because the present package activates the the VG of way exclusive in the configuration file. I do not have more disks available for a new Vg.

thanks,

[Geronimo Marchan]

Hi Jeff,

I am thinking the following thing:

1.- to include a new service in the configuration file of the package: (the .conf file)

2.- to include the new services in the package control script (.cntl file) and to add the command in the function customer_defined_run_cmds and customer_defined_hatl_cmds, this is a new toolkit_new_instance.sh.

3.- to create the news files to startup the new instance, (new_instance.sh, new_instance.conf, new_instance.mon, new_instance_sql.sh,etc.)

4.- to put the news files in the package directory and to execute the cmapplyconf so that the package take the new changes and startup the package.

I attach the files .conf and .cntl of the package whith the modifications (in red), please you can review it and say to me if I am in the correct thing? (the new services is the identified thing like ip12)

Thanks,

[Tim Sanko]

As a DBA and a lazy one at that I would enter the sqlplus product and do a create database...

However I get the feeling you are actually looking at two different issues. 1st Take all of you Databases out of the oratab file and use sqlplus to start/stop databases for 9i + and sqlmgrl for 8i DBs...

Tim

[Tim Sanko]

for selecting which DB you choose knock up a menu that sits in a while loop and when the user leaves the menu with a selection, you can
set ORACLE_SID;ORACLE_HOME; and any other inside a case esac loop. Remember to put in a break to exit the loop...
echo"
DB menu

1. PROD
2. TEST
3. logout
"
read bs
case $bs in
1)
put your stuff here...
;;
2);;
3);;

"

[Geronimo Marchan]

Hi,

thanks to all, I decided to include a new service in the package and this works well

thanks,