topic sqlplus are not run properly in Operating System - HP-UX

sqlplus are not run properly

Sudip Ghosh — Tue, 15 Jun 2010 09:27:59 GMT

I am new in hp-ux11i v3 and oracle 10g environment. when I have run $sqlplus in oracle user or $oracle_home/bin/sqlplus /nolog ,it is not run. then i try to run $oracle_home/bin/./sqlplus /nolog that time it is run. what is the problem? plz suggest me.

Re: sqlplus are not run properly

Michal Kapalka (mikap) — Thu, 17 Jun 2010 07:43:35 GMT

hi,

normally you should be logged under the user that the Oracle DB is running, and you need to have set correctly system enviromnt variables required for oracle.

for example on linux machine :

ORACLE_BASE=/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/app/10.2.0; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$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

similar should be on HP-UX.

mikap

Re: sqlplus are not run properly

Volker Borowski — Fri, 18 Jun 2010 10:37:53 GMT

Hi,

what shell do you use ?
Some aliases set, that might come out strange?

Please post output of "env" and "alias"

Volker

Re: sqlplus are not run properly

Eric Antunes — Fri, 18 Jun 2010 12:45:59 GMT

Hi,

what is the output of:

$which sqlplus

Best regards,

Eric Antunes