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