topic Re: Need oracle sample script in Operating System - HP-UX

Need oracle sample script

Mohammad Arafat Rahman — Wed, 05 Jan 2011 06:41:43 GMT

hi,
i installed sg cluster 11.20 on two nodes. now i need to install oracle 11g. i don't have oracle toolkit for service guard. so i need a sample script of oracle to configure in a service guard cluster. i installed hp-ux 11.31 on the server.
plz anyone help me for this installation of oracle without oracle toolkit

Re: Need oracle sample script

Viktor Balogh — Thu, 06 Jan 2011 15:48:10 GMT

Hi Mohammad,

You are searching for the HP Serviceguard Enterprise Cluster Master Toolkit:

http://h71028.www7.hp.com/enterprise/w1/en/os/hpux11i-serviceguard-toolkits-ecmt.html

Regards,
Viktor

Re: Need oracle sample script

Doug O'Leary — Thu, 06 Jan 2011 17:38:51 GMT

Hey;

If I'm understanding you correctly, you don't need a script. The oracle *installation* is the same regardless of cluster status.

The process I follow is:

1. Manually configure vgs/lvs and IPs
2. Install oracle
3. Configure/generate database and ensure it's running - fully mission capable.
4. Configure the cluster and packages.

One of the important parts is to ensure the IP address is plumbed up and available otherwise, there's a rather large chunk of sqlnet that needs to be reconfigured to use the package IP address.

Hope that helps.

Doug O'Leary

Re: Need oracle sample script

Mohammad Arafat Rahman — Thu, 06 Jan 2011 23:06:58 GMT

hi,
thnx for the reply. i have the cluster master toolkit. but i don't know how to use it. i make a basic pkg for mounting the storage volume for cluster. now i want to install oracle on shared storage. installation is normal but when my one node is down how the 2nd node start the oracle? should i write a script for that? i give a virtual ip for my basic package. i can login with that ip. can i have to use that ip for listener for oracle???

Re: Need oracle sample script

Doug O'Leary — Fri, 07 Jan 2011 15:40:04 GMT

Hey;

As I mentioned previously, I won't even create the package until the database is up, running, and tested. Trying to do that at the same time as package creation is just asking for problems.

So, the first thing to do is build the system as if this were a standalone database. Create the volume groups, the logical volumes and plumb up the IP address that will be used as the failover IP.

Once all that's done, install oracle as you normally do. The one change is that you use the hostname/IP associated with the package instead of the standalone host.

After you or your uses says "Yea, verily, the database is running the way we want it", you shut it down, unplumb the IP address, unmount the filesystems and turn off the volume groups.

From there, generate the package. I typically use this checklist: http://www.olearycomputers.com/ll/mcsg/mcsg_mkpkg.html

Update the customer_defined_run_cmds to start your databbase. I typically have a few more bells and whistles, but at a minimum, you want:

function customer_defined_run_cmds
{
# start listener
su - oracle -c "lsnrctl start"
# start the database
su - oracle -c "/u01/app/oracle/product/11.2.0.1/bin/startdb"
}

and the contents of the stardb script are:

#!/bin/ksh

export ORACLE_SID=such-and-what
export ORACLE_HOME=...
export LD_LIBRARY_PATH=...
export PATH=${PATH}:${ORACLE_HOME}/bin

sqlplus / as sysdba << eof
startup;
exit;
eof
#EOF

The customer_defined_halt_cmds is left as an exercise for the reader.

None of this is particularly tricky if you take it one step at a time. Install the system, then install oracle, *then* create the package. Don't try to do everything simultaneously.

Hope that helps.

Doug

Re: Need oracle sample script

Mohammad Arafat Rahman — Thu, 13 Jan 2011 09:38:40 GMT

thnx. it works

Re: Need oracle sample script

Mohammad Arafat Rahman — Thu, 24 Feb 2011 10:05:55 GMT

hi, i have now oracle toolkit. now how can i configure oracle with oracle toolkit? plz help me...

Re: Need oracle sample script

Viktor Balogh — Thu, 24 Feb 2011 10:17:08 GMT

read the following document:

Using the Oracle Toolkit in a HP Serviceguard Cluster README Revision: B.06.00, August 2010

you can download it from here:

http://h20000.www2.hp.com/bizsupport/TechSupport/DocumentIndex.jsp?lang=en&cc=us&contentType=SupportManual&prodTypeId=18964&prodSeriesId=4162103&docIndexId=64255