is 2 ORACLE_HOME good?

Printable View

01-06-2006, 03:25 AM
yxez

is 2 ORACLE_HOME good?

Hi Friends,

OS = AIX 5L
DB = Oracle 10g

Please comment if my design set-up for our new oracle server is good or bad.

We have two new applications(database) to be installed/set-up on our AIX 5L server.
These are FINANCIAL SYSTEMS AND LOANS MANAGEMENT SYSTEM.

what I want to do is:

1. Create two separate oracle id:
- oracle1 for financial system
- oracle2 for loans system
- both ids are members of oinstall,dba group

2. Create two separate oracle home:
- /u01/app/oracle/product/10.2.0.1 for financial system.
- /u02/app/oracle/product/10.2.0.1 for loans system.
- /u01 and /u02 are on separate disk, in case 1 disk crashes the other home will
take over

3. Create 2 separate listener for each home.

One of the advantages of creating two separate instance, is that if u have to do some
system maintenance on one database like u have to shut it down, the other apps
wont get affected.

Thanks a lot for your thoughts.
01-06-2006, 05:13 AM
davey23uk

why two oracle homes? you can have one oracle home and two databases, seems like you are just wasting space and resources
01-06-2006, 06:21 AM
pando

Quote:

Originally Posted by yxez

One of the advantages of creating two separate instance, is that if u have to do some system maintenance on one database like u have to shut it down, the other apps wont get affected.

Thanks a lot for your thoughts.

Shutdown what?

If you shutdown the server your database will all be shutdown

You dont need seperate software to shutdown a database and the other not

If you have 10 instances running are you gonna create 10 ORACKE_HOME?

Sure you can, it´s up to you.
01-06-2006, 11:59 AM
dbasan

Quote:

Originally Posted by davey23uk

why two oracle homes? you can have one oracle home and two databases, seems like you are just wasting space and resources

I have a house with a bath attached bedroom. I want to have another one next to my house.

If one bath is out of order i can go to the next house to use the other.

Does that sound good?

Excuse me yxez...................
01-06-2006, 12:05 PM
davey23uk

less said about that the better
01-06-2006, 01:16 PM
slimdave

The only advantage that I can see is that if you were running third party applications then you could patch each home independently to whatever the third party will support. Other then that, go for one home. In fact, you might consider a single database.
01-06-2006, 08:10 PM
stecal

If you are intent on installing two copies of the software, each in its own ORACLE_HOME, you may as well "trick out" the installer by making separate copies of what's in /var/opt/oracle (the oraInst.loc file). Run OUI, and it thinks there is only the one version of Oracle installed. Do whatever you need to do to the installed files. When it's time to work on the other installed version, switch the loc file.
10-10-2006, 01:43 AM
yxez

hi folks....i just gone through my previous posts while im getting
bored...and i found this one with lots of your shared thoughts,
which i havnt read yet...and thannks to u all :D

Quote:

Originally Posted by davey23uk

why two oracle homes? you can have one oracle home and two databases, seems like you are just wasting space and resources

davey...my purpose is "high availabiliy", what if the disk of one of
the HOME crashed? eventually to wear and tear....each HOME
resides on different disk....the other HOME takes over. Disks are
cheaper these days anyway.
10-10-2006, 01:54 AM
yxez

Quote:

Originally Posted by pando

Shutdown what?

If you shutdown the server your database will all be shutdown

You dont need seperate software to shutdown a database and the other not

If you have 10 instances running are you gonna create 10 ORACKE_HOME?

Sure you can, it´s up to you.

pando...I mean shutdown the db....coz there are instances when
one dabase hit a bug....then u apply patch independently...and some
maybe maintenance of each application itself...without disturbing
the other :)
10-10-2006, 01:57 AM
yxez

Quote:

Originally Posted by dbasan

I have a house with a bath attached bedroom. I want to have another one next to my house.

If one bath is out of order i can go to the next house to use the other.

Does that sound good?

Excuse me yxez...................

dbasan... i didnt quite get what u mean hear :D ....do u mean u agree with me?....Ahhh i see now..i guess u don't.

Actually, I have a house with 2 rooms and each room has a bath
so...
if one room's bath is out of order so can use the other room's bath
The house is the dbserver....I'm using one server only :)
10-10-2006, 04:17 AM
davey23uk

Quote:

Originally Posted by yxez

hi folks....i just gone through my previous posts while im getting
bored...and i found this one with lots of your shared thoughts,
which i havnt read yet...and thannks to u all :D

davey...my purpose is "high availabiliy", what if the disk of one of
the HOME crashed? eventually to wear and tear....each HOME
resides on different disk....the other HOME takes over. Disks are
cheaper these days anyway.

thats why you mirror disks, so that doesnt happen
10-10-2006, 04:25 AM
yxez

hmmnn...let me think...
I really dont trust mirroring that much....I just felt something will still
go wrong with it. And besides u only get 50% space of it while the
other is 100%
10-10-2006, 04:39 AM
davey23uk

give up with you

'dont trust it' what experience do you have - none
10-10-2006, 04:51 AM
reydp

Quote:

Originally Posted by davey23uk

give up with you

'dont trust it' what experience do you have - none

The intension is there Davey, but the plan just don't seem right.

If I'm worry for my Oracle Home being corrupted during upgrade for example, I usually backup the whole ORACLE_HOME/ORACLE_BASE.
And this is mandatory anyway for backup maintenance at least once a year or every upgrade.

Anyway I have 1 server with 4 different versions/Release, so 4 diff ORACLE_HOMES, and 1 Oracle_home have 4 instance. So, its all about requirements. fyi. this is development.
10-10-2006, 04:55 AM
yxez

my hero :) ....oissst yung email ko sagotin mo
10-10-2006, 05:05 AM
waitecj

I simply cannot believe it... Heres me spec'ing and expensive striped and mirrored configuration for my databases only to find that I don't need to because "I can't trust mirroring" and "disks are cheap anyway". Damn me and my expensive yet highly resilient disk configuration.
10-10-2006, 05:28 AM
yxez

yeah...u can save those 50GB if u have 100GB mirrored one :)
and besides, Oracle wont be developing recovery tools if they dont
foresee or guarranteed disk crashes to happen.
10-10-2006, 05:34 AM
davey23uk

gee whizz, what would you rather do - not have to do any recovery at all, or get in a panic when you lose a disk and you have downtime for ages while you get everything backup and working again

You know what, most people dont have to do restores from backups because of media failure - becuase they have protected themselves to have as little downtime as possible.

Most restores are done becuase people have meesed up and broken something.

Just stop posting rubbish, stop it stop it stop it!!!
10-10-2006, 09:07 AM
marist89

Thanks for digging up a 10 month old thread. After 10 months you still haven't implemented?