Shulou(Shulou.com)06/01 Report--

Note: I wanted to install an oracle on my computer, but I was afraid of problems in the installation process, and the uninstallation of oracle was notoriously troublesome, so I used a virtual machine to build a system that was the same as this machine, and recorded every step of the installation.

Environment:

Windows10 system

It is best to install jre or jdk first (this software is used to open the visual interface of oracle, and it doesn't matter if you don't install it; you can install plsql or use the command line directly)

1. Download oracle

* download address: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

* download files (version 11g, enterprise version, both files)

2. Oracle installation

a. Extract the two downloaded packages to the same folder and click setup.exe in the unzipped file to start the installation.

b. The installation is divided into 10 steps. First, uncheck the security update and click "next".

c. Select install database software only, and click next

d. Select single instance Database installation, and click next.

e. Default selection, click "next"

f. Select Enterprise Edition and click next.

g. Select the installation directory of oracle here (that is, the location of the software on your computer), and click "next"

h. Here is a summary of your previous seven step selections, where you can check to see if your previous choices are wrong. After confirmation, click "next"

i. Here is a long wait for the installation process.

j. Installation is complete, click "close"

3. Oracle database configuration

After the oracle software installation is complete, you need to configure a database for use. There are many steps to configure the oracle database, but most of them are the default, the next step, so it's 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. Default selection, click "next"

d. Enter the name of the global database (that is, the name of the database). SID is created by default, and click "next"

e. Uncheck the "configure Enterprise Manager" box and click "next"

f. Select "all accounts use the same administrative password" and enter the password (that is, the password of the database user sys,system). There are many users in oracle database, and sys and system are the administrators of the database with the largest permissions.

g. Without making any changes, click "next"

h. Without making any changes, click "next"

i. Select sample scenario (several tables will be created by default), and click next

j. Without making any changes, click "next"

k. Click "next"

l. Without making changes, click "finish"

m. To confirm that the configuration information is correct, click OK

n. Install and wait for a long time

o. After the installation is complete, pop up the following page and click "password Management" to enter the user management page.

P., find the SCOTT user in the following figure, cancel "Lock account", enter "New password" and "confirm password", click "OK" to complete the configuration of the database

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

4. Oracle listener configuration

After configuring the database, you also need to configure monitoring to facilitate future use. The specific configuration process is very simple.

a. Open the windows start menu, find "Net Conguration Assistant" under the oracle column, and click Open

b. Select listener configuration, and click next

c. Select "add" and click "next"

d. Without making any changes, click "next"

e. Select "TCP" and click "next"

f. Without making any changes, click "next"

g. Click finish to complete the configuration of the monitor.

5. Configure environment variables

The path is under the home directory of oracle (the home directory was selected during oracle installation)

Create a new ORACLE_HOME=C:\ soft\ product\ 11.2.0\ dbhome_1

Edit: Path=%ORACLE_HOME%\ BIN

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

Create a new NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Restart the computer for the environment variable to take effect

6. Log in to the database

According to the above method, the database is installed successfully. You can use the sqlplus tool that comes with oracle or the command line to log in and view the database.

a. Open the command line and enter: sqlplus

b. Enter user name: scott, password: scott (user name can be lowercase, oracle will automatically convert all lowercase to uppercase, in oracle database all letters are uppercase), and enter the database

7. Problems and solutions

Although you can now log in to the database from the command line, you will find two more problems when you log in to the database using tools such as plsql.

Problem 1: database not found

Problem 2: no listener found (no listener)

Although we have configured the database and listeners before, these two problems still exist.

Of course, the previous configuration database and configuration listener are also necessary steps. Now these two problems should be that the oracle configuration software is not good enough.

Here are the solutions to these two problems:

a. Open the windows start menu, find "Net Manager" in the oracle directory, and click Open.

b. Click "Service naming", and then click "+" on the left

c. Enter the name of the network service on the pop-up page (you can write it freely, not very important), and click "next"

d. Select "TCP/IP Protocol" and click "next"

f. The database should be local, so the hostname: 127.0.0.1, the default selected when the port number is installed (that is, 1521)

g. Service name (that is, the name of the database), click "next"

h. Click "finish"

i. As shown below: you can see the configuration you just made so that you can find the database you installed

j. Click "listener", open LISTENER, that is, the listener configured in step 4, click "Delete address" in the lower right corner, delete both existing addresses, and then click "add address" after deletion. Do not modify the newly added content, exit and save it.

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

In fact, the root of these two problems lies in the lack of corresponding configuration of the two files in the following figure. If you are interested in doing the above configuration, you can pay attention to the changes in these two files.

Add:

1. Installation options: select "create and configure databases" (oracle itself is only a platform on which several databases can exist)

2, system class: the selected is "server class" (desktop class-this kind of installation is generally suitable for desktops and notebooks. It contains a minimum database and minimum configuration requirements.

Server class-this installation applies to the server, for example, it provides you with data centers and applications for support. If you need to use advanced configuration options, select this installation type.

In the desktop class, there are only basic options.

In the server class, you can choose either a standard installation (which only gives you a basic choice) or an advanced installation.

In a desktop class or a typical installation, the sample library is installed automatically. )

3. Network installation option: select "single instance database" (formerly known as Oracle Parallel Server,OPS) to achieve multi-machine shared database in the cluster environment to ensure high availability of the application. At the same time, it can not only realize parallel processing and load sharing automatically, but also realize fault tolerance and non-breakpoint recovery of database in case of failure. Oracle Real Application Clusters (Oracle RAC) is an application that runs on multiple computers at the same time. A single instance can be considered as a stand-alone version, while the latter is a cluster version)

4. Installation type: select "Advanced installation" (advanced installation can configure "coding" and define sample data, but data such as scott cannot be used without sample data)

5. Database version: select "Enterprise version"

6. Installation location: the oracle base directory can be freely set: d:\ app\ mldn, and select the database type to be created. Select "General purpose / transaction"

7. Database identifier: "Global database name" defaults to: orcl, which can be set to "mldn"

Oracle service identifier (SID): refers to Service ID, the service ID, whose main role is to be used as a network connection to the database

8. Configuration options: select "character set" to set to "utf-8", and "instance Scheme" is open, and "create a database with an example scheme"

9. Management options: direct default

10. Database storage: direct default

11. Backup and reply: direct default

12. Program password: select "use the same password for all accounts" and set it to oracleadmin. The password is not standard, it doesn't matter.

13. Prerequisite check: problems can be ignored. Click "finish".

14. Install the product: after the installation is completed, you will automatically jump to an interface "database configuration asssistant". You need to configure this interface, select "password Management", and set "Super Admin: sys/change_on_install".

, ordinary administrator: system/manager, ordinary user: scott/tiger, big data user: sh/sh

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.