eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

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

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

在上个月举办的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文章:
           半夜三更 磁盘又坏

无觅

By eygle on 2009-09-05 10:04 | Comments (22) | OraNews | Oracle12c/11g | 2389 |

22 Comments

直接安装在主机上?

直接安装在主机上?

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

这个 安装没有那么慢吧

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

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

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

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

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

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

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

http://edelivery.oracle.com/linux

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

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

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

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

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

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

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


corrs@live.cn

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

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

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

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

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

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


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com