Home » RDBMS Server » Server Administration » how to set ORACLE_HOME ORACLE_SID PATH
how to set ORACLE_HOME ORACLE_SID PATH [message #54463] Tue, 19 November 2002 07:31 Go to next message
Gurdeep Singh
Messages: 64
Registered: October 2002
Member
please tell me how to set these parameter for connecting to database through telnet

set var ORACLE_HOME ORACLE_SID PATH
i have linux8.2

Report message to a moderator

Re: how to set ORACLE_HOME ORACLE_SID PATH [message #54472 is a reply to message #54463] Tue, 19 November 2002 08:24 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
??? new ???

depending on Ur shell ...linux should be bash...

i think that the correct syntax is
set VAR=VALUE
or
export VAR=VALUE

examples
export ORACLE_HOME=/u01/app/oracle/product/7343
export ORACLE_SID=PRODDB
export PATH=$PATH:/u01/app/oracle/product/7343/bin

Report message to a moderator

Re: how to set ORACLE_HOME ORACLE_SID PATH [message #54476 is a reply to message #54463] Tue, 19 November 2002 11:50 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You have bash shell unless changed to something else:

edit your user .bashrc file to include

ORACLE_HOME=/.../../
ORACLE_SID=

PATH=$PATH:/.../../..

export ORACLE_HOME ORACLE_SID PATH

You also need to setup LD_LIBRARY_PATH (usually - ${ORACLE_HOME}/lib) , NLS_LANG and TNS_ADMIN (if using location for tnsnames.ora, listener.oar files other than ${ORACLE_HOME}/network/admin

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: ORA-01034 & ORA-27101: shared memory realm does not exist
Next Topic: Creating a DB!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:49:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.