Solved

oracle_home

Posted on 2013-02-01
5
695 Views
Last Modified: 2013-02-01
[oracle@term ~]$ cd $ORACLE_HOME
[oracle@term ~]$ ls
Desktop
[oracle@term ~]$ echo $ORACLE_HOME

[oracle@term ~]$

why this command is not working eventhough my

 ~/.bash_profile


is like this


# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
      . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
# Oracle settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

# If /tmp doesn't have 1G space free then you can workaround it by
# pointing the variables TMP AND TMPDIR to a location where you have
# sufficient space.

ORACLE_HOSTNAME=ora11g.home.com; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=ora11g; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
export CLASSPATH

if [ $USER = "oracle" ]; then
   if [ $SHELL = "/bin/ksh" ]; then
     ulimit -p 16384
     ulimit -n 65536
   else
     ulimit -u 16384 -n 65536
   fi
fi

umask 022
======================================
also

[oracle@term ~]$ echo $ORACLE_BASE

[oracle@term ~]$


is blank

but software is fine..

I have a doubt

before all the oracle software was installed in another location

I copied to db_1            ok

is that the reason....

please advice to solve this issue...
0
Comment
Question by:walkerdba
  • 2
  • 2
5 Comments
 
LVL 13

Expert Comment

by:stergium
ID: 38842861
Hello.
Just running export does an oracle var show up ? either ORACLE_BASE  or ORACLE_HOME ?
0
 
LVL 13

Accepted Solution

by:
stergium earned 500 total points
ID: 38842879
also can you check for oraInventory\ContentsXML\inventory.xml
You can find ORACLE HOME NAME and ORACLE_HOME from this file. (assuming that there is a difference on what your .bash_profile says  and inventory.xml
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 38842893
~/.bash_profile is only executed when starting a login shell.

Could it be that you're in a non-login shell, e. g. after "su" instead of "su -", or in a X environment?

Use ~/.bashrc in such a case.
0
 

Author Closing Comment

by:walkerdba
ID: 38843016
Absolutely correct...
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 38843029
The accepted solution does not contain an explanation why your environment variables would vanish.

Or am I on a completely wron track here and didn't understand your question at all?
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup

792 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