Home » Infrastructure » Linux » $ORACLE_HOME
$ORACLE_HOME [message #362125] Mon, 01 December 2008 02:19 Go to next message
croora
Messages: 15
Registered: November 2008
Junior Member
where should $ORACLE_HOME point? to location of oracle database or to location of oracle developer suite?

Oracle Database
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh

Oracle Developer Suite
/home/tom/OraHome_1/bin/oraenv

tnx
Re: $ORACLE_HOME [message #362126 is a reply to message #362125] Mon, 01 December 2008 02:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on what you want to do.
For a client, to the location of client installation.

Regards
Michel
Re: $ORACLE_HOME [message #362127 is a reply to message #362126] Mon, 01 December 2008 02:36 Go to previous messageGo to next message
croora
Messages: 15
Registered: November 2008
Junior Member
i first run

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
it sets ORACLE_HOME to /usr/lib/oracle/xe and database works OK.

when i run frmbld.sh it sets ORACLE_HOME to /home/tom/OraHome_1 and cannot connect to database listener (TNS_ADMIN=/home/tom/OraHome_1/network/admin)

how manage to work database and oracle developer suite on same host?
Re: $ORACLE_HOME [message #362128 is a reply to message #362127] Mon, 01 December 2008 02:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
cannot connect to database listener

This is not an Oracle error.

Regards
Michel
Re: $ORACLE_HOME [message #362129 is a reply to message #362128] Mon, 01 December 2008 02:58 Go to previous message
croora
Messages: 15
Registered: November 2008
Junior Member
problem is because /home/tom/OraHome_1/bin/oraenv change ORACLE_HOME to /home/tom/OraHome_1 and TNS_ADMIN so on changes to

TNS_ADMIN=/home/tom/OraHome_1/network/admin

on which values env variables must be to work either database and oracle developer suite?

tnx
Previous Topic: libXm.so.2
Next Topic: auto startup of oracle 10g on RHEL 3 (Red hat enterprise linux 3.2)
Goto Forum:
  


Current Time: Tue Apr 16 06:54:07 CDT 2024