Oracle database Installation diagram and use of basic command lines

Oracle database Installation diagram and use of basic command lines

Oracle Database Installation

1. Download Oracle database software

Http://download.oracle.com/otn/nt/oracle11g/win32_11gR1_database.zip

2. Extract Win32_11gr1_database. Zip installation package, as shown in Figure 1:

Figure 1

3. Click Setup.exe, select Install, enter the following figure 2

Figure 2

4. If the above step can not jump to Figure 3, then you need to close the installation software, and then shut down the computer's firewall, and then continue to install.

Figure 3

Here, select the default installation path, and the global database name is: ORCL

Database password is: INTLGJ

5. Click Next, if the situation in Figure 4, click 4, or delete all the files under the installation directory, then click Select "Yes" to enter the next step:

Figure 4

These prerequisites are not in the pipeline, keep going into the next step Figure 6, Figure 6, click Install to enter the installer phase Figure 7 6. After the installation is successful, unlock also, as shown in Figure 8 Figure 8 System administrator: SYS Supermanager General Administrator: System Manager User: Scott Intlgj 7. An

These prerequisites are not in the pipeline, proceed to the next step Figure 6

Figure 6

Click on "Install" to enter the setup stage

Figure 7

6. After the successful installation, but also to unlock, as shown in Figure 8

Figure 8

System administrator: Sys Supermanager

Normal Administrator: System Manager

User: Scott Intlgj

7. Successful Installation

Figure 9

8. After the completion of the direct selection of "Exit" can, at this time, will start an EM (Enterprise Manager) tool, but in the study basically did not use this foreground, so directly closed.

After the Oracle installation is successful, the service will actually be registered in the system, in the registration service, the following two services must be started, otherwise Oracle will not function properly.

Figure 10

Oracleoradb11g_home1tnslistener: Indicates the listening service, and if the client wants to connect to the database, the service must be turned on, and the service will work in future development programs.

ORACLESERVICEORCL: This service is Oracle's main service, naming convention: oracleservice+ database name;

The command line can then be entered into the Sqlplus Control Center for command input.

Use of basic command lines for Oracle databases

2.1. Sqlplus

Sqlplus is a tool software provided by Oracle for command execution, which is automatically registered in the system after installation.

Sqlplus has two kinds of commands:

The. Sqlplus enters the database connection as a command line, as shown in Figure 11:

Figure 11

. SQLPLUSW: Start the command-line tool as a window: However, Oracle 11g does not provide the service.

After connecting the database, we can do the query and so on:

There are more than one table in the database, each of which has a record:

Now enter the following command:

SELECT * from EMP;

Figure 12

The data shown in the original row is not displayed in one line, so the format is a bit confusing, which requires us to set the length of the display for each line:

Set the length of each row to be displayed:

Set linesize 300

Figure 13

Set the number of rows to display for each page:

Set pagesize 30

Figure 14