Solved

Oracle11gR2: Linux 5.3: how to set ORACLE_HOME?

Posted on 2011-03-22
4
771 Views
Last Modified: 2012-05-11
Hello experts,

what do I set ORACLE_HOME to?

below is my install directory

I had it set to ORACLE_HOME=/oracle

but, I don't think that's the right path...

In advance, thank you for your help...

regards,
[oracle@oracle oracle]$ ls
apex         dbs                      inventory  nls              owm            sqlplus
app          dc_ocm                   j2ee       oc4j             perl           srvm
assistants   deinstall                javavm     ocm.rsp          plsql          sysman
bin          demo                     jdbc       odbc             precomp        timingframework
ccr          diagnostics              jdev       olap             racg           tmp
cdata        dv                       jdk        ons              rdbms          ucp
cfgtoollogs  emcli                    jlib       OPatch           relnotes       uix
clone        EMStagePatches_confserv  ldap       opmn             root.sh        utl
config       has                      lib        oracle_confserv  root.sh.old    wwg
crs          hs                       log        oracore          root.sh.old.1  xdk
csmig        ide                      md         oraInst.loc      scheduler
css          install                  mesg       ord              slax
ctx          install.platform         mgw        oui              sqldeveloper
cv           instantclient            network    owb              sqlj

Open in new window

0
Comment
Question by:epifanio67
  • 2
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 35194970
What makes you think that isn't right?

Did you run root.sh after the install?  If so, see if there is a /etc/oratab file.  If so, if should show the correct home.

It should have also been correct in the oracle usrs profile an not needed changing.
0
 

Author Comment

by:epifanio67
ID: 35194993
thank you expert...

well, I have ORACLE_HOME set to the base directory where the application is installed. In other words:
ORACLE_HOME=/oracle

is this correct?

I searched the web and ORACLE_HOME seemed to be set to .../product/11.xx/db....

below is what I get when cat /etc/oratab... I don't see ORACLE_HOME there...

thanks for all of your help
[oracle@oracle oracle]$ cat /etc/oratab
#



# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.

# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
confserv:/oracle:N

Open in new window

0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 total points
ID: 35195016
Again, why do you not think it is correct?  Is something not working or throwing an error?

In the oratab file, for the conserv instance ORACLE_HOME is /oracle.

The comments talk about the file layout.
0
 

Author Closing Comment

by:epifanio67
ID: 35195112
got it.. thx for your help..
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now