Today, we are working on a curd web application to build a backend for the subsequent use of extjs. Since Oracle databases have not yet been used, Oracle databases are also used as backend databases, and Oracle is also used in practice.
However, when I was using the Oracle database today, I was so angry that I could not create a user or connect to the Oracle database. When I connect to the database, I reported a no-listening program error. Then I found some configurations about Oracle monitoring on the Internet, but I still cannot follow the configurations described on other blogs. In the end, I came up with the worst solution: uninstall Oracle and reinstall it. The uninstallation of this large database takes a while, And the installation takes a longer time. As a result, I uninstalled and installed Oracle one morning.
You need to be careful when uninstalling it, but it is really troublesome! The following describes how to uninstall and install oracle.
To completely uninstall oracle11g:
1,Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services.
2,Start-> Program-> Oracle-orahome81-> Oracle Installation products-> universal installer, click "Uninstall product"-"Expand All ",Select all directories except "oradb11g_home1" and delete.
3,Run regedit, select HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle, and press del to Delete this entry.
4,Run regedit and select HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services. Scroll through the list and delete all Oracle entries (Keys starting with Oracle or oraweb ).
5,Run refedit, HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ Eventlog \ Application to delete all Oracle entries.
6,Delete all keys prefixed with ora, Oracle, orcl, or enumora in the hkey_classes_root directory.
7. Delete all keys starting with Oracle in HKEY_CURRENT_USER \ Software \ Microsoft \ Windows \ CurrentVersion \ Explorer \ menuorder \ Start Menu \ Programs.
8,Delete all Oracle keys except the Microsoft ODBC for Oracle registry key in HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ odbcinst. ini.
9,My computer --> properties --> advanced --> environment variables, delete the Oracle settings in the environment variables classpath and path.
10,Delete all groups and icons related to Oracle from the desktop, startup group, and program menu.
11,Delete all Oracle-related directories (if the directories cannot be deleted, restart the computer and delete the directories again) including:
1. c: \ Program file \ oracle directory.
2. oracle_base directory (Oracle installation directory ).
3. c: \ windows \ system32 \ config \ systemprofile \ oracle directory.
4. c: \ Users \ Administrator \ oracle or c: \ Documents and Settings \ Administrator \ oracle directory.
5. c: \ Delete the following files in Windows: Oracle. ini, oradim73.ini, oradim80.ini, oraodbc. ini, and so on.
6. C: \ if the windows. ini file contains a [Oracle] Tag segment, delete the segment.
12,Delete all Oracle-related odbc dsn if necessary
13,In the event viewer, delete Oracle-related log Description: if some DLL files cannot be deleted, ignore it and restart to start a new installation. During installation, select a new directory. After installation and restart, the old directory and files can be deleted.
Install oracle11g
Step 1: Click the installer to go to the installation page, as shown in:
Step 2: select the first option and click Next
Step 3: select the desktop class and click Next.
Step 4: select the installation directory
Step 5: Select ignore all
Step 6: This shows some of your installation information. Click Finish.
Step 7: The installation is in progress at this time. It takes a long time to wait. You can have a cup of tea.
Finally, the installation is complete.
Enter sqlplus/As sysdba In the doc command line and press Enter. If the following information appears, congratulations! Oracle is installed successfully!