OraFAQ Forum: Server Administration » Multiple Oracle installations on the same Server

Home » RDBMS Server » Server Administration » Multiple Oracle installations on the same Server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Multiple Oracle installations on the same Server [message #53292]

Wed, 11 September 2002 04:47

Hitesh Shenoy
Messages: 11
Registered: January 2002

Junior Member

OS : HP Unix

Please advise whether we can have more than one Oracle Enterprise Server installations on the same server. I have 2 applications which work on different Oracle versions.

Can I create different unix users, groups, homes for both Oracles and work my way?

Example:
Application 1 requires Oracle 8.1.7
Application 2 requires Oracle 7.3.4
I install Oracle 8.1.7 using unix user "oracle" and group "dba" with home "/usr1/oracle/app/pro......8.1.7"
I install Oracle 7.3.4 using unix user "oraclea" and group "dbaa" with home "/usr2/oracle/app/pro.....7.3.4"
Both my application users will be in different groups and will have different oracle homes set.

Will there be any conflicts?

Please can somone tell me whether this will work.

Many thanks.

Hitesh

Report message to a moderator

Re: Multiple Oracle installations on the same Server [message #53294 is a reply to message #53292]

Wed, 11 September 2002 05:00

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

It will work.
but you have to bear the pain in administration. ( oracle never recomends this).
we have 8.0.5, 8.1.7, 8ias and 9ias running is same machines (HP-UX 9000 11.0)
i have the same orace / dba  to maintain all
Pain is to explicity set env variables everytime i login to svrmgrl~

Report message to a moderator

Re: Multiple Oracle installations on the same Server [message #53302 is a reply to message #53292]

Wed, 11 September 2002 09:47

Roy
Messages: 30
Registered: May 2002

Member

I'm administering one such installation. Running oracle 8.1.7 and 7.3.4 at the same time. Make sure you create a script to swich between them (specially environment variables). You can give a source oracle version and a destination version so that all variables are properly set.
e.g module switch oracle/7.3.4 oracle/8.1.7

However you'll have only one listener (8.1.7) which listens for both.

segregate the databases locations for both versions so managing is easy.

Report message to a moderator

Previous Topic:	Re: ora-00439: HERE'S THE ANSWER FOR LINUX
Next Topic:	Password file question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 14 05:55:07 CST 2025