One very useful script
test_orcl.bat
REM set oracle_sid=orcl
sqlplus /@orcl as sysdba @d:scripttest_orcl.sql
puase
test_orcl.sql
col host_name for a20
select host_name,startup_time,status,database_status from v$instance;
exit
test_orcl.bat
REM set oracle_sid=orcl
sqlplus /@orcl as sysdba @d:scripttest_orcl.sql
puase
test_orcl.sql
col host_name for a20
select host_name,startup_time,status,database_status from v$instance;
exit