Home » RDBMS Server » Server Administration » Diferent instances
Diferent instances [message #280073] Mon, 12 November 2007 07:19 Go to next message
Messages: 144
Registered: March 2007
Senior Member

Hi, i have a noob question
i have a linux with 3 instances all of them are with the same owner "oracle"
but my problem is to know how to change between those instances.
in windows system is using
Set oracle_sid instance1

but i dont know howto do it on linux system.
because i have a lot of variables like oracle_home, oracle_sid

thnx in advance
Re: Diferent instances [message #280075 is a reply to message #280073] Mon, 12 November 2007 07:22 Go to previous messageGo to next message
Messages: 3202
Registered: April 2005
Location: Heilbronn, Germany
Senior Member

export ORACLE_SID=instance1

instead of the set. The same for other environment variables.

And it's case sensitive in Unix/Linux.

[Updated on: Mon, 12 November 2007 07:23]

Report message to a moderator

Re: Diferent instances [message #280513 is a reply to message #280073] Tue, 13 November 2007 23:11 Go to previous messageGo to next message
Messages: 42
Registered: September 2007
Location: China

you should define three environment variables:
using export commands.
export PATH=
export ORACLE_SID=
but the others is the same if your three instances are the same version

Re: Diferent instances [message #280710 is a reply to message #280513] Wed, 14 November 2007 10:23 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Yes, but set in user default shell profile.
check default shell
$ echo $SHELL
most properly it is ./bash profile
set parameter "oracle sid, oracle home , path" in .bash profile.
Previous Topic: startup database
Next Topic: whats causing space
Goto Forum:

Current Time: Thu Aug 17 12:40:13 CDT 2017

Total time taken to generate the page: 0.09549 seconds