Home » Infrastructure » Unix » env variable
env variable [message #249320] Wed, 04 July 2007 01:39 Go to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
hello
i have installed oracle 10g on AIX 5L
but ecerytime i need to run sqlplus
i have to navigate to the BIN directory
also i have to set the ORACLE_HOME variable
plz help to solve these issues
thanks
Re: env variable [message #249322 is a reply to message #249320] Wed, 04 July 2007 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
YOU HAVE TO:
- set your ORACLE_HOME
- set your ORACLE_SID (if you want to connect to a local database)
- include $ORACLE_HOME/bin in your PATH

Regards
Michel
Re: env variable [message #249332 is a reply to message #249320] Wed, 04 July 2007 02:11 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
Thx michel
but in which file i have to set these env
i tried /home/oracle/.profile
it didnt work
plz help
thanks
Re: env variable [message #249464 is a reply to message #249332] Wed, 04 July 2007 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Did you export the variables?
Is /home/oracle your home directory?
Does your shell (which one is is it?) read this file?

Regards
Michel
Re: env variable [message #249571 is a reply to message #249464] Thu, 05 July 2007 01:26 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
/home/oracle i s my home directory
i did export the env
i use ksh shell
plz help
Re: env variable [message #249596 is a reply to message #249571] Thu, 05 July 2007 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Post "env | sort"
Before read How to format your posts and apply it.

Regards
Michel
Re: env variable [message #249855 is a reply to message #249320] Fri, 06 July 2007 04:07 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
thx michel
this is the outout
$ env | sort
AUTHSTATE=compat
CGI_DIRECTORY=/var/docsearch/cgi-bin
DISPLAY=:0.0
DOCUMENT_DIRECTORY=/usr/docsearch/html
DOCUMENT_SERVER_MACHINE_NAME=localhost
DOCUMENT_SERVER_PORT=49213
DTAPPSEARCHPATH=/home/oracle/.dt/appmanager:/etc/dt/appconfig/appmanager/%L:/e
tc/dt/appconfig/appmanager/C:/usr/dt/appconfig/appmanager/%L:/usr/dt/appconfig
/appmanager/C
DTDATABASESEARCHPATH=/home/oracle/.dt/types,/etc/dt/appconfig/types/%L,/etc/dt
/appconfig/types/C,/usr/dt/appconfig/types/%L,/usr/dt/appconfig/types/C
DTHELPSEARCHPATH=/home/oracle/.dt/help/oracle-p52-0/%H:/home/oracle/.dt/help/o
racle-p52-0/%H.sdl:/home/oracle/.dt/help/oracle-p52-0/%H.hv:/home/oracle/.dt/h
elp/%H:/home/oracle/.dt/help/%H.sdl:/home/oracle/.dt/help/%H.hv:/etc/dt/appcon
fig/help/%L/%H:/etc/dt/appconfig/help/%L/%H.sdl:/etc/dt/appconfig/help/%L/%H.h
v:/etc/dt/appconfig/help/C/%H:/etc/dt/appconfig/help/C/%H.sdl:/etc/dt/appconfi
g/help/C/%H.hv:/usr/dt/appconfig/help/%L/%H:/usr/dt/appconfig/help/%L/%H.sdl:/
usr/dt/appconfig/help/%L/%H.hv:/usr/dt/appconfig/help/C/%H:/usr/dt/appconfig/h
elp/C/%H.sdl:/usr/dt/appconfig/help/C/%H.hv
DTSCREENSAVERLIST=StartDtscreenSwarm StartDtscreenQix     StartDtscreenFlame S
tartDtscreenHop StartDtscreenImage StartDtscreenLife     StartDtscreenRotor St
artDtscreenPyro StartDtscreenWorm StartDtscreenBlank
DTUSERSESSION=oracle-p52-0
EDITOR=/usr/dt/bin/dtpad
HOME=/home/oracle
ITECONFIGCL=/etc/IMNSearch/clients
ITECONFIGSRV=/etc/IMNSearch
ITE_DOC_SEARCH_INSTANCE=search
LANG=en_US
LC__FASTMSG=true
LOCPATH=/usr/lib/nls/loc
LOGIN=oracle
LOGNAME=oracle
MAIL=/var/spool/mail/oracle
MANPATH=/usr/dt/man:/usr/share/man
NLSPATH=/usr/dt/lib/nls/msg/%L/%N.cat:/usr/dt/lib/nls/msg/C/%N.cat:/usr/lib/nl
s/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
ODMDIR=/etc/objrepos
ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/dt/bin:/usr/bin/X11:/sbin:/usr/java
14/jre/bin:/usr/java14/bin
PWD=/u01/app/oracle/oracle/product/10.2.0/db_1/bin
SESSIONTYPE=dt
SESSION_SVR=p52
SHELL=/usr/bin/ksh
TERM=dtterm
TERMINAL_EMULATOR=dtterm
TZ=WET-2WET
USER=oracle
WINDOWID=46137400
XMBINDDIR=/usr/dt/lib/bindings
XMICONBMSEARCHPATH=/home/oracle/.dt/icons/%B%M.bm:/home/oracle/.dt/icons/%B%M.
pm:/home/oracle/.dt/icons/%B:/etc/dt/appconfig/icons/%L/%B%M.bm:/etc/dt/appcon
fig/icons/%L/%B%M.pm:/etc/dt/appconfig/icons/%L/%B:/etc/dt/appconfig/icons/C/%
B%M.bm:/etc/dt/appconfig/icons/C/%B%M.pm:/etc/dt/appconfig/icons/C/%B:/usr/dt/
appconfig/icons/%L/%B%M.bm:/usr/dt/appconfig/icons/%L/%B%M.pm:/usr/dt/appconfi
g/icons/%L/%B:/usr/dt/appconfig/icons/C/%B%M.bm:/usr/dt/appconfig/icons/C/%B%M
.pm:/usr/dt/appconfig/icons/C/%B
XMICONSEARCHPATH=/home/oracle/.dt/icons/%B%M.pm:/home/oracle/.dt/icons/%B%M.bm
:/home/oracle/.dt/icons/%B:/etc/dt/appconfig/icons/%L/%B%M.pm:/etc/dt/appconfi
g/icons/%L/%B%M.bm:/etc/dt/appconfig/icons/%L/%B:/etc/dt/appconfig/icons/C/%B%
M.pm:/etc/dt/appconfig/icons/C/%B%M.bm:/etc/dt/appconfig/icons/C/%B:/usr/dt/ap
pconfig/icons/%L/%B%M.pm:/usr/dt/appconfig/icons/%L/%B%M.bm:/usr/dt/appconfig/
icons/%L/%B:/usr/dt/appconfig/icons/C/%B%M.pm:/usr/dt/appconfig/icons/C/%B%M.b
m:/usr/dt/appconfig/icons/C/%B
_=/usr/bin/env
$ 


thanks again

[Updated on: Fri, 06 July 2007 06:29] by Moderator

Report message to a moderator

Re: env variable [message #249874 is a reply to message #249855] Fri, 06 July 2007 06:32 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
My first post said:
Quote:
include $ORACLE_HOME/bin in your PATH

You didn't.

Btw, code tags are with [] not <> and "Preview Message" button is there to check your message before posting.

Regadrs
Michel
Previous Topic: Unix-oracle-windows-msaccess
Next Topic: Unix and SQLPlus shell scripts
Goto Forum:
  


Current Time: Fri Nov 22 04:41:27 CST 2024