How to deal with oracle service loss

Oracle service is an important part of oracle Database. The following describes how to handle oracle service loss. If you have encountered oracle service loss problems before, take a look.

Today, we found that all oracle services on the database server were lost-that is, there were no oracle services in the Service Manager, such as OracleOraDb10g_home1TNSListener and OracleServiceORCL.

Solution:

1. Export all oracle services from the registry where oracle versions are required to be consistent on another machine with an oracle database installed.

Open the Registry directory HEY_LOCAL_MACHINE --> SYSTEM --> ControlSet001 --> Services, right-click the registry key and choose export.) All oracle items: oracleDBConsoleorcl, OracleJobSchedulerORCL, OracleOraDb10g_home1iSQL * Plus, OracleOraDb10g_home1TNSListener, and OracleServiceORCL are saved *. reg file.

2. Import the Registry file exported in the previous step to the server. Copy the file to the database server and double-click it one by one.

3. modify all the exported registry keys, mainly modifying the SID of the database instance and the database installation path.

4. Restart the database server.

5. Start the oracle Net Manager tool, delete the LISTENER and the local service in the service name, and rename the LISTENER and service.

6. Start the oracle service.

How to manage Oracle services in Windows

Implementation of Oracle redo log

Oracle Log File Management

Read and Write files in Oracle stored procedures

ORACLE Password Policy Verification Program