An Oracle database instance under Windows does not automatically open database problem

An Oracle database instance under Windows does not automatically open database problem

Note: This article applies to the premise that Oracleservicelei in Windows Services is automatically or manually initiated.

In daily operations, if you encounter an Oracle database instance under Windows that does not automatically open database, I usually get a bat script in the Windows Launcher.
The contents of the script are as follows:

The contents of Startup.bat are as follows:

net start oraclecsserviceset oracle_sid=+asmnet start Oracleasmservice+asmset nls_lang=american_america. Zhs16gbkd:\oracle\product\10.2.0\db_1\bin\sqlplus/as sysdba @c:\startup.sqlset oracle_sid=leinet start Oracleserviceleiset Nls_lang=american_america. Zhs16gbkd:\oracle\product\10.2.0\db_1\bin\sqlplus/as SYSDBA @c:\startup.sql

The contents of Startup.sql are as follows:

Startupexit

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

An Oracle database instance under Windows does not automatically open database problem