Install and use Oracle in windows

Install and use Oracle in windows

I. Download the oracle database from the official website

Here I downloaded oracle 11g r2, and selected the corresponding download file based on my operating system. Here I am windows 64-bit, so select the second one and click see all

Click accept license to download the zip Packages 1 and 2 of the database file.

Ii. Install the Oracle database (refer to the steps in Baidu)

1. After the download is completed, extract the two compressed files to the same folder. The default file name is database.

2.go to the database directory and click setup.exe. The installation page will appear later.

You do not need to enter the email address. Click continue.

Select create and configure database, and next

Select the desktop class and next step

For others, you can enter the password by default. The password can consist of letters and numbers, and the first letter can be capitalized. Otherwise, an invalid prompt will appear.

Prerequisite check: If your memory can meet the requirements of Oracle Installation, you can directly check and ignore all of them. Next step, you can use it even if there is a problem with the prerequisite, which is sometimes a problem with the operating system, for example, the installed ghost System

Next, continue to the next step. It will take several minutes to install. Wait until the installation is complete.

Iii. Test whether Oracle is successfully installed

Go to cmd, type the command sqlplus/as sysdba, log on to oracle, and then type the command select * from v $ Version. If Version information is displayed, Oracle is basically installed.

4. Create an Oracle user for ease of use

# Sqlplus/nolog


SQL> conn/as sysdba;


SQL> create user username identified by password


SQL> grant dba to username;


SQL> conn username/password


SQL> select * from user_sys_privs;

Create a user based on commands in this format

5. Use a graphical interface to manage Oracle databases. One is plsqldevelop and the other is navicate for oracle. Here I use navicate for oracle.

The installation is relatively simple. If you encounter problems, you may encounter many problems when using this software, which is generally caused by version incompatibility.

Replace oci. dll in the file instantclient_10_2 under navicate. To prevent problems, replace it here

Because my oracle is 11g r2, download the instantclient_11_2 zip package online for decompression.

Then, configure the path to the system environment variable.

Add NLS_LANG AMERICAN_AMERICA.UTF8 to the user variable

Sqlpath d: \ java develop \ instantclient_11_2

Add D: \ java develop \ instantclient_11_2 before the Path variable in the system variable;

Click application OK.

Open navicate for oracle and Click Tools> Options> OCI. In the OCI library item, configure the path of the downloaded instantclient_11_2 to the file.

Restart navicate

Use navicate for oracle to connect to Oracle and connect to Oracle successfully. Now, you can easily use oracle.

Download related installation packages here