The path to installing and detaching Oracle databases: The Path to oracle databases

The path to installing and detaching Oracle databases: The Path to oracle databases

========================================================== ============================================== ======================================

1. If there are two files when installing the database, you need to merge the two files before installing

After both files are decompressed, 1of2 contains the installation file and 2of2 only contains the jar package. You need to copy the folders under stage \ Components in 2of2 to this directory of 1of2.
NOTE: If no operation is available, the database will not run properly

2. During installation, you can follow the instruction in http://www.ixywy.com/oraclejsjc/328.html.

Figure 1 Figure 2
3. Select the database software after installation as shown in Figure 2 above.
4. Add the environment variable ORACLE_HOME.

5. After the installation is successful, go to the cmd command line mode and run the command lsnrctl status. If no listener is displayed
Check whether the listener. ora file exists in the D: \ app \ lenovo \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN directory. The Net Configuration Assistant to be selected does not have the listener Configuration.
After the configuration is successful, there is a listener in the Directory D: \ app \ lenovo \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN. ora file and tnsnames. ora file, use sqlplus/as sysdba and SQL developer
Cannot log on to the database (no database user is created, but the database software is installed)

6. After the installation is successful, you need to use the built-in oracle Configuration and transplantation tool-> Database Configuration Assistant to configure the Database User
After successful configuration, view the tnsnames. ora file changes and add sid

7. In cmd command line mode, use sqlplus/as sysdba and SQL developer to select sysdba mode, and enter the valid user created when the user is created using Database Configuration Assistant for logon.
The ORACLE database is the Instance name set when the database user is created. It is also the Instance name in tnsnames. ora.

 

 

 

========================================================== ======================================================= ======================================

1. To uninstall the database, run deinstall

2. delete information about the Registry
Delete all Oracle * related information under this directory
========"

 

 

=========="

 

 

3. If the system prompts that the main directory has been used during Reinstallation
Delete the C: \ Program Files \ Oracle \ Inventory \ ContentsXML folder. If a single file cannot be deleted, it is because the current installer is writing a log and you need to exit the installer and delete it, after the deletion is successful, reinstall it.

4. Delete Environment Variables

5. Delete the D: \ app file. During the deletion process, you may be prompted that the service is in use and cannot be deleted. You can stop the service and then delete it.

Select a service and click STOP.

The last oci. dll file cannot be deleted. You can view the task list in cmd command line mode to see that the current dll file is being used.
Tasklist/m oci. dll

After the service is stopped, the iexplore.exe program can be used for maintenance. At this time, you need to restart the computer and check that there is no process occupation. You can delete it.

When the taskkill/pid process number is used to kill iexplore, the shutdown interface is displayed. If the operation is canceled, oci. dll is still in use. If taskkill/pid process number/f is used to forcibly kill the process,
The desktop program will not be displayed. In this case, restart the iexplore process.
Ctrl + alt + delete, open the task manager, click File> new task in the upper left corner, enter the program name iexplore.exe to enable the process, and display the Desktop
=========="