Java programmer cainiao (1) Oracle BASICS (1) windows_7 installation of Oracle and simple configuration

From today on, I will also enter the ranks of oracle. Oracle has always had a sense of reverence. Oracle is always different from other databases. Maybe it was because I was scared by the teacher during my freshman year. I tried it a little today. It seems that Oracle is not as sacred as you think. Haha. This is a learning achievement. We will share it with you. We hope to provide some help for your future study. Today, I will introduce the installation of Oracle in Windows 7.

First, attach ORACLE:

Http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip

This address does not need to be accessed. You can download it directly to thunder.

The downloaded package is a compressed package. Decompress the package. You can see the following files:

Run setup.exe

You can select "Basic installation" or "Advanced installation" when installing Oracle database at 10 Gb. When "Basic installation" is selected, "Oracle main directory location" is used to specify the storage location of the Oracle Database 10 Gb software; the "installation type" is used to specify the installation type (Enterprise, standard, and personal) of Oracle products ). If you select "create startup Database", you must specify the global database name and password of the database user. Generally, we choose the Basic installation here.

After entering the information, click Next.

Note that. Some unknown errors are prompted at the beginning of my installation:

The system prompts that the program is terminated abnormally and an unknown error occurs.

Search results on the Internet:

Modify Oracle 10g \ database \ stage \ prereq \ dB \ refhost. xml

In the </system>
<Certified_systems>

<! -- Microsoft Windows 7 -->
<Operating_system>
<Version value = "6.1"/>
</Operating_system>

 

Go to the install directory and find the oraparam. ini file.

# Windows = 4.0, 5.0, 5.1, 5.2

Modify

# Windows = 4.0, 5.0, 5.1, 5.2, 6.1

Add

[Windows-6.1-required]
# Minimum Display colours for Oui to run
Min_display_colors = 256
# Minimum CPU speed required for Oui
# CPU = 300
[Windows-6.1-optional]

 

Running or error ....

 

Solution: Right-click setup, choose Properties> compatibility> run Windows XP (Service Pack 3) in compatible mode, and run the installation as an administrator.

Okay. Solve the problem.

Click Next

In fact, the rest is basically the completion of the next step. There are no precautions. In fact, the installation of Oracle is always relatively simple.

After the installation, we can use Oracle. Click

Click SQL plus to run. By default, Oracle will give us a username and password: Scott and tiger. But for the sake of security. The user name and password are locked. Therefore, to use this password, we must first unlock it:

1. log on to Oracle using system as the user name and the password you set for installing the database as the password

2. Enter the Oracle thick input UNLOCK command:

Alter user Scott identified by tiger account unlock;

Then you will see the following prompt:

Prompt that you have successfully unlocked

Then we can use Scott and tiger to enter oracle. Why do we enter this user. This user provides some sample databases for Oracle by default. We can use this example database for some simple connections.

We run Oracle on the graphic interface. We can also run SQL plus in the online version. Run the following command in IE: http: // localhost: 5560/isqlplus/

5560 is the default port of oracle. To access this address, you will see the following interface asking you to enter the user name and password:

I forgot to mention it above. For accessing the local Oracle database. The connection identifier does not need to be written. If you want to access the oracle of another machine, enter the connection identifier here. Enter the user name and password and you will see:

You can perform simple SQL operations in the workspace.

Next, let's take a look at the third way to operate ORACLE: Operating oracle in DOS

First open dos and enter the following password in DOS:

Sqlplus user name/password. Then you will see the following interface:

OK. The simple Oracle configuration we use ends here. I want to know about the simple Oracle operations.