Home » RDBMS Server » Server Administration » Diferent instances
Diferent instances [message #280073] Mon, 12 November 2007 07:19 Go to next message
thorin666
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
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
it's

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
ora110
Messages: 42
Registered: September 2007
Location: China
Member

you should define three environment variables:
PATH,ORACLE_HOME,ORACLE_SID
using export commands.
------------------------------
export ORACLE_BASE=
export ORACLE_HOME=
export PATH=
export ORACLE_SID=
export LD_LIBRARY_PATH=
------------------------------
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: Mon Dec 05 08:50:05 CST 2016

Total time taken to generate the page: 0.10070 seconds