Oracle11gR2初体验

从Oracle11gR2 for linux正式提供下载,转眼一个星期过去了,粗略的翻了一下New feature,一直没有找到时间来安装。

今天在两台x86_64的Redhat AS 4U5上安装,建库,一切顺利。Oracle11gR2的安装过程已经基本傻瓜化到只需要next了。以前安装很重要的一步,就是要记得修改系统的一些内核参数,11gR2也把这一步直接纳入到安装界面中了,如果检查到系统还是使用的默认参数,会提示修改,并且给出了修改的shell脚本,只要root去跑一下就ok,当然,对于不同的产品环境,还是按照相应的规范去手工修改比较靠谱点。Redhat AS 4U5的os版本有点低,所以会检测出glibc/libaio等几个包的版本不符,因为是试验环境,我直接选择了忽略,安装还是很顺利的进行下去了,没有发现问题。

还没来得及去体验什么,中午吃了个饭回来,发现之前10.2.0.4上曾经碰到过的多个监听进程的问题,又出现了,faint:

test:/home/oracle>$ps -ef | grep tns
oracle    5180  2043  0 14:56 pts/4    00:00:00 grep tns
oracle   29488     1  0 11:27 ?        00:00:00 /u01/oracle/product/11.2/bin/tnslsnr LISTENER -inherit
oracle   29489 29488  0 11:27 ?        00:00:00 /u01/oracle/product/11.2/bin/tnslsnr LISTENER -inherit
oracle   29490 29489  0 11:27 ?        00:00:00 /u01/oracle/product/11.2/bin/tnslsnr LISTENER -inherit
oracle   29491 29489  0 11:27 ?        00:00:00 /u01/oracle/product/11.2/bin/tnslsnr LISTENER -inherit
SQL> select * from v$version;
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit 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 order by parameter;
Active Data Guard                                            TRUE
Advanced Compression                                         TRUE
Advanced replication                                         TRUE
Application Role                                             TRUE
Automatic Storage Management                                 FALSE
Backup Encryption                                            TRUE
Basic Compression                                            TRUE
Bit-mapped indexes                                           TRUE
Block Change Tracking                                        TRUE
Block Media Recovery                                         TRUE
Change Data Capture                                          TRUE
Coalesce Index                                               TRUE
Connection multiplexing                                      TRUE
Connection pooling                                           TRUE
DICOM                                                        TRUE
Data Mining                                                  TRUE
Database queuing                                             TRUE
Database resource manager                                    TRUE
Deferred Segment Creation                                    TRUE
Duplexed backups                                             TRUE
Enterprise User Security                                     TRUE
Export transportable tablespaces                             TRUE
Fast-Start Fault Recovery                                    TRUE
File Mapping                                                 TRUE
Fine-grained Auditing                                        TRUE
Fine-grained access control                                  TRUE
Flashback Data Archive                                       TRUE
Flashback Database                                           TRUE
Flashback Table                                              TRUE
Incremental backup and recovery                              TRUE
Instead-of triggers                                          TRUE
Java                                                         TRUE
Join index                                                   TRUE
Managed Standby                                              TRUE
Materialized view rewrite                                    TRUE
Materialized view warehouse refresh                          TRUE
OLAP                                                         TRUE
OLAP Window Functions                                        TRUE
Objects                                                      TRUE
Online Index Build                                           TRUE
Online Redefinition                                          TRUE
Oracle Data Guard                                            TRUE
Oracle Database Vault                                        FALSE
Oracle Label Security                                        FALSE
Parallel backup and recovery                                 TRUE
Parallel execution                                           TRUE
Parallel load                                                TRUE
Partitioning                                                 TRUE
Plan Stability                                               TRUE
Point-in-time tablespace recovery                            TRUE
Proxy authentication/authorization                           TRUE
Real Application Clusters                                    FALSE
Real Application Testing                                     TRUE
Result Cache                                                 TRUE
SQL Plan Management                                          TRUE
Sample Scan                                                  TRUE
SecureFiles Encryption                                       TRUE
Server Flash Cache                                           TRUE
Spatial                                                      TRUE
Streams Capture                                              TRUE
Transparent Application Failover                             TRUE
Transparent Data Encryption                                  TRUE
Trial Recovery                                               TRUE
Unused Block Compression                                     TRUE
XStream                                                      TRUE

65 rows selected.


无觅相关文章插件,快速提升流量

2条评论

  • At 2009.09.09 08:54, huc said:

    翻了一下New feather,一直没…….

    应该是New feature吧。

    • At 2009.09.09 09:29, NinGoo said:

      嗯,是写错了,谢谢指正


    (Required)
    (Required, will not be published)