Oracle 11g Detailed installation configuration tutorial

Recently began to learn Oracle database, according to my understanding of Oracle database is a powerful, complex, high-performance database, and expensive, the use of large enterprises, local tyrants dedicated. Learning a database to get started is to install such a database, in view of the large number of friends installed problems, I installed the database of the process to make a detailed text tutorial.

Material: Oracle 11g

: http://pan.baidu.com/s/1c1vd3H2

Unzip the corresponding compressed package to the same folder according to the number of bits in the computer

Click on the extracted files in the Setup.exe, the following to start the detailed diagram

First, installation

I use the server2012, win8.1 have this hint, direct click is

For development purposes only, I will not fill out the mailbox and receive security updates

Click Yes

The first is that the installer and the creation of the database at the same time, I choose this one, the installation process is relatively second more convenient

The development environment chooses the first kind

Oracle Base Directory It is best not to put the C-disk , on the other disk, my server only one disk, so installed in the C drive

The version, the character set, and the global database name are the same as in.

Manage passwords I filled in the orcl . As with the name, easy to test

Then click Next

Click Yes

Just take a look at this and click Next.

At this point, we can take a break, the software installs automatically

Then wait.

Software automatic installation will pop up this interface, do not shut down, we point password management

In this step, we unlock Scott, the test user, set the password tiger

Set system and SYS passwords to their respective names for easy memory

Choose Yes

That would be a complete installation.

Oracle has registered these services in the system

ORACLESERVICEORCL: Primary service, only console connection must start this service

Oracleoradb11g_home1tnslistener: You need to turn on this monitoring service when using the connection tool or remote connection

Second, the configuration

Find NetConfiguration this program, start

First select the Listener configuration and click Next

Select Reconfigure, Next

Don't move, then choose Next

Report a prompt, found that the listener is running, the purpose to achieve, select No

Go back to configure the main page, select the Local network service name configuration, click Next

In the drop-down box, select Orcl Next

Service Name Fill ORCL Next

Select TCP Next

hostname complete localhost, using standard port number 1521 next

Check to test next

Show the test is unsuccessful, it's OK, click Change Login, Test success will not point the next step

Fill in the account and password that we configured earlier, click OK

OK test successful, click Next

Click Next directly

Select No, Next

Configuration complete, click Next

Test database is not able to connect up, enter sqlplus at the command line and then follow the prompts to enter Scott and password Tiger

Test success

"Cai Yuan Zi from Le Zhi: Www.cnblogs.com/AIThink, the code word is not easy, reproduced please indicate the source." 】

Oracle 11g Detailed installation configuration tutorial