| Diferent instances [message #280073] |
Mon, 12 November 2007 07:19  |
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
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 #280513 is a reply to message #280073] |
Tue, 13 November 2007 23:11  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
