Installation of Oracle Database tutorial

First, download the Oracle database or my blog from the official website

website address : Oracle Database
Blog Address : Blog

Second, the installation database

Note: A 10g database is only valid on XP operating systems.
It is recommended to install it on a virtual machine so you can play anywhere.
XP Image: Address

1, run the installer Setup.exe, the system will start the Oracle Universal Installer, and then perform a prerequisite check. will appear as shown in
650) this.width=650; "src="%5c "alt=" \ "\ \" Here write a picture description \ \ "" title= "\" \ \ "\"/\ "/"/>

2, then all the way next, to the last step when you need to configure your login information
650) this.width=650; "src="%5c "alt=" \ "\ \" Here write a picture description \ \ "" title= "\" \ \ "\"/\ "/"/>
3, after the installation is complete, automatically run the configuration wizard, such as, wait for its completion:
4, after completion, the "Password management" screen appears, click "Password Management", such as:
650) this.width=650; "src="%5c "alt=" \ "\ \" Here write a picture description \ \ "" title= "\" \ \ "\"/\ "/"/>

5. Remove the ditch for Scott and HR users (unlock these two accounts), as shown in, click "OK":
650) this.width=650; "src="%5c "alt=" \ "\ \" Here write a picture description \ \ "" title= "\" \ \ "\"/\ "/"/>
6, return to the "Password Management" interface, click "OK", such as:
650) this.width=650; "src="%5c "alt=" \ "\ \" Here write a picture description \ \ "" title= "\" \ \ "\"/\ "/"/>
7, install the end, click "Exit".

Third, configure the Client Connection tool Oracle Instant client and Sqlplus reference my blog: Install and use Oracle Instant client and Sqlplus Four, connect tool is configured, test connection on virtual machine

In DOS, enter:

sqlplus scott/[email PROTECTED]:1521/ORCL
192.168.62.168:1521: This is the IP address of the virtual machine that you connect to the database

The interface shows that you are logged in successfully:

The interface shows that you are logged in successfully:

650) this.width=650; "src="%5c "alt=" \ "\ \" Here write a picture description \ \ "" title= "\" \ \ "\"/\ "/"/>

Oracle Database Summary

Basic query of Oracle database
filtering and sequencing of Oracle databases
single-line function of Oracle database
multi-line functions of Oracle Database
Multiple table queries for Oracle databases

This article is from the "11115680" blog, please be sure to keep this source http://11125680.blog.51cto.com/11115680/1889924

Installation of Oracle Database tutorial