How to install oracle

,

How to install Oracle:

Choose to install 11g on the Oracle official website;

Both of these must be downloaded.

After downloading, merge the two folders, copy the folder database in win64_11gR2_database_2of2 to win64_11gR2_database_1of2, Ctrl V, there will be a prompt box, whether to "merge", click OK.

Double-click the executable file setup.exe in the database directory, the following interface will pop up

First remove the check mark that supports update, because the update is meaningless big.

Click "Yes"

Click to create and configure the database

Click service class

Click single instance data installation

Click Advanced Installation

Chinese and English, click Next

Install the enterprise version, click Next

Install oracle on the D drive: D:\oracle\oracle\product\11.2.0\dbhome_1, select Next

Select General Purpose Transaction Processing and click Next

Database name, defined as "root"

Set the character encoding to utf-8

Check the example plan

Next step

Select Yes, complete

If there are wrong selections, ignore them all

Will appear after completion , the following interface will automatically create the database this time, but each database requires additional configuration.

Therefore, choose password management. Mainly operate the following users (set classic passwords)

Super administrator: sys/change_on_install;

Ordinary administrator: system/manager;

Ordinary user: scott/ tiger (needs to be unlocked)

Big data user: (sample database): sh/sh (needs to be unlocked)

Click OK.

Click Yes and then OK.

The installation is now complete. After installing Oracle, Oracle's related services will be set to start automatically. However, this will slow down the startup of the computer. All services must be set to manual services at one time.

You only need to start two services every time you start:

OracleOraDb11g_home1TNSListener: It is a listening service, if you want to use a program, or a different client When connecting to the Oracle server, this service must be started, otherwise it cannot be connected

OracleServiceROOT: The implementation service of the database, its naming standard: OracleServiceSID, whenever a user is added to the database, a similar message will appear Service name. By default, the SID name and the name of the database are exactly the same. The SID name is used on the network.

The following is after setting: (right-click on the computer->Management->Service->find the following related to oracle)

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of How to install oracle. For more information, please follow other related articles on the PHP Chinese website!