I have made one script to shutdown all oracle database that is running on server.I am checking Oracle process for this.But when i am running this script it is not recognizing sql command.Please tell me where i am wrong.

This is the script:

#!/bin/sh
############################# DATABASE SHUTDOWN #########################
BASE_DIR=/home/oracle
export BASE_DIR
cd $BASE_DIR
for db in `ps -ef|grep pmon|grep -v grep|awk '{print $8}'|sed -e 's/ora_pmon_//g'|grep -v sed`
do
echo "Loading $db database profile..........."
. $BASE_DIR/$db
echo "Shutting $db database..."
sqlplus/nolog < EOF >$BASE_DIR/dblog/db.log
connect sys/ski4now as sysdba
SET LINESIZE 100
SET PAGESIZE 50
SET heading off feedback off verify off
shutdown immediate
exit
echo "$db database closes normal"
EOF
done
exit
##########Checking for any running database####################
if [ `ps -ef|grep pmon |wc -l` -ge 1 ]
then
echo " Database is running Please Check error log file for Shutdown error"
else
echo "***All Database is closed*******"
exit 1
fi
exit


Note: not recognising "shutdown immediate" command

Moin,

I think, you use the here document in a wrong syntax. Try it this way (untested, I have no Oracle on my machine here):
The echo is not a sqlplus command, you should place it outside the here document, the command sequence should start with "<<", not "<" and an output redirection IMHO does not work when starting such a document. Use a subshell (the braces) to redirect output.

Jan

EDIT: The output redirection is also possible without a subshell:

I edit the code but again i am getting error

Now codes looks like:
#!/bin/sh
############################# ARMANI DATABASE SHUTDOWN #########################
BASE_DIR=/home/oracle
export BASE_DIR
cd $BASE_DIR
for db in `ps -ef|grep pmon|grep -v grep|awk '{print $8}'|sed -e 's/ora_pmon_//g'|grep -v sed`
do
echo "Loading $db database profile..........."
. $BASE_DIR/$db
echo "Shutting $db database..."
sqlplus/nolog >$BASE_DIR/dblog/db.log <<EOF
connect sys/ski4now as sysdba
SET LINESIZE 100
SET PAGESIZE 50
SET heading off feedback off verify off
select sysdate from dual;
#shutdown immediate;#
exit
EOF
echo "$db database closes normall" >>$BASE_DIR/dblog/db.log
done
exit
##########Checking for any running database####################
if [ `ps -ef|grep pmon |wc -l` -ge 1 ]
then
echo " Database is running Please Check error log file for Shutdown error"
else
echo "***All Database is closed*******"
exit 1
fi
exit

The error is:

[oracle@ssipl-srvr-027 ~]$ ./shutdbs.sh
./shutdbs.sh: line 32: syntax error: unexpected end of file
[oracle@ssipl-srvr-027 ~]$

Moin,

please use the code tag ("#" at the editor's menu) to show your code. One can't see clearly, if you've made a syntax error.

Some points I would check:
- at line 17 you use "#" to comment out a sql command within your sqlplus here document. That's not a valid sql comment, you should use "--" instead.
- I don't know, how you formatted the lines between the "<<EOF" and "EOF" lines. Take account of the fact, that the closing "EOF" has to stand at the very beginning of a line (no leading spaces are allowed) and no other characters are allowed after the "EOF".
- at line 22 there is an exit - the following lines are never executed. This is not the reason for the syntax error, but you should be aware of it.
- do you really call sqlplus/nolog (without a space)? The shell interprets this as a path, not as a command and tries to execute nolog in the directory sqlplus. Do you probably want to execute sqlplus -nolog?

A hint more to your convenience: You don't have to grep -v, if you use the grep like this: grep [p]mon. In this case the grep itself will not appear in the ps output, but all pmon processes are displayed.

Jan