In NT, how does one completely delete oracle?

Software environment:
1. Windows 2000 + Oracle 8.1.7
2. Oracle installation path: C: \ oracle

Implementation Method:
1. Start-> Settings-> Control Panel-> management tools-> services
Stop all Oracle services.

2. Start-> Program-> Oracle-orahome81-> Oracle Installation products->
Universal Installer
Unmount all Oracle products, but the universal installer cannot be deleted.

5. Run regedit, select HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle, and press del to delete the entry.

6. Run regedit, select HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services, and scroll
Delete all Oracle entries.

7. Run refedit,
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ Eventlog \ application,
Delete all Oracle entries.

8. Start-> set-> Control Panel-> system-> advanced-> environment variable
Delete Oracle settings in the environment variables classpath and Path

9. Delete all groups and icons related to Oracle from the desktop, startup group, and program menu.

10. Delete \ Program Files \ oracle directory

11. restart the computer to completely delete the Oracle directory.

12. Delete Oracle-related files, and select the default Oracle directory c: \ oracle.
And delete the following files from the Windows 2000 directory (generally c: \ WINNT ).
Oracle. ini, oradim73.ini, oradim80.ini, oraodbc. ini, and so on.

13. If the [Oracle] Tag segment exists in the win. ini file, delete it.

14. If necessary, delete all Oracle-related ODBC DSN

15. In Event Viewer, delete Oracle-related logs.

Note:
If some DLL files cannot be deleted, You can restart and start a new installation,
During installation, select a new directory. After the installation is completed and restarted, the old directory and files can be deleted.

 

Six most common Oracle errors and Solutions

No one would deny that Oracle is one of the most influential database products in the world; but good things do not seem to be so useful (it seems at first ), even a bit heartless-it always gives layman a heartless error number. The following is my personal summary, which is useful and I hope to give some inspiration to beginners.

A joke about "good things do not always look so useful (it seems so early)": before attending IBM DB2 512 and 513 training, I downloaded the installer on the campus network, however, for a few of us to study it for a long time, I do not know which file is the installation file, but it was not installed successfully. Finally, I agree that this training is really necessary! I learned later that we downloaded 4 Linux!

[Take 8.1.6 as an example]:

1. ORA-12541: TNS: No listener

Cause: the listener is not started or damaged. For the former, run the Net start oracleorahome81tnslistener command (the name may be different). For the latter, you can add a listener to "Listener Configuration" in the "net8 configuration assistant" tool wizard. (no information is required. You may need to delete all listeners before adding them !)

2. ORA-12500: TNS: The Listener cannot start the dedicated server process
Or
ORA-12560: TNS: protocol adapter error.

Cause: Oracle Database Service is not started. Run the Net start oracleserviceoradb command (oradb is the database name. If the problem persists, proceed to the following section.

3. If the database service fails to be started, the registry key value may be corrupted. The best practice is to perform the following two steps:

1) oradim-delete-Sid oradb deletes database service items
2) oradim-New-Sid oradb adds database service items
Note: if an error occurs during this process, restart the computer!

4, ORA-12154: TNS: can resolve the service name

Cause: the network service name of Oracle is not correctly configured. Use "Local Network Service name configuration" in the "net8 configuration assistant" tool Wizard to configure TNS. If the problem persists, proceed to the following section.

5. ORA-1034: TNS: Oracle unavailable

Cause: the Oracle Database Service is correctly started, but the database is not opened!

Run the following command:

1) svrmgrl start the Service Manager
2) connect internal logs in as internal
3) Startup open the database

6. ORA-12560: TNS: protocol adapter error (stubborn)

Cause: unknown.

Solution: Be sure to activate the Windows Task Manager, kill oracle.exeand oradim.exe processes, write your own ora_startup.bat, and execute it!

PS:

1. My ora_startup.bat:

Net start oracleorahome81tnslistener
Net start oracleserviceoradb
Svrmgrl is generally not used, but sometimes it is indispensable. For detailed steps, see step 1.

2. My ora_shutdown.bat:

Net stop oracleorahome81tnslistener
Net stop oracleserviceoradb

3. for Oracle service names, see service names starting with Oracle in "services" in "Administrative Tools.

 

Finally, Let's explain the problem:

Today, the optimization master optimized the system and cleared junk files and registries. After the restart, oracle9 cannot be opened. The following error is reported:

An error occurred while starting the oracleorahome90tnslistener service. Information:
The oracleorahome90tnslistener service cannot be started on the local computer,
Error 3: The specified path cannot be found.
After checking the information on the Internet, I found that the location of these files is generally determined by the ORACLE_HOME variable of the Registry.
Let's take a look at the ORACLE_HOME value in the hkey_loacl_machine/software/Oracle registry.
If you do not have this value, you must add it.
The ORACLE_HOME value is generally the installation directory of Oracle, for example, 'c: \ oracle \ ora90'
(The other directory c: \ oracle \ ADMIN corresponds to oracle_base, which is the default location for your database)
Check whether the ORACLE_HOME \ Network \ admin \ listener. ora file exists.

The above files are in good condition!

Open the Registry hkey_loacl_machine \ System \ currentcontrolser \ Services \ oracleorahome90tnslistener and find that the path ImagePath is missing. Then, create a new string ImagePath with the key value "C: \ oracle \ ora90 \ bin \ LSNRCTL"

Restart oracleorahome90tnslistener and report an error.

Oracle listener cannot be opened!
Error: 1053

 

Find the problem again and change the ImagePath in the Registry to "C: \ oracle \ ora90 \ bin \ tnslsnr.exe"

Solve the problem.