Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Linux-HA: Users

how to Install Oralce10gR2 in Linux HA Environment

 

 

Linux-HA users RSS feed   Index | Next | Previous | View Threaded


ibnerazi at yahoo

Nov 21, 2009, 4:25 AM

Post #1 of 3 (575 views)
Permalink
how to Install Oralce10gR2 in Linux HA Environment

Hi Guys

hearbeat package also provides an OCF resource for Oracle(/usr/lib/ocf/resource.d/heartbeat/oracle).
I want to create a cluster of oracle.

# cat /etc/hosts
dbnode1 192.168.0.236  ## hostname and physical IP of server1
dbnode2 192.168.0.238 ## hostname and physical IP of server2
dbserver 192.168.0.245 ## virtual hostname and IP for cluster

I ran the Oracle(oracle10gR2) installer on 'dbnode1', and install/place every thing(db, oracle binaries) on file system "/oracle" which is on SAN.
After installation completes, I unmount the /oracle(SAN), and then mount /oracle on 'dbnode2', but oracle gives error and doesnot starts.

To start Oracle on 'dbnode2', I have to change the hostname from dbnode2  to dbnode1.

is there any specific method to install oracle(any special option I have to provide to the 'runInstaller' ) for Linux HA

Regards





_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems


michalko.system at a-i-p

Nov 23, 2009, 2:52 AM

Post #2 of 3 (522 views)
Permalink
Re: how to Install Oralce10gR2 in Linux HA Environment [In reply to]

Hi Muhammad,

your problem is here a little bit out of topic though, but anyway:
you must change your listener address in the /etc/hosts and in listener.ora
for use with HA so that it listen also on the "common" HA-IP-address , e.g.:
( address = ( protocol = tcp ) ( host = HA-VIP ) ( port = 1526)

HTH

Nikita Michalko


Am Samstag, 21. November 2009 13:25 schrieb Muhammad Sharfuddin:
> Hi Guys
>
> hearbeat package also provides an OCF resource for
> Oracle(/usr/lib/ocf/resource.d/heartbeat/oracle). I want to create a
> cluster of oracle.
>
> # cat /etc/hosts
> dbnode1 192.168.0.236  ## hostname and physical IP of server1
> dbnode2 192.168.0.238 ## hostname and physical IP of server2
> dbserver 192.168.0.245 ## virtual hostname and IP for cluster
>
> I ran the Oracle(oracle10gR2) installer on 'dbnode1', and install/place
> every thing(db, oracle binaries) on file system "/oracle" which is on SAN.
> After installation completes, I unmount the /oracle(SAN), and then mount
> /oracle on 'dbnode2', but oracle gives error and doesnot starts.
>
> To start Oracle on 'dbnode2', I have to change the hostname from dbnode2 
> to dbnode1.
>
> is there any specific method to install oracle(any special option I have to
> provide to the 'runInstaller' ) for Linux HA
>
> Regards
>
>
>
>
>
> _______________________________________________
> Linux-HA mailing list
> Linux-HA [at] lists
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems

_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems


ibnerazi at yahoo

Nov 23, 2009, 9:42 AM

Post #3 of 3 (496 views)
Permalink
Re: how to Install Oralce10gR2 in Linux HA Environment [In reply to]

Hi Nikita Michalko, thanks for your feedback/help... appreciated.

I have found the solution :) , so following are the steps to follow, for installing Oracle in a Linux HA environment

Solution:
----------
server1 physical hostname = dbnode1
server2 physical hostname = dbnode2
cluster/virtual hostname = dbserver

on both hosts
# cat /etc/hosts
dbnode1 192.168.0.236 ## Phys hostname
dbnode2 192.168.0.238 ## Phys hostname
dbserver 192.168.0.245 ## virtual/cluster hostname and IP

before running the 'runInstaller', on dbnode1, temporarily set the physical hostname of server1 from 'dbnode1' to 'dbserver'

# echo dbserver > /proc/sys/kernel/hostname

then temporarily assign the virtual/cluster IP to the server1.

# ip address add 192.168.0.245 brd + dev eth0

now run the OUI(runInstaller), and place every thing(db, and oracle binaries) on SAN.
Once the installation completes, remove the virtual IP and virtual hostname from server1.


now before starting oracle, just assign the virtual IP, to the
node(either dbnode1 or dbnode2), and listner/oracle will start without
complains.. ;-)

Now I am able to start Oracle from either node(dbnode1, dbnode2) without changing the physical hostname of any node(Linux HA requires unique hostname for every member).

Now I am able to configure the Linux HA ;)

Regards

--- On Mon, 11/23/09, Nikita Michalko <michalko.system [at] a-i-p> wrote:

From: Nikita Michalko <michalko.system [at] a-i-p>
Subject: Re: [Linux-HA] how to Install Oralce10gR2 in Linux HA Environment
To: "General Linux-HA mailing list" <linux-ha [at] lists>
Date: Monday, November 23, 2009, 2:52 AM

Hi Muhammad,

your problem is here a little bit out of topic though, but anyway:
you must  change your listener address in the /etc/hosts and in listener.ora
for use with HA so that it listen also on the "common" HA-IP-address , e.g.:
( address = ( protocol = tcp ) ( host = HA-VIP ) ( port = 1526)

HTH

Nikita Michalko


Am Samstag, 21. November 2009 13:25 schrieb Muhammad Sharfuddin:
> Hi Guys
>
> hearbeat package also provides an OCF resource for
> Oracle(/usr/lib/ocf/resource.d/heartbeat/oracle). I want to create a
> cluster of oracle.
>
> # cat /etc/hosts
> dbnode1 192.168.0.236 ## hostname and physical IP of server1
> dbnode2 192.168.0.238 ## hostname and physical IP of server2
> dbserver 192.168.0.245 ## virtual hostname and IP for cluster
>
> I ran the Oracle(oracle10gR2) installer on 'dbnode1', and install/place
> every thing(db, oracle binaries) on file system "/oracle" which is on SAN..
> After installation completes, I unmount the /oracle(SAN), and then mount
> /oracle on 'dbnode2', but oracle gives error and doesnot starts.
>
> To start Oracle on 'dbnode2', I have to change the hostname from dbnode2
> to dbnode1.
>
> is there any specific method to install oracle(any special option I have to
> provide to the 'runInstaller' ) for Linux HA
>
> Regards
>
>
>
>
>
> _______________________________________________
> Linux-HA mailing list
> Linux-HA [at] lists
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems

_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems




_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

Linux-HA users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.