Database Server Exception Handling 1

Platform:
Operating System Platform: win2003server oracle10.1

Symptom:
The database cannot be started, and the listener cannot be started normally. The site reported a problem with the two database servers and asked them what they were doing. The answer was: I don't know what they were doing. It only restarts the machine.

Analysis:
After the remote connection, you will find that the system prompts you to find the directory when netmgr is started.
You can use netca to reconfigure the listener and find that the listener service name is very short. The group_home name of Oracle is missing and this information is missing each time you create a new listener. It is suspected that environmental variables such as oracle_base and ORACLE_HOME are lost.

Solution: During the analysis, a newly created lisnter is occasionally found. ora, the onsite Staff finally replied that a third-party software was installed, which was integrated with the Oracle client class library during installation. Check the registry and find that there is no oracle information in it. You can confirm that the Oracle entry of the Registry is deleted when the software is uninstalled. Export related registry items from other systems, import the database, and modify related paths and inconsistencies. Restart the listener and solve database problems.

Summary:
The fewer users and passwords on the database server, the better.
We recommend that you install the database on Unix or Linux.