The way to install and uninstall Oracle database

Source: Internet
Author: User


============================================= successfully installed the database =======================================================


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

After extracting two files, 1of2 contains the installation files, 2OF2 contains only the jar packages, and the folders under Stage\components in 2of2 need to be copied to the 1of2 directory.
Note: The database will not function correctly if no action is done here

2, installation, you can follow http://www.ixywy.com/oraclejsjc/328.html this tutorial to install



Figure 1 Figure 2
3, follow the above figure 2 to select the installation is complete, just installed the database software
4. Add environment variable Oracle_home

5. After successful installation, enter CMD command line mode, execute command lsnrctl status, if prompt is not listening
See if a Listener.ora file exists under the D:\app\lenovo\product\11.2.0\dbhome_1\NETWORK\ADMIN directory, there is no net Configuration to select Assistant Configuring listening
After the configuration is successful, there are listener.ora files and Tnsnames.ora files in the D:\app\lenovo\product\11.2.0\dbhome_1\NETWORK\ADMIN directory, which is used at this time Sqlplus/as SYSDBA and SQL Developer
Cannot log in to the database (no database user was created, but database software was installed)



6. After successful installation, you need to use Oracle's own configuration and porting tool->database Configuration Assistant to configure database users
After the configuration is successful, review the Tnsnames.ora file changes and add the SID


7. At this point, you can use Sqlplus/as SYSDBA and SQL developer in the cmd command line mode to select Sysdba mode and enter a valid user to log in when creating a user with Database Configuration Assistant.
Where the database Oracle is the instance name set when the database user is created, and also the instance name in Tnsnames.ora

=================================================== Uninstalling the database ======================================================= ====


1, unload the database, first execute deinstall batch file


2. Registry Delete Related information
Delete all oracle* related information in this directory
======== "

========= "


3. If you reload, you are prompted to use the main directory
Delete C:\Program Files\oracle\inventory\contentsxml This folder, if a single file cannot be deleted, because the current setup program is writing a log, need to exit the Setup program, and then delete, remove the success and then reinstall it


4. Delete environment variables


5, delete the D:\app file, the deletion process may prompt because the service is in use, cannot delete, may first stop the service, then deletes


Select service, Mail click Stop

The last Oci.dll file cannot be deleted, and the cmd command-line Mode View Task list indicates that the current DLL file is being used
tasklist/m Oci.dll

After the service is stopped, because it may be left to the Iexplore.exe program maintenance, the need to restart the computer, and then see no process consumption, you can delete

When using the TASKKILL/PID process number to kill IExplore, the shutdown interface will pop up, if the operation is canceled, then Oci.dll is still occupied, if the TASKKILL/PID process number/F is used to force the kill process,
Causes the desktop program to appear without any display, the IEXPLORE process needs to be restarted
Ctrl+alt+delete, open Task Manager, top left corner Click File--New task, enter program name Iexplore.exe to enable process, display desktop
========= "


The way to install and uninstall Oracle database

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.