Windows oracledatabase instances cannot automatically open the database.

Windows oracledatabase instances cannot automatically open the database.

The oracle database instance in windows cannot open the database automatically.

Note: This article applies to the premise that OracleServiceLEI in windows Services is automatically or manually started.

During routine O & M, if an oracle database instance in windows cannot automatically open the database, I usually put a bat script in windows startup,
The content of the script is as follows:

The content of startup. bat is 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 content of startup. SQL is as follows:

Startupexit