Windows 10 x64 installation and configuration of Oracle 11g process records (Graphic tutorial), Windows 10 11g

Windows 10 x64 installation and configuration of Oracle 11g process records (Graphic tutorial), Windows 10 11g

Note: I want to install an oracle exercise on my computer, but I am afraid of problems during the installation process, and oracle uninstallation is notoriously troublesome, therefore, a system with the same virtual machine as the local machine is built, and each step of installation is recorded.

Environment:
Windows 10 System
It is best to install jre or jdk first (this software is used to open the visual operation interface provided by oracle. It does not matter if it is not installed. you can install plsql or directly use the command line)

1. oracle download

*: Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
* Download files (for version 11 GB, Enterprise Edition, and both files)

2. oracle Installation

A.m. decompress the two downloaded packages to the same folder. Click setup.exe in the decompressed file to start installation.

B. There are 10 installation steps. Step 1: deselect the Security Update check box and click "Next"

C. Select "Install database software only" and click "Next"

D. Select "Single Instance database installation" and click "Next"

E. Click "Next" by default"

F. Select "Enterprise Edition" and click "Next"

G. Select the oracle Installation Directory (the location of the software on the computer) and click "Next"

H. Here is a summary of your previous seven steps. You can check whether the previous steps are incorrect. Click "Next" after confirmation"

I. The following is a long wait for the installation process.

J. The installation is complete. Click "close"

3. oracle Database Configuration

After the oracle software is installed, You need to configure a database for use. Oracle databases have many configuration steps, but most of them are default. The next step is not troublesome.

A. Open the windows Start Menu, find "Database Configuration Assistant" in the oracle Installation Software, click open, and click "Next"

B. Select "CREATE DATABASE" and click "Next"

C. Select by default and click "Next"

D. Enter the global database name (that is, the database name). SID is created by default. Click "Next"

E. deselect the "Configure Enterprise Manager" check box and click "Next"

F. Select "all accounts use the same management password" and enter the password (that is, the password of the database user sys and system. Oracle databases have many users. sys and system are database administrators with the highest permissions)

G. Do not modify it. Click "Next"

H. Do not modify it. Click "Next"

I. Select "sample solution" (several tables will be created by default) and click "Next"

J. Do not modify. Click "Next"

K. Click "Next"

L. Do not modify it. Click "finish"

M. confirm that the configuration information is correct and click "OK"

N. Installation, long waiting

O. After the installation is complete, the pop-up page appears. Click "password management" to go to the user management page.

 

P. Find the SCOTT user, cancel "lock account", enter "new password" and "Confirm Password", and click "OK" to complete database configuration.

In this way, the database can be logged on with sys, system, and scott.

4. oracle Listener Configuration

After configuring the database, you need to configure the listener for future use. The specific configuration process is very simple.

A. Open the windows Start Menu, find "Net Conguration Assistant" in the oracle column, and click Open

B. Select "Listener Configuration" and click "Next"

C. Select "add" and click "Next"

D. Do not modify it. Click "Next"

E. Select "TCP" and click "Next"

 

F. Do not modify it. Click "Next"

G. Click "finish" to complete the Listener Configuration.

5. Configure Environment Variables

The path is in the oracle main directory (the main directory selected during oracle Installation)

Create ORACLE_HOME = C: \ soft \ product \ 11.2.0 \ dbhome_1,

Edit:Path= % ORACLE_HOME % \ BIN

 

Create TNS_ADMIN = C: \ soft \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN

Create NLS_LANG = AMERICAN_AMERICA.AL32UTF8

Restart your computer to make environment variables take effect

6. log on to the database

According to the above method, the database is successfully installed. You can use the SQL plus tool or command line tool provided by oracle to log on to and view the database.

A. Open the command line and enter sqlplus.

B. enter username: scott, password: scott (username can be in lower case, oracle will automatically convert all lowercase to upper case, all the letters in the oracle database are in upper case), and then enter the database

7. Problems and Solutions

Although you can use the command line to log on to the database now, when you use tools such as plsql to log on to the database, there are still two problems.

Problem 1: The database cannot be found.

Problem 2: No listener found (no listener)

Although we have previously configured databases and listeners, these two problems still exist.

Of course, the preceding steps are required to configure the database and listener. These two problems should be caused by the fact that the oracle configuration software is not well written.

The solution to these two problems is as follows:

A. Open the windows Start Menu, find "Net Manager" under the oracle directory, and click Open

B. Click "service name" and then click "+" on the left"

C. enter the name of the network service on the pop-up page (which can be written at will, not very important) and click "Next"

D. Select "TCP/IP protocol" and click "Next"

F. The database must be on the local machine. Therefore, enter 127.0.0.1 as the host name. The default value (1521) is selected when the port number is installed)

G. Service name (database name), click "Next"

H. Click "finish"

I. For example, you can see the configuration you just made, so that you can find the database you installed.

J. click "LISTENER" to open the LISTENER, which is the LISTENER configured in step 2. Click "delete address" in the lower right corner to delete both existing addresses. After deletion, click "add address". Do not modify the newly added content. Exit and save the content.

In this way, you can use other clients to access the oracle database.

In fact, the root cause of these two problems is that the two files in the file do not have the corresponding configuration. If you are interested, you can pay attention to the changes in the above configurations.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.