Shell Programming and Scripting

Hello All,

I need to now how can I establish connection with oracle database then shutdown abort and then startup, In other words need to implement the following lines to perl script:

export ORACLE_SID=<some user>
${ORACLE_HOME}/bin/sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown abort
SQL> startup
SQL> connect user/user@user
SQL> update TABLE set MAX=50 where NODE='node.node1'
and some more updates.

I know that there is some moudle that handle oracle DB, DBI and DBI::ORACLE , try to dig but got dizzy , and didn't find any info that describe how to "shutdown abort" and "startup" ,
Is that implementable at all ?

Your help will Appreciated.
Thanks,
Ronen

I'm pretty sure you can't shutdown the database from inside SQL plus, and you certainly couldn't start it up! These commands are executed from the operating system, not sqlplus. You can certainly do that from perl or any shell script just like you execute any other OS command -- provided you've got the authority in the first place...

Hi,
in your script do this :

Code:

export ORACLE_SID=<Name of DB>

${ORACLE_HOME}/binsqlplus /nolog << EOF | tail -4 | head -1  2>/dev/null      
 connect / as sysdba
 shutdown abort
        exit ;
EOF `

Feed back for result.