Detailed installation and configuration of Oracle 11g

First, the preparation before installation:

First here to give my Baidu network disk link: Http://pan.baidu.com/s/1c1WF1PQ; fast speed of the small partners suggested to the official website: http://www.oracle.com/technetwork/database/ enterprise-edition/downloads/index.html for download.

After the download has been found to have two compressed packages, it is recommended that two compressed packages are decompressed, and then merged; before installing, we should pay attention to the following issues:

1. If you have a variety of virus firewalls on your computer, you must first shut down;
2. Make sure your system is healthy before installing.

If you are sure, click Setup to proceed to the installation process.

Second, the installation phase

Some small partners may have an error after clicking Setup, as shown in

　　

This is due to the system version problem, we can in the extracted files into the database folder, find the stage entry, and then go to the CVU folder, find the Cvu_prereq.xml file, open with Notepad, in a similar location to add the following:

<operating_system release= "6.2" >
<version value= "3"/>
<architecture value= "32-bit"/>
<name value= "Windows ten"/>
<ENV_VAR_LIST>
<env_var name= "PATH" max_length= "1023"/>
</ENV_VAR_LIST>
</OPERATING_SYSTEM>

Note: If the system version is Windows 8 or 8.1 modifies the system version on line 4th, if it is loaded 64 bits will change the third line to "64-bit".

Then proceed as steps

Because Oracle is a platform that can have several databases on this platform, you will be asked if you want to configure the database when you perform the Oracle database installation, select Create and configure a database, and then click Next

To prepare for the production environment, we must choose the server class

Then select the installation of the single instance database

When installing, select "Advanced Installation", configure the encoding, and need to define the sample data, no sample data, the following, such as Scott and Tiger will not be.

Select Simplified Chinese

Select Enterprise Edition Installation

Enter the installation directory configuration for the database

Select General purpose/Transaction processing

When configuring the database name, there will be a SID content, this refers to the service ID, which is the services ID, its primary role is to make the database network connection use, generally recommended database name and SID name exactly the same.

Then select the character set, select UTF-8 encoding, so as to ensure that no garbled problem will occur in the future,

Then select the sample scenario, tick the CREATE database with the sample scenario, if you don't choose a sample exercise without testing, and no Scott user

Then follow the default option has been the next step to specify the program password step, in the Oracle database will be provided by default several users, each user has different permissions, here will ask whether each user defined password, or unified set password, beginners for convenience can be unified set password for " Oracleadmin ". Note case

Choose Yes

After that, the check is completed and the installation phase is complete, and if an error is checked, you can ignore

Note that after the installation is complete, do not immediately click on the password management

Access to the database configuration (User Configuration), where you need to configure a password of four users, the password is now configured as a universal password.

Super Administrator: sys password: change_on_install;

General administrator: System Password: manager;

Normal User: Scott password: Tiger; (generated after the "sample" Schema database has been selected)

Big Data User: sh password: sh;

Access to the password management interface, you can manage the password, the Scott users and SH users behind the lock on the account below the hook removed, the hook is locked

Once the configuration is complete, click OK to install it.

III. Introduction to Oracle Services (check that the database is working properly)

Because Oracle consumes a lot of memory, service recommendations for Oracle databases are initiated manually

of the Oracle database services, there are two services that are the most important

Oracleoradb11g_home2tnslistener: The listening service, which is primarily reserved for client access to the machine, such as the need to connect to the database during application development, or if the service is not started, will cause the program to fail to connect.

The instance service of the Oracleservicemldn:oracle database can be configured with multiple databases at the same time on the Oracle platform. Using the tool "database Configuration Assistant", this tool can build more databases, if you are a beginner, it is not recommended to configure multiple databases. A service such as "Oracleservicesid" will be installed after each database is established, and if you want to use the MLDN database for data manipulation, the service must open

If you are only using this computer to connect the database, then you can not turn on the monitoring service. If you want to access it, you can do so using the SQL Plus command. Directly by running the window input

If you are logged in, a prompt will appear asking you to enter a user name, but the default is to not echo when you enter the password. Does not display with "*".

As long as you are able to log in now, it means that the current database can be used normally.

Note: During the installation of the entire Oracle database, the configuration of the database name and the user's configuration are the most critical parts.

Iv. Unloading of the database

Go to the installation directory and go to product-->11.2.0-->dbhome_1-->deinstall-->deinsytall.bat

Continue through the carriage return to achieve the next step, come here follow the prompts to enter Y

Go back in and enter Y here

Continue to enter the database after the cleanup operation, a few minutes (in fact, a long time), the database is uninstalled, the process may fail, restart the computer or shut down the Oracle service re-uninstall. You may also be prompted to delete some files, that is the file that is being used, it's okay, and so on after the uninstall, manual cleanup on the line

Detailed installation and configuration of Oracle 11g