Oracle windows Automatic startup script

If the Oracle 10g is installed in the virtual machine, the server instance cannot be started after each restart. You must enter sqlplus to manually start up. The solution is as follows: 1. compile a batch processing file oraclestart. BAT, the content is as follows:

@ Echo starting Oracle service
Net start oracleoradb10g_home1tnslistener
Net start oracleserviceorcl
Net start oracleoradb10g_home1isql * Plus
Net start oracledbconsoleorcl

Set oracle_sid = orcl
Sqlplus/nolog @ start. SQL

 

2. Write Start. SQL in the same directory. The content is as follows: connect sys/123456 as sysdba
Startup
Exit; 3. Add a Windows scheduled task and run oraclestart. bat.