Home » RDBMS Server » Server Administration » Env variables
Env variables [message #213086] Tue, 09 January 2007 07:49 Go to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi,

I upgraded the database from 8.1.7.4 to 9.2.0.6 yesterday. When i typed sqlplus and tried to connect to the database, it is asking me to export the environment variables again. Do I have to export it every time????? Or is there anyother method that I can use to the export the variables???

Thanks for all your help,
Geetha
Re: Env variables [message #213087 is a reply to message #213086] Tue, 09 January 2007 07:55 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Your OS ?

if it is *nix. you have to set all variable in your user profile file ( .profile or bash_profile)


regards
Taj
Re: Env variables [message #213089 is a reply to message #213086] Tue, 09 January 2007 07:59 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
yes its unix.Actually there is a profile which has the info. But what do i do with it? please help. IS there anyway to run it?
Re: Env variables [message #213097 is a reply to message #213089] Tue, 09 January 2007 08:30 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

No,
user profile upload when user login.

you can set all variable in user local profile
eg:
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=/app/oracle/db_1
export PATH=/app/oracle/db_1/bin
export ORACLE_SID=<sid>

and you can also create one shell script .sh and run every time when you login.
linux@oracle]vi login.sh
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=/app/oracle/db_1
export PATH=/app/oracle/db_1/bin
export ORACLE_SID=<sid>
shift+ZZ

linux@oracle]chmod 755 login.sh
linux@oracle]./login.sh

it is just example first try on your testing machine.

regards
Taj
Re: Env variables [message #213103 is a reply to message #213086] Tue, 09 January 2007 08:50 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Yea i tried the same...its not working...
First i did vi ep.sh
then:

[teaubkp01]:/export/home/oracle>cat ep.sh
export ORACLE_HOME=/oracle92/oracle/product/9.2.0
export LD_LIBRARY_PATH=/oracle92/oracle/product/9.2.0/lib32
export LD_LIBRARY_PATH_64=/oracle92/oracle/product/9.2.0/lib
export ORACLE_BASE=/oracle92/oracle
export ORACLE_SID=AR314V

[teaubkp01]:/export/home/oracle>chmod 755 ep.sh
[teaubkp01]:/export/home/oracle>./ep.sh
[teaubkp01]:/export/home/oracle>cd /oracle92/oracle/admin/AR314V
[teaubkp01]:/oracle92/oracle/admin/AR314V>env | grep ORACLE
ORACLE_BASE=/appl/oracle
ORACLE_HOME=/appl/oracle/product/8.1.7

Env is still showing 8.1.7

Please help.
Re: Env variables [message #213117 is a reply to message #213086] Tue, 09 January 2007 09:37 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
. ep.sh
-^ please note that the line above begins with dot space ep.sh
Re: Env variables [message #213126 is a reply to message #213103] Tue, 09 January 2007 10:37 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
first set user all variable in user local profile.
May be .bash_profile or .profile.
linux@oracle]$export $SHELL <<which profile is user default profile>>

after set all variable run
linux@oracle]$./.bash_profile
linux@oracle]$
after that check "sysctl.conf" file set correctly all variable point right directory.
if not edit in your default editor.


hope this helps
Taj
Re: Env variables [message #213158 is a reply to message #213086] Tue, 09 January 2007 12:30 Go to previous message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Thank you very much. I got it.
Previous Topic: SPFILE ERROR
Next Topic: synchronizing user password from another database
Goto Forum:
  


Current Time: Sat Dec 03 01:06:25 CST 2016

Total time taken to generate the page: 0.08825 seconds