51Testing软件测试论坛

标题: 在Open SUSE 10.3中安装ORACLE 11G(3) [打印本页]

作者: jimmygao 时间: 2011-7-6 07:57
标题: 在Open SUSE 10.3中安装ORACLE 11G(3)
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安装已经完成。

欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)