Home » RDBMS Server » Server Administration » 2 profiles for oracle user on solaris
2 profiles for oracle user on solaris [message #242255] Fri, 01 June 2007 06:01 Go to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
Hi

I have to install oracle 10g in a seperate home from oracle 9i. Now this is a solaris box and it has a few 9i databases running. And the .profile file for oracle user has all 9i specific setting. Before I install oracle 10g in a seperate directory, do I need to have a seperage profile of oracle user right?

So can you help me about how to a two different profiles for the same oracle user - one when the environmetn is 9i other when it is 10g? if you can give some example/link that will also be helpful

Nirav
Re: 2 profiles for oracle user on solaris [message #242271 is a reply to message #242255] Fri, 01 June 2007 08:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at oraenv file.
It is used to switch from an instance profile to another one.

Regards
Michel
Re: 2 profiles for oracle user on solaris [message #242280 is a reply to message #242271] Fri, 01 June 2007 08:19 Go to previous messageGo to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
Thanks Michel. In my situation, as of now, there is only one home -the oracle 9i home. now I have to install the 10g in the same environment, so I need to "unset" the 9i profile.

So in that I think this will not help-oraenv is used when already there is more than one instance. So can u help on how do I unset the 9i environment and set the new environment for 10g , before doing the 10g install on the server?

Re: 2 profiles for oracle user on solaris [message #242285 is a reply to message #242280] Fri, 01 June 2007 08:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
unset? just execute "unset" for ORACLE variables.
You're searching for difficulties where there is none.

Regards
Michel
Re: 2 profiles for oracle user on solaris [message #242314 is a reply to message #242285] Fri, 01 June 2007 10:10 Go to previous messageGo to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
Thank you Mike.

I guess I would need another seperate .profile file (this .profile file doesn't set any variables and use this file and crosscheck whether any variable carries old value. once confirm, I can use this file.

I have to carry this 10g install in a critical server, and I am doing it first time..
Re: 2 profiles for oracle user on solaris [message #242331 is a reply to message #242314] Fri, 01 June 2007 10:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
During install Oracle doesn't care about your ORACLE variables only to suggest you default values.

Btw, it should be a good idea to check your installation process on a test server before doing it on a production one.

Regards
Michel

[Updated on: Fri, 01 June 2007 10:50]

Report message to a moderator

Re: 2 profiles for oracle user on solaris [message #242632 is a reply to message #242271] Mon, 04 June 2007 08:20 Go to previous message
orausern
Messages: 826
Registered: December 2005
Senior Member
Thank you Michel. I found your inputs on oraenv file most useful.

Thanks again!
Previous Topic: Can I give Schema's their own Individual Tablespace?
Next Topic: Help required with ORA - 28000 Error
Goto Forum:
  


Current Time: Fri Sep 20 01:46:56 CDT 2024