浮雲雅築: [研究] Oracle XE 11g R2 安裝 (CentOS 6.5 x64)

[研究] Oracle Database Express Edition 11g Release 2 for Linux x64 安裝 (CentOS 6.5 x64)

2013-12-25

Oracle Database Express Edition 11g 給 MS-Windows 的版本只有 x86 版，64 bits 版只提供給 Linux，現在來安裝看看 (很好安裝)。

安裝

手動下載 oracle-xe-11.2.0-1.0.x86_64.rpm.zip

[root@localhost ~]# unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
Archive: oracle-xe-11.2.0-1.0.x86_64.rpm.zip
creating: Disk1/
creating: Disk1/upgrade/
inflating: Disk1/upgrade/gen_inst.sql
creating: Disk1/response/
inflating: Disk1/response/xe.rsp
inflating: Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm

[root@localhost ~]# rpm -ivh Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm
Preparing... ########################################### [100%]
1:oracle-xe ########################################### [100%]
Executing post-install steps...
You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.

[root@localhost ~]# /etc/init.d/oracle-xe configure

Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express
Edition. The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts. Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Password can't be null. Enter password:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:

Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
[root@localhost ~]#

[root@localhost ~]# service oracle-xe status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 25-DEC-2013 08:51:16

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 25-DEC-2013 08:48:28
Uptime 0 days 0 hr. 2 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
[root@localhost ~]#

[root@localhost ~]# ps aux | grep oracle
oracle 2650 0.4 1.3 213436 13488 ? Ssl 08:48 0:00 /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr LISTENER -inherit
oracle 2958 0.0 1.7 622872 17276 ? Ss 08:50 0:00 xe_pmon_XE
oracle 2960 0.0 1.4 620596 14364 ? Ss 08:50 0:00 xe_psp0_XE
oracle 2962 0.0 1.4 620596 14216 ? Ss 08:50 0:00 xe_vktm_XE
oracle 2966 0.0 1.4 620596 14360 ? Ss 08:50 0:00 xe_gen0_XE
oracle 2968 0.0 1.4 620596 14184 ? Ss 08:50 0:00 xe_diag_XE
oracle 2970 0.0 2.1 621140 22108 ? Ss 08:50 0:00 xe_dbrm_XE
oracle 2972 0.0 1.6 621108 16676 ? Ss 08:50 0:00 xe_dia0_XE
oracle 2974 0.1 4.1 620596 41652 ? Ss 08:50 0:00 xe_mman_XE
oracle 2976 0.0 2.2 627120 22640 ? Ss 08:50 0:00 xe_dbw0_XE
oracle 2978 0.0 1.9 636148 20168 ? Ss 08:50 0:00 xe_lgwr_XE
oracle 2980 0.0 1.6 621108 16924 ? Ss 08:50 0:00 xe_ckpt_XE
oracle 2982 0.0 3.2 621160 32464 ? Ss 08:50 0:00 xe_smon_XE
oracle 2984 0.0 2.3 622148 23556 ? Ss 08:50 0:00 xe_reco_XE
oracle 2986 0.3 6.2 626596 62784 ? Ss 08:50 0:00 xe_mmon_XE
oracle 2988 0.0 1.7 620596 17724 ? Ss 08:50 0:00 xe_mmnl_XE
oracle 2990 0.0 1.4 622628 14276 ? Ss 08:50 0:00 xe_d000_XE
oracle 2992 0.0 1.3 621792 13312 ? Ss 08:50 0:00 xe_s000_XE
oracle 2994 0.0 1.3 621792 13312 ? Ss 08:50 0:00 xe_s001_XE
oracle 2996 0.0 1.3 621792 13312 ? Ss 08:50 0:00 xe_s002_XE
oracle 2998 0.0 1.3 621792 13308 ? Ss 08:50 0:00 xe_s003_XE
oracle 3038 0.3 1.4 620596 14584 ? Ss 08:50 0:00 xe_vkrm_XE
oracle 3040 0.0 2.3 622144 24040 ? Ss 08:50 0:00 xe_qmnc_XE
oracle 3054 0.1 4.3 627328 44408 ? Ss 08:50 0:00 xe_cjq0_XE
oracle 3084 0.0 3.5 622208 35812 ? Ss 08:50 0:00 xe_q000_XE
oracle 3086 0.0 1.7 620596 17308 ? Ss 08:50 0:00 xe_q001_XE
root 3099 0.0 0.0 103248 872 pts/1 S+ 08:51 0:00 grep oracle
[root@localhost ~]#