Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Need help in shell script on AIX

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help in shell script on AIX
# 1  
Old 12-03-2013
Need help in shell script on AIX
Hi All,

I am connecting from ServerA(Unix) to ServerB (AIX). Copying a Database dump file from A to B. On B i need to import that dump file.

I have used the following code to do this operation but ended up with error
Code:
Pseudo-terminal will not be allocated because stdin is not a terminal.
stty: tcgetattr: A specified file does not support the ioctl system call.

and it hangs up.

Code:
ServerA>sshpass -p 'oracle01'  scp /oracle/DATAPUMP/* oracle@ServerB:/oracle/test1/DATAPUMP

echo 'File Transfered';

ServerA>sshpass -p 'oracle01' ssh oracle@ServerB
export ORACLE_SID='orcl'
chmod 777 -R /oracle/test1/DATAPUMP
export ORACLE_HOME=/oracle/Home1
export PATH=$PATH:${ORACLE_HOME}/bin
sqlplus / as sysdba <<EOF
spool sss1.txt;
.....

While connecting to ServerB I am getting the above error.

Please help me.

thanks,
maddy
Last edited by jim mcnamara; 12-03-2013 at 07:32 AM..
# 2  
Old 12-03-2013
sshpass is not the same as ssh, it creates a controlling "terminal" which is not a /dev/tty device.

Do not use sshpass, just use ssh:
Code:
echo "
export ORACLE_SID='orcl'
chmod 777 -R /oracle/test1/DATAPUMP
export ORACLE_HOME=/oracle/Home1
export PATH=$PATH:${ORACLE_HOME}/bin
sqlplus / as sysdba <<EOF
spool sss1.txt; 
.. and all the rest" > myscript.sh
chmod 777 myscript.sh
scp -p myscript.sh   oracle@ServerB:/tmp/myscript.sh
ssh oracle@serverB '/tmp/myscript.sh'

These commands require that the user running the code on serverA above have ssh keys on serverB. Since you already have the password for the oracle account, this should be trivial.
# 3  
Old 12-05-2013
Thanks Jim... It was helpful
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Shell script in AIX

Hello Experts My SAP application is running in IBM AIX. Everyday my application generate some files in the below path as below. root@sedcaspm0502: pwd /interfaces/RFTS/B11/archive root@sedcaspm0502: ls -lrt -rw-r r 1 ppgadm sapsys 1039445 May 08 01:20... (1 Reply)
Discussion started by: sundar.c79@gmai
1 Replies

2. Shell Programming and Scripting

Want to Schedule Shell Script on AIX

Hi All, I want to schedule a shell script on AIX. But Crontab is not working in my AIX Server.Is there any alternative? Please Suggest.. (2 Replies)
Discussion started by: bharat1211
2 Replies

3. Shell Programming and Scripting

How to put a trace on shell script running in AIX?

Please help me in putting a trace on shell script running in AIX Best regards, Vishal (3 Replies)
Discussion started by: Vishal_dba
3 Replies

4. UNIX for Dummies Questions & Answers

Shell Script in AIX

Hi , Good Morning every one !!! I am very new to this forum and new to Shell Script as well , hope some script Guru's will help me . I have a requirment to write a shell script . The requirment is like this . There are couple of shell scripts scheduled in the Crontab (some scripts run... (5 Replies)
Discussion started by: dilipd21
5 Replies

5. AIX

AIX Shell script does not work

Hi. I created schell script for sending messages to some processes in AIX: #!/bin/sh BSE=/infor/ERPLN/bse BSE_TMP=/infor/ERPLN/bse/tmp export BSE BSE_TMP for i in `ps -eo pid,comm | grep bshell | cut -f 1 -d " "` do /something $i done Unfortunatelly this script does not work on... (6 Replies)
Discussion started by: giovanni
6 Replies

6. AIX

Aix shell script question

Hi, When I run the following script from a shell it works fine as root. But when I try to run from cron as root it fails everytime? I set the scripts I run in cron to send me the output if they fail but this produces nothing. Please see script below, maybe someone can see whats wrong as I'm... (3 Replies)
Discussion started by: elmesy
3 Replies

7. Shell Programming and Scripting

shell script on AIX

Hi! I have made a simple script for writing the following line on a file (file.txt): list= 1 2 3 and thr script looks like this: N=3 ll=(1 2 3) echo -n "list= ">> file.txt j=0 while ; do echo -n ${ll}" ">> file.txt let j++ done The code works fine on Linux,... (3 Replies)
Discussion started by: carl.alv
3 Replies

8. AIX

how to loop through non-empty files with shell script on AIX

I have av script that loops through some statistic files to create a report. We would like to only loop through non-empty files as these files create an empty report-line. I have figured out how to find the non-empty files, but not how to loop through only those files. Here is the code that finds... (4 Replies)
Discussion started by: Tessa
4 Replies

9. Shell Programming and Scripting

porting shell script from Linux to AIX.

Hi, I am porting one shell script from Linux to AIX. I had .ksh file and i have changed it to .sh file for aix. on linux this script is running fine but on aix it gives me "unexpected end of file" error. Could any one suggest me what to do to port this script error free? Thanks in... (6 Replies)
Discussion started by: joy_1
6 Replies

10. AIX

Difference between writing Unix Shell script and AIX Shell Scripts

Hi, Please give me the detailed Differences between writing Unix Shell script and AIX Shell Scripts. Thanks in advance..... (0 Replies)
Discussion started by: haroonec
0 Replies
Login or Register to Ask a Question