i got the script as bellow
sqlplus "/as sysdba" <<!
when i run it from $ prompt it does the activity upto exit but it does not run lsnrctl.
on 01/01/2010 – Made popular on 01/01/2010
I'm trying to connect to a remote linux machine and get an output text via ganymed ssh2 It works perfect with standart commands like "ls -la" or "ps -ef |grep pmon" but not with "lsnrctl status" or "sqlplus / as sysdba".
I'm facing a problem with a query in a shell script (AIX).
sqlplus -s NAME/PASS@SCHEMA<<EOF
set echo off
UPDATE HISTORY SET HISTORY.ID = (SELECT OFFER.ID FROM OFFER WHERE HISTORY.ID=TO_NUMBER(OFFER.CODE)) WHERE EXISTS (SELECT OFFER.ID FROM OFFER WHERE HISTORY.ID=TO_NUMBER(OFFER.CODE));
I have no answer after that.