eygle.com   eygle.com
eygle.com  
 

« 来自Oracle公司的职位机会:Principal Consultant | Blog首页 | 恩墨科技为某企业SAP数据库提供紧急援助服务 »

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

作者:eygle |【转载时请以超链接形式标明文章和作者信息及本声明
链接:
在上个月举办的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的小企鹅是非常可爱的:

OEL1.JPG



OEL 5,小企鹅站岗看门:


OEL2.JPG

数据库的安装:

11gR2.JPG

最后的安装成果:

[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------



历史上的今天...
      >> 2007-09-05文章:
      >> 2005-09-05文章:
             半夜三更 磁盘又坏
------
这篇 【Oracle 11gR2 安装初体验 - OEL + Oracle】来自 eygle.com | CSDN网摘| del.icio.us|Google订阅 | 鲜果订阅 | 抓虾订阅

By eygle on 2009-09-05 10:04 | Comments (22) | Posted to OraNews | Oracle10g/11g | Edit |

相关文章 随机文章
  • 11gR2新特性之- 并行DBMS_PARALLEL_EXECUTE
  • Oracle Database 11gR2的升级路径与升级思考
  • 11gR2新特性之二 - Flash Cache 的SSD支持
  • 11gR2新特性之一-列式压缩(Columnar Compression)
  • Oracle 11g R2 For Linux发布 - 2009-08-31
  • 如何更改控制文件自动备份的路径
    使用dbms_rectifier_diff解决高级复制中的数据冲突问题
    关于数据文件头信息记录
    DBA警世录:备份重于一切
    完成网站迁移
    搜索本站:

    留言 (22)

    直接安装在主机上?

    Posted by: l1t at September 5, 2009 11:37 AM

    直接安装在主机上?

    Posted by: l1t at September 5, 2009 11:37 AM

    4. 下载了2部电影,计划安装时候看,大约4G

    这个 安装没有那么慢吧

    现在单实例的ASM也要装Grid Infrastructure
    大师Grid Infrastructure搞定了不

    Posted by: Himmelskorper at September 5, 2009 11:44 AM

    我还打算用我的主机装,看到那6G内存,我只能选择沉默,我的才512M内存

    Posted by: god at September 5, 2009 5:15 PM

    Eygle,那个Oracle Enterprise Linux 怎么下载啊,能不能给个下载链接。
    Eygle玩VM的时候 应该是在VM Player里面玩 的吧

    Posted by: AdamHuan at September 5, 2009 7:02 PM

    Eygle,那个Oracle Enterprise Linux 怎么下载啊,能不能给个下载链接。
    Eygle玩VM的时候 应该是在VM Player里面玩 的吧

    Posted by: AdamHuan at September 5, 2009 7:03 PM

    OEL,就是Oracle OEM了Redhat AS Linux的版本,参考:

    http://www.eygle.com/archives/2008/12/oel_linux_oracle.html

    Posted by: eygle at September 5, 2009 9:03 PM

    OEL需要到这里下载,http://edelivery.oracle.com/linux

    Posted by: sam_yu_china at September 5, 2009 9:05 PM

    http://edelivery.oracle.com/linux

    Posted by: sam at September 5, 2009 9:07 PM

    Linux还是那么受欢迎啊
    Solaris以后怎么办。。。

    Posted by: Himmelskorper at September 5, 2009 9:42 PM

    en 谢谢 Eygle 正在看你的http://www.eygle.com/archives/2008/12/oel_linux_oracle.html

    Posted by: AdamHuan at September 6, 2009 8:13 AM

    en 谢谢 Eygle 正在看你的http://www.eygle.com/archives/2008/12/oel_linux_oracle.html

    Posted by: AdamHuan at September 6, 2009 8:13 AM

    被大师忽悠了
    装Grid Infrastructure时看片子
    片子竟然会卡。。。

    Posted by: Himmelskorper at September 6, 2009 9:50 AM

    呵呵,小企鹅挺有意思,还穿盔甲的。

    Posted by: 五“宅”一生 at September 6, 2009 9:43 PM

    R2的安装界面和MS SQL 2008惊人的相似。。。相互借鉴肯定是有的

    Posted by: Bo at September 8, 2009 10:17 AM

    Eygle老师,我等新手一直希望有一个Linux+Oracle的安装全程讲解,可否将您安装OEL+Oracle的过程以PDF格式共享?????


    corrs@live.cn

    Posted by: corrs at September 8, 2009 3:51 PM

    这些安装其实不复杂,自己花点时间都可以装上的。

    网上也有别人整理好的教程,我回头整理一下给出链接。

    Posted by: eygle Author Profile Page at September 10, 2009 10:11 AM

    可参考这个网站:http://www.puschitz.com/

    Posted by: banping at September 10, 2009 10:17 AM

    R2的安装界面不错,赞一个

    ESXi3.5下分配1CPU 2G内存 3个8GB硬盘 Oracle Enterprise Linux5.4 正在安装,速度还可以

    Oracle收购了SUN,Linux or Solaris 这是个问题

    Posted by: jwc at October 18, 2009 8:44 AM

    您好,我也是用的linux5装oracle11g R2,但是,总到最后执行到95%时运行netca出错,想问下,你在网络设置,JDK设置方面都做了了些什么准备性的设置了吗?
    我的E-mail:51170526@163.com
    希望能够得到您的帮助,谢谢。

    Posted by: piaoxue at October 25, 2009 6:45 PM

    netca出错你可以忽略,数据库软件安装好了就Ok了,运行dbca建库。

    Posted by: eygle Author Profile Page at October 26, 2009 12:50 PM

    你小子太狠了,还有7/8i的环境!

    Posted by: thomas zhang at October 27, 2009 12:15 PM

    发表留言:



    Remember Me?
    (输入验证码后方可评论,谢谢支持)



    CopyRight © 2004~2010 eygle.com, All rights reserved.