Batch problem

cyanolive

Due to a virus in the computer, the Oracle database cannot automatically start the database instance after antivirus.
Not resolved for the time being.
I plan to write a batch file to run the windows system on startup
Let it help me open an instance of oracle database

The process of opening the oracle database instance is as follows

Start-run-cmd
c:\> sqlplus / nolog
Enter sql command mode
sql> conn sys / abcdefg @ server as sysdba
Connect oracle database
sql> startup
Start oracle database instance

I created a batch file of ora.bat directly,
The contents are as follows:
@echo off
sqlplus / nolog
conn sys / abcdefg @ server as sysdba
startup

After running, I found that I only went to the sqlplus / nolog step and did not go on, because after running sqlplus / nolog, I entered sql> and waited for the next command.
But the line conn sys / abcdefg @ server as sysdba was not entered.


What should I write?
Thank you for your guidance.

sh280303120

There is one less automatic answer

cyanolive

Thanks brother upstairs

cyanolive

Method found
Write oraStartup.bat
@echo off
cd\
sqlplus /nolog @oraStartup.sql>>oraStartup.log

Write oraStartup.sql
conn sys/abcdefg@server as sysdba
startup

Put the oraStartup.bat batch file to the start-Program-Startup. Let the system run oraStartup.bat after login to open the database instance

cyanolive

Write oraStartup.bat
@echo off
cd\
sqlplus /nolog @oraStartup.sql>>oraStartup.log
exit

Write oraStartup.sql
conn sys/abcdefg@server as sysdba
startup
exit

This is modified, and the exit exit command is added.