A workaround that oracle10g service cannot start after modifying the computer name or IP _oracle

Source: Internet
Author: User
Tags error code create database
Problems encountered, the cause of the problem is unknown. The symptom is that there is an Oracle service in the Windows service that cannot be started and reported the following error.

Windows cannot start ORACLEDBCONSOLEORCL on the local computer. For more information, check the system event log. If this is a non-Microsoft service, contact your service manufacturer and refer to the specific service error code 2

After the internet to find a paste, problem solving, the reasons for the unknown, anyway is resolved.

Problem Description: School room master Disk installation oracle10g transfer to other machines, the master disk Oracle can be used normally, while other machines start the Oracle service can not start.

Specifically: When you start ORACLEDBCONSOLEORCL in services, Windows cannot start ORACLEDBCONSOLEORCL on the local computer.

For more information, check the system event log. If this is a non-Microsoft service, contact your service manufacturer and refer to the specific service error code 2.

Cause Analysis: The installation of Oracle computer computer name or IP will not start the service.

Workaround:

1, delete the original database instance "ORCL" (Note: It is best to complete this step on the master before transmission, otherwise you must restart the computer after the deletion):

Start-> All Programs->oracle-oradb10g_home1-> configuration and porting tools->database Configuration assistant-> next->

Delete Database-> Next-> complete-> is-> is-> cancel-> is.

---------------------------

2. Reconfigure the Listener:

Start-> All Programs->oracle-oradb10g_home1-> configuration and porting tools->net Configuration assistant->

"Listener Configuration" next-> "Reconfigure" next-> next-> next-> next-> "No" Next-> (Cancel->) complete.

3, reinstall the database instance "ORCL":

Start-> All Programs->oracle-oradb10g_home1-> configuration and porting tools->database Configuration assistant-> next->

Create Database-> next-> next-> "Global database name" enter "ORCL" ("SID" will automatically populate the same character) next-> next->

Use same password for all accounts enter the password and Confirm password ("Welcome") at the time of the original installation next-> next-> next-> next-> next-> the next step-> next->

Complete-> OK-> exit.

4. Local NET service name configuration:

Start-> All Programs->oracle-oradb10g_home1-> configuration and porting tools->net Configuration assistant->

"Local NET service name configuration" Next-> "Delete" next-> next-> is-> next-> next->

"Local NET service name configuration" Next-> "add" next-> "service name" enter "ORCL" Next-> next->

Enter the native "hostname" (available in the "My Computer" attribute) next-> "Yes, test" next->

Change login-> Password Modify to "Welcome" OK-> next-> network server named "ORCL" next-> next-> the next step-> (Cancel->) complete.

5, trial Pl/sqldev whether can login.

6, Login "http://host name or ip:1158/em" (note that at this point may be 1158 has become 5500 or other ports),

Username "System" password "ORCL" Login-> I agree to-> management.
Related Article

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.