Shulou(Shulou.com)06/01 Report--

To uninstall oracle11g:

1. First turn off all oracle-related services, and then find oracle's uninstall program Universal Installer:

Then click to uninstall the product, then click to expand all, uninstall all applications except the home directory, and then click to show the empty directory and delete the home directory.

two。 Delete the registry:

Press the Windows logo key and R key, open the run window, type regedit, open the registry, expand HKEY_LOCAL_MACHINE\ SOFTWARE, locate oracle, and delete it.

  expand HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ Services and delete all items at the beginning of oracle.

  expands HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ Services\ Eventlog\ Application, and deletes all items at the beginning of oracle

  expands HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ Services\ Eventlog\ Application, and deletes all items at the beginning of oracle

  expands HKEY_LOCAL_MACHINE\ SYSTEM\ ControlSet001\ Services and deletes all items at the beginning of oracle.

3. Shut down and restart.

4. Delete the installation directory of the database: the following figure shows all the folders in the installation directory

Then delete the oracle under the folder of Program Files and Program Files (x86) on disk c

5. Finally, check to see if there is anything related to oracle in the list of all programs, if so, click, then open the file location and delete the corresponding folder.

In this way, you can reinstall if you find that the plsql connection does not report an error after installation: ORA-12154: TNS: the specified connection identifier cannot be parsed. It may be caused by the following problems:

1)。 Environment variables need to be added

ORACLE_HOME   F:\ app\ hanjuxiang\ product\ 11.2.0\ dbhome_1

TNS_ADMIN   ORACLE_HOME%/NETWORK/ADMIN/

2)。 If it still doesn't work, check the F:\ app\ hanjuxiang\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN directory for missing files such as listeners. If not, you can add it yourself with management tools. You can also ask someone to copy a normal two files, listener.ora and tnsnames.ora. The simple content is as follows:

Listener.ora:

# listener.ora Network Configuration File: d:\ app\ hjx\ product\ 11.2.0\ dbhome_1\ network\ admin\ listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\ app\ hjx\ product\ 11.2.0\ dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\ app\ hjx\ product\ 11.2.0\ Dbhome_1\ bin\ oraclr11.dll ")) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521)) ADR_BASE_LISTENER = D:\ app\ hjx

Tnsnames.ora:

# tnsnames.ora Network Configuration File: d:\ app\ hjx\ product\ 11.2.0\ dbhome_1\ network\ admin\ tnsnames.ora# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO)) LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521)) ORCL = DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = orcl)))

Then restart the computer and use plsql to connect again. (the configuration of plsql is not mentioned here, that is, install the corresponding client, and then make some configuration in the preferences)

Note that the oci library selects the installed client's.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.