topic sqlplus: not found in Operating System - HP-UX

sqlplus: not found

ivanrc — Wed, 28 Apr 2010 07:08:06 GMT

I try to execute a shell script using plink.exe (plink -ssh "servermachine" -l "user" -pw "pass" /home/path../myScript.sh) and then i get the message "sqlplus: not found", but if i execute the same script in my unix machine i don't have this message an all is ok.

#!/bin/ksh
sqlplus -s ... << EOF
set echo off
set verify off
set feed off
set pagesize 0
set pause off
set linesize 4000
set trims on
set head off
set term off
set pages 0
set lines 2000
set space 0
set serveroutput on size 1000000
SPOOL /home/path/file.txt
DECLARE
...;
BEGIN
....
END;
/
SPOOL OFF
set serveroutput off
exit;
EOF

Re: sqlplus: not found

Dennis Handly — Wed, 28 Apr 2010 07:14:56 GMT

It is likely your PATH doesn't contain sqlplus when you use plink -ssh?

Re: sqlplus: not found

rariasn — Wed, 28 Apr 2010 07:15:42 GMT

Hi,

Add ORACLE_HOME and ORACLE_SID.

rgs,

Re: sqlplus: not found

Matti_Kurkela — Wed, 28 Apr 2010 07:26:59 GMT

When you use plink to execute a script, what you're doing is called a "non-interactive login".

No matter which shell is configured for your user account on the servermachine, it probably handles interactive and non-interactive logins differently. Often some login scripts are omitted when doing a non-interactive login. This typically causes your PATH environment variable to be different from what you've used to.

Try setting PATH explicitly from the HP-UX system's standard configuration file in the beginning of your script:

#!/bin/ksh

export PATH=$(< /etc/PATH)

sqlplus -s ... <[...]

MK

Re: sqlplus: not found

ivanrc — Wed, 28 Apr 2010 07:54:53 GMT

Thanks to all, but the problem is that plink don't load the postprofile and then i have to add this load to my script.

Re: sqlplus: not found

ivanrc — Wed, 28 Apr 2010 07:55:37 GMT

All is ok. Thanks.