Solution to Oracle10g service failing to start after modifying computer name or IP
- 2021-10-25 00:07:55
- OfStack
Problems encountered, the cause of the problem is unknown. The symptom is that one oracle service in windows service cannot be started, and the following error is reported.
Windows cannot start OracleDBConsoleorcl on the local computer. For more information, consult the system event log. If this is a non-Microsoft service, please contact the service vendor and refer to the specific service error code 2
After finding 1 post from the Internet, the problem was solved, and the reason for solving it was unknown, but it was solved anyway.
Problem Description: School computer room master installation Oracle10g transmission to other machines, master Oracle can be used normally, and other machines start Oracle service can not start.
Specifically: "Windows cannot start OracleDBConsoleorcl on local computer" appears when "OracleDBConsoleorcl" is started in "Service".
For more information, consult the system event log. If this is a non-Microsoft service, contact the service vendor and refer to the service-specific error code 2 ".
Cause analysis: The computer installed with Oracle will not be able to start the service after modifying the computer name or IP.
Solution:
1. Delete the original database instance "orcl" (Note: It is best to complete this step on the master before transmission, otherwise the computer must be restarted after deletion):
Begin- > All procedures- > Oracle-OraDb10g_home1- > Configuration and Migration Tools- > Database Configuration Assistant- > The next step- >
Delete database- > The next step- > Finish- > Yes- > Yes- > Cancel- > Yes.
---------------------------
2. Reconfigure the listener:
Begin- > All procedures- > Oracle-OraDb10g_home1- > Configuration and Migration Tools- > Net Configuration Assistant- >
"Listener Configuration" Step 1- > "Reconfigure" Step 1- > The next step- > The next step- > The next step- > "No" Step 1- > (Cancel- > ) Complete.
3. Reinstall the database instance "orcl":
Begin- > All procedures- > Oracle-OraDb10g_home1- > Configuration and Migration Tools- > Database Configuration Assistant- > The next step- >
Create a database- > The next step- > The next step- > Enter "orcl" for "global database name" ("SID" will automatically fill in the same characters) next step 1- > The next step- >
Enter the original installation password and the confirmation password ("welcome") for "Same password for all accounts." Step 1- > The next step- > The next step- > The next step- > The next step- > The next step- > The next step- > The next step- >
Finish- > Determine- > Quit.
4. Configuration of local Net service name:
Begin- > All procedures- > Oracle-OraDb10g_home1- > Configuration and Migration Tools- > Net Configuration Assistant- >
"Local Net Service Name Configuration" Step 1- > "Delete" Step 1- > The next step- > Yes- > The next step- > The next step- >
"Local Net Service Name Configuration" Step 1- > "Add" Step 1 next- > "Service name" Enter "orcl" Step 1- > The next step- >
Enter the real "host name" of this computer (which can be found in the "My Computer" property). Step 1- > "Yes, test it." Step 1- >
Change login- > The password is changed to "welcome" to confirm- > The next step- > Web server named "orcl" Step 1- > The next step- > The next step- > (Cancel- > ) Complete.
5. Try whether PL/SQLdev can log in.
6. Log in to "http://Hostname or IP: 1158/em" (note that it is possible that 1158 has changed to 5500 or other ports at this time),
User name "system" password "orcl" login- > I agree- > Management.
Windows cannot start OracleDBConsoleorcl on the local computer. For more information, consult the system event log. If this is a non-Microsoft service, please contact the service vendor and refer to the specific service error code 2
After finding 1 post from the Internet, the problem was solved, and the reason for solving it was unknown, but it was solved anyway.
Problem Description: School computer room master installation Oracle10g transmission to other machines, master Oracle can be used normally, and other machines start Oracle service can not start.
Specifically: "Windows cannot start OracleDBConsoleorcl on local computer" appears when "OracleDBConsoleorcl" is started in "Service".
For more information, consult the system event log. If this is a non-Microsoft service, contact the service vendor and refer to the service-specific error code 2 ".
Cause analysis: The computer installed with Oracle will not be able to start the service after modifying the computer name or IP.
Solution:
1. Delete the original database instance "orcl" (Note: It is best to complete this step on the master before transmission, otherwise the computer must be restarted after deletion):
Begin- > All procedures- > Oracle-OraDb10g_home1- > Configuration and Migration Tools- > Database Configuration Assistant- > The next step- >
Delete database- > The next step- > Finish- > Yes- > Yes- > Cancel- > Yes.
---------------------------
2. Reconfigure the listener:
Begin- > All procedures- > Oracle-OraDb10g_home1- > Configuration and Migration Tools- > Net Configuration Assistant- >
"Listener Configuration" Step 1- > "Reconfigure" Step 1- > The next step- > The next step- > The next step- > "No" Step 1- > (Cancel- > ) Complete.
3. Reinstall the database instance "orcl":
Begin- > All procedures- > Oracle-OraDb10g_home1- > Configuration and Migration Tools- > Database Configuration Assistant- > The next step- >
Create a database- > The next step- > The next step- > Enter "orcl" for "global database name" ("SID" will automatically fill in the same characters) next step 1- > The next step- >
Enter the original installation password and the confirmation password ("welcome") for "Same password for all accounts." Step 1- > The next step- > The next step- > The next step- > The next step- > The next step- > The next step- > The next step- >
Finish- > Determine- > Quit.
4. Configuration of local Net service name:
Begin- > All procedures- > Oracle-OraDb10g_home1- > Configuration and Migration Tools- > Net Configuration Assistant- >
"Local Net Service Name Configuration" Step 1- > "Delete" Step 1- > The next step- > Yes- > The next step- > The next step- >
"Local Net Service Name Configuration" Step 1- > "Add" Step 1 next- > "Service name" Enter "orcl" Step 1- > The next step- >
Enter the real "host name" of this computer (which can be found in the "My Computer" property). Step 1- > "Yes, test it." Step 1- >
Change login- > The password is changed to "welcome" to confirm- > The next step- > Web server named "orcl" Step 1- > The next step- > The next step- > (Cancel- > ) Complete.
5. Try whether PL/SQLdev can log in.
6. Log in to "http://Hostname or IP: 1158/em" (note that it is possible that 1158 has changed to 5500 or other ports at this time),
User name "system" password "orcl" login- > I agree- > Management.