Shell Programming and Scripting

BSD, Linux, and UNIX shell scripting — Post awk, bash, csh, ksh, perl, php, python, sed, sh, shell scripts, and other shell scripting languages questions here.

error code 137 and error code 35072

👤 Login to reply

    #1  
Old 06-17-2010
laxmi131 laxmi131 is offline
Registered User
 
error code 137 and error code 35072

Hi

while trying to run few scripts
/afs/ae.ge.com/informatica/ardw/dev/bin/cdw_ar_update_recvbal.sh
this script contains the below data
load_dir=/afs/ae.ge.com/informatica/ardw/dev/data
prog_dir=/afs/ae.ge.com/informatica/ardw/dev/bin
ctl_dir=/afs/ae.ge.com/informatica/ardw/dev/ctl
log_dir=/afs/ae.ge.com/informatica/ardw/dev/logs
sql_dir=/afs/ae.ge.com/informatica/ardw/dev/sql
sqlplus -s ops\$afnardw/ardw82bi@evnrdwd1 @$sql_dir/cdw_ar_update_recvbal.sql >> $log_dir/script.log

I am trying to execute this script through informatica

There i am getting ther error
1.shell command failed with exit code 137
for another instance i am geting an error
2.execution of command did not complete successfully with exit code 35072

when i am executing this in unix
$ sh /afs/ae.ge.com/informatica/ardw/dev/bin/cdw_ar_update_recvbal.sh
/afs/ae.ge.com/informatica/ardw/dev/bin/cdw_ar_update_recvbal.sh: sqlplus: not found

please let me know what is the issue

Thanks in advance
Sponsored Links
    #2  
Old 06-18-2010
dips_ag dips_ag is offline
Registered User
 
Quote:
Originally Posted by laxmi131 View Post
Hi

I am trying to execute this script through informatica

There i am getting ther error
1.shell command failed with exit code 137
for another instance i am geting an error
2.execution of command did not complete successfully with exit code 35072
Informatica exit codes don't tell you real unix shell error.


Quote:
Originally Posted by laxmi131 View Post
when i am executing this in unix
$ sh /afs/ae.ge.com/informatica/ardw/dev/bin/cdw_ar_update_recvbal.sh
/afs/ae.ge.com/informatica/ardw/dev/bin/cdw_ar_update_recvbal.sh: sqlplus: not found
Check your .profile file if the $ORACLE_HOME variable is set or not.
When you type
Code:
echo $ORACLE_HOME
/u00/app/oracle/product/11.2.0

It should return you the path.

-dips
Sponsored Links
👤 Login to reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
How to fix :[too many arguments error in code Brewer27 UNIX for Dummies Questions & Answers 2 05-18-2008 08:42 PM
Error code checking jepombar Shell Programming and Scripting 3 08-21-2007 01:50 PM
FD0 error code 30 Pritpal singh UNIX for Advanced & Expert Users 6 08-28-2006 05:55 AM
Finding error code nitinkgoud Solaris 2 07-15-2006 12:43 PM
sql error code trapping xiamin Shell Programming and Scripting 3 11-26-2001 08:52 AM



All times are GMT -4. The time now is 09:39 AM.

Unix & Linux Forums Content Copyright©1993-2018. All Rights Reserved.
×
UNIX.COM Login
Username:
Password:  
Show Password





Not a Forum Member?
Forgot Password?