在Open SUSE 10.3中安装ORACLE 11G(3)

jimmygao

4. 安装完成后检查Oracle进程是否正常启动：

hawkzy@hawkzy:/home> ps -ef | grep ora_

Oracle    9945     1  1 12:45 ?        00:00:42 ora_pmon_orcl1

Oracle    9950     1  0 12:45 ?        00:00:00 ora_vktm_orcl1

Oracle    9962     1  0 12:45 ?        00:00:00 ora_diag_orcl1

Oracle    9970     1  0 12:45 ?        00:00:00 ora_dbrm_orcl1

Oracle    9978     1  0 12:45 ?        00:00:00 ora_psp0_orcl1

Oracle    9990     1  0 12:45 ?        00:00:01 ora_dia0_orcl1

Oracle    9995     1  0 12:45 ?        00:00:06 ora_mman_orcl1

Oracle   10000     1  0 12:45 ?        00:00:01 ora_dbw0_orcl1

Oracle   10005     1  0 12:45 ?        00:00:03 ora_lgwr_orcl1

Oracle   10010     1  0 12:45 ?        00:00:03 ora_ckpt_orcl1

Oracle   10015     1  0 12:45 ?        00:00:04 ora_smon_orcl1

Oracle   10021     1  0 12:45 ?        00:00:00 ora_reco_orcl1

Oracle   10034     1  0 12:45 ?        00:00:03 ora_mmon_orcl1

Oracle   10043     1  0 12:45 ?        00:00:01 ora_mmnl_orcl1

Oracle   10048     1  0 12:45 ?        00:00:00 ora_d000_orcl1

Oracle   10053     1  0 12:45 ?        00:00:00 ora_s000_orcl1

Oracle   10170     1  0 12:45 ?        00:00:00 ora_smco_orcl1

Oracle   10178     1  0 12:45 ?        00:00:00 ora_fbda_orcl1

Oracle   10188     1  0 12:45 ?        00:00:00 ora_qmnc_orcl1

Oracle   10212     1  0 12:45 ?        00:00:00 ora_w000_orcl1

Oracle   10293     1  0 12:45 ?        00:00:00 ora_q000_orcl1

Oracle   10598     1  0 12:45 ?        00:00:01 ora_cjq0_orcl1

Oracle   19066     1  2 13:50 ?        00:00:00 ora_j000_orcl1

hawkzy   19153  9760  0 13:50 pts/1    00:00:00 grep ora_

Oracle   21153     1  0 13:05 ?        00:00:00 ora_q002_orcl1



以sqlplus工具建立一个具有dba权限的名字和密码均为lion的用户：

Oracle@hawkzy:~> sqlplus /nolog



SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 3 14:07:50 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

SQL> connect /as sysdba

Connected.

SQL> create user lion identified by "lion";

User created.

SQL> grant dba to lion with admin option;

Grant succeeded.

SQL> grant create any table to lion with admin option;

Grant succeeded.

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options



以用户名lion及密码lion登录数据库：

Oracle@hawkzy:~> sqlplus lion/lion

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 3 14:13:09 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options



关闭数据库：

Oracle@hawkzy:~> sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 3 14:15:15 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

SQL> connect /as sysdba

Connected.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options



关闭监听：

Oracle@hawkzy:~> lsnrctl stop

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 03-APR-2009 14:16:27

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

The command completed successfully



启动数据库：

Oracle@hawkzy:~> sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 3 14:21:39 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

SQL> connect /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.



Total System Global Area  401752064 bytes

Fixed Size                  1300184 bytes

Variable Size             159385896 bytes

Database Buffers          234881024 bytes

Redo Buffers                6184960 bytes

Database mounted.

Database opened.

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options



启动监听：

Oracle@hawkzy:~> lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 03-APR-2009 14:28:52

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Starting /home/Oracle/11g/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.6.0 - Production

System parameter file is /home/Oracle/11g/network/admin/listener.ora

Log messages written to /home/Oracle/orabase/diag/tnslsnr/hawkzy/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hawkzy.vmopensuse)(PORT=1521)))



Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.1.0.6.0 - Production

Start Date                03-APR-2009 14:28:52

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /home/Oracle/11g/network/admin/listener.ora

Listener Log File         /home/Oracle/orabase/diag/tnslsnr/hawkzy/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hawkzy.vmopensuse)(PORT=1521)))

The listener supports no services

The command completed successfully



以TCP网络连接方式连接到数据库：

Oracle@hawkzy:~> sqlplus lion/lion@orcl1

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 3 14:29:47 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

至此，Oracle安装已经完成。