Oracle 11gR2 安装初体验 - OEL + Oracle

原创 eygle 2009-09-04

576

在上个月举办的2009系统架构师大会上，有位朋友问我，他配置了一台机器，2CPU，6G内存，打算用来装Oracle测试学习，够不够。

我当时告诉他：我用的机器，是CPU Celeron的处理器，1G内存，还分去128M显存，但是我装了Oracle 7/8i/9i/10g/11g，还能跑。

在Oracle 11gr2发布之后，我开始着手搭建一个测试环境，累积下载了近10G的必要装备：
1. Oracle 11gR2 压缩包，大约2G左右
2. Oracle的 Oracle Enterprise Linux，5张光盘，大约4G左右
3. 下载了一个Vmvare Server，大约 500M
4. 下载了2部电影，计划安装时候看，大约4G

就这样，开始了安装历程，折腾了2天，终于成功的把操作系统和数据库都安装上了，OEL和数据库配合得非常好，在数据库自检的时候，有些参数推荐修改，一律被我忽略，还是顺利安装成功。

OEL的小企鹅是非常可爱的：

OEL 5,小企鹅站岗看门：

数据库的安装：

最后的安装成果：

[oracle@oracle ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 5 05:16:18 2009

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

支持的特性选件列表,看看有哪些新特性是新增加的：

SQL> select * from v$option;

PARAMETER                                          VALUE
-------------------------------------------------- ------------------------------
Partitioning                                       TRUE
Objects                                            TRUE
Real Application Clusters                          FALSE
Advanced replication                               TRUE
Bit-mapped indexes                                 TRUE
Connection multiplexing                            TRUE
Connection pooling                                 TRUE
Database queuing                                   TRUE
Incremental backup and recovery                    TRUE
Instead-of triggers                                TRUE
Parallel backup and recovery                       TRUE

PARAMETER                                          VALUE
-------------------------------------------------- ------------------------------
Parallel execution                                 TRUE
Parallel load                                      TRUE
Point-in-time tablespace recovery                  TRUE
Fine-grained access control                        TRUE
Proxy authentication/authorization                 TRUE
Change Data Capture                                TRUE
Plan Stability                                     TRUE
Online Index Build                                 TRUE
Coalesce Index                                     TRUE
Managed Standby                                    TRUE
Materialized view rewrite                          TRUE

PARAMETER                                          VALUE
-------------------------------------------------- ------------------------------
Materialized view warehouse refresh                TRUE
Database resource manager                          TRUE
Spatial                                            TRUE
Automatic Storage Management                       FALSE
Export transportable tablespaces                   TRUE
Transparent Application Failover                   TRUE
Fast-Start Fault Recovery                          TRUE
Sample Scan                                        TRUE
Duplexed backups                                   TRUE
Java                                               TRUE
OLAP Window Functions                              TRUE

PARAMETER                                          VALUE
-------------------------------------------------- ------------------------------
Block Media Recovery                               TRUE
Fine-grained Auditing                              TRUE
Application Role                                   TRUE
Enterprise User Security                           TRUE
Oracle Data Guard                                  TRUE
Oracle Label Security                              FALSE
OLAP                                               TRUE
Basic Compression                                  TRUE
Join index                                         TRUE
Trial Recovery                                     TRUE
Data Mining                                        TRUE

PARAMETER                                          VALUE
-------------------------------------------------- ------------------------------
Online Redefinition                                TRUE
Streams Capture                                    TRUE
File Mapping                                       TRUE
Block Change Tracking                              TRUE
Flashback Table                                    TRUE
Flashback Database                                 TRUE
Transparent Data Encryption                        TRUE
Backup Encryption                                  TRUE
Unused Block Compression                           TRUE
Oracle Database Vault                              FALSE
Result Cache                                       TRUE

PARAMETER                                          VALUE
-------------------------------------------------- ------------------------------
SQL Plan Management                                TRUE
SecureFiles Encryption                             TRUE
Real Application Testing                           TRUE
Flashback Data Archive                             TRUE
DICOM                                              TRUE
Active Data Guard                                  TRUE
Server Flash Cache                                 TRUE
Advanced Compression                               TRUE
XStream                                            TRUE
Deferred Segment Creation                          TRUE

65 rows selected.

----to be continued------

oracle

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

Oracle 11gR2 安装初体验 - OEL + Oracle

评论

相关阅读