OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Env variables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Env variables [message #213086]

Tue, 09 January 2007 07:49

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

Report message to a moderator

Re: Env variables [message #213087 is a reply to message #213086]

Tue, 09 January 2007 07:55

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

Report message to a moderator

Re: Env variables [message #213089 is a reply to message #213086]

Tue, 09 January 2007 07:59

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?

Report message to a moderator

Re: Env variables [message #213097 is a reply to message #213089]

Tue, 09 January 2007 08:30

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

Report message to a moderator

Re: Env variables [message #213103 is a reply to message #213086]

Tue, 09 January 2007 08:50

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.

Report message to a moderator

Re: Env variables [message #213117 is a reply to message #213086]

Tue, 09 January 2007 09:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

. ep.sh
-^ please note that the line above begins with dot space ep.sh

Report message to a moderator

Re: Env variables [message #213126 is a reply to message #213103]

Tue, 09 January 2007 10:37

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

Report message to a moderator

Re: Env variables [message #213158 is a reply to message #213086]

Tue, 09 January 2007 12:30

plshelp
Messages: 205
Registered: January 2007

Senior Member

Thank you very much. I got it.

Report message to a moderator

Previous Topic:	SPFILE ERROR
Next Topic:	synchronizing user password from another database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 17 20:10:21 CDT 2026