Oracle Database Installation diagram and basic command line usage

Oracle Database Installation diagram and basic command line usage

1. Oracle Database Installation

1. Download the oracle database software

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

2. decompress the win32_11gR1_database.Zip installation package, as shown in 1:

Figure 1

3. Click setup.exe, select install, and enter 2

Figure 2

4. If you cannot jump to Figure 3 in the preceding step, you must first disable the software installation, then disable the firewall of your computer, and then continue the installation.

Figure 3

Select the default installation path. The Global Database Name Is orcl.

Database Password: intlgj

5. Click Next. If figure 4 appears, click 4, or delete all the files in the installation directory, and then click "yes" to go to the next step:

Figure 4

Do not worry about these prerequisites. continue to the next step. Figure 6. Click "Install" to go to the installation stage. Figure 6. after the installation is successful, unlock it. Figure 8 system Administrator: sys supermanager common administrator: system manager User: scott intlgj 7. security

Skip these prerequisites and proceed to Step 6.

Figure 6

Click "Install" to enter the installation stage.

Figure 7

6. Unlock after the installation is successful.

Figure 8

System Administrator: sys supermanager

Common administrator: system manager

User: scott intlgj

7. Installation successful

Figure 9

8. After the execution is complete, select "exit". At this time, an EM (Enterprise Manager) tool will be started. However, this front-end tool is not used in learning, so you can simply close it.

After the installation is successful, Oracle will actually register the service in the system. In the registration service, the following two services must be started; otherwise, Oracle cannot run normally.

Figure 10

OracleOraDb11g_home1TNSListener: Listener service. If the client wants to connect to the database, this service must be enabled and will take effect in future development programs.

OracleServiceORCL: this service is the primary service of Oracle. The naming rule is OracleService + database name;

Then, you can enter the SQLPlus control center through the command line to input commands.

Ii. Use of basic Oracle database command lines

2.1. SQLPlus

SQLPlus is a command execution tool software provided by Oracle. After installation, it is automatically registered in the system.

SQLplus has two commands:

. Sqlplus enters the database connection through the command line, 11:

Figure 11

. Sqlplusw: Start the command line tool in a window: But Oracle 11G does not provide this service.

After connecting to the database, we can perform query and other operations:

Multiple tables exist in the database, and each table has records:

Enter the following command:

SELECT * from emp;

Figure 12

The data displayed in the original row is not displayed by one row, so the display format is a bit messy. Therefore, we need to set the length of each row:

Set the length of each row to display:

Set linesize 300

Figure 13

Set the number of lines displayed on each page:

Set pagesize 30

Figure 14