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

Source: Internet
Author: User
Tags sqlplus

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.