Workaround for oracle10g failed to start service after modifying computer name or IP

Workaround for oracle10g failed to start service after modifying computer name or IP

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.