GVKun编程网logo

Oracle 11g：取消透视多个列并包括列名称（取消透视表列总计）

34

在这里，我们将给大家分享关于Oracle11g：取消透视多个列并包括列名称的知识，让您更了解取消透视表列总计的本质，同时也会涉及到如何更有效地(PLSQL+Oracle11g64bit+32位oci.

在这里，我们将给大家分享关于Oracle 11g：取消透视多个列并包括列名称的知识，让您更了解取消透视表列总计的本质，同时也会涉及到如何更有效地(PLSQL + Oracle 11g 64bit + 32位oci.dll文件) 访问Oracle 11g、Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g、oracle 10gR2 and oracle 11gR1 and oracle 11gR2 在RHEL 5下安、Oracle 11g ACL访问控制（11g的新玩意）的内容。

本文目录一览：

Oracle 11g：取消透视多个列并包括列名称（取消透视表列总计）

Oracle 11g：取消透视多个列并包括列名称（取消透视表列总计）

我正在尝试取消数据集中的多个列。这是我的数据。

CREATE TABLE  T5 (idnum NUMBER,f1 NUMBER(10,5),f2 NUMBER(10,5),f3 NUMBER(10,5)                 ,e1 NUMBER(10,5),e2 NUMBER(10,5)                 ,h1 NUMBER(10,5),h2 NUMBER(10,5));INSERT INTO T5 (IDNUM,F1,F2,F3,E1,E2,H1,H2) VALUES (1,''10.2004'',''5.009'',''7.330'',''9.008'',''8.003'',''.99383'',''1.43243'');INSERT INTO T5 (IDNUM,F1,F2,F3,E1,E2,H1,H2VALUES (2,''4.2004'',''6.009'',''9.330'',''4.7008'',''4.60333'',''1.993'',''3.3243'');INSERT INTO T5 (IDNUM,F1,F2,F3,E1,E2,H1,H2)VALUES (3,''10.2040'',''52.6009'',''67.330'',''9.5008'',''8.003'',''.99383'',''1.43243'');INSERT INTO T5 (IDNUM,F1,F2,F3,E1,E2,H1,H2)VALUES (4,''9.20704'',''45.009'',''17.330'',''29.008'',''5.003'',''3.9583'',''1.243'');COMMIT;select * from t5;IDNUM    F1    F2     F3        E1      E2       H1     H21   10.2004 5.009   7.33    9.008   8.003   0.99383 1.432432   4.2004  6.009   9.33    4.7008  4.60333 1.993   3.32433   10.204  52.6009 67.33   9.5008  8.003   0.99383 1.432434   9.20704 45.009  17.33   29.008  5.003   3.9583  1.243

我像这样坚定不移…

select *from (select IDNUM,F1,F2,F3,E1,E2,H1,H2,      null as E3,null as H3      from T5)UnPivot((F,E,H) for sk in ((F1,E1,H1) as 1,                              (F2,E2,H2) as 2,                              (F3,E3,H3) as 3))order by IDNUM,SK;IDNUM  SK        F        E        H-----  --  -------  -------  -------    1   1  10.2004    9.008   .99383    1   2    5.009    8.003  1.43243    1   3     7.33     null     null    2   1   4.2004   4.7008    1.993    2   2    6.009  4.60333   3.3243    2   3     9.33     null     null    3   1   10.204   9.5008   .99383    3   2  52.6009    8.003  1.43243    3   3    67.33     null     null    4   1  9.20704   29.008   3.9583    4   2   45.009    5.003    1.243    4   3    17.33     null     null

但是我真正需要的是如下…

IDNUM  SK        F        E        H  F_COL_NAME-----  --  -------  -------  -------  ----------    1   1  10.2004    9.008   .99383          F1    1   2    5.009    8.003  1.43243          F2    1   3     7.33     null     null          F3    2   1   4.2004   4.7008    1.993          F1    2   2    6.009  4.60333   3.3243          F2    2   3     9.33     null     null          F3    3   1   10.204   9.5008   .99383          F1    3   2  52.6009    8.003  1.43243          F2    3   3    67.33     null     null          F3    4   1  9.20704   29.008   3.9583          F1    4   2   45.009    5.003    1.243          F2    4   3    17.33     null     null          F3

我怎样才能做到这一点？

答案1

小编典典

只是select idnum, sk, f, e, h, ''F''||SK as col_name…您需要指定所有列而不是星号。

像这样http://sqlfiddle.com/#!4/12446/21

(PLSQL + Oracle 11g 64bit + 32位oci.dll文件) 访问Oracle 11g

(PLSQL + Oracle 11g 64bit + 32位oci.dll文件) 访问Oracle 11g

(PLsql Developer + Oracle 11g 64位客户端 + 32位oci.dll文件) 访问Oracle 11g 数据库服务器的方法及说明：

PLsql Developer 连接 64位Oracle 数据库需要找到两个东东：

1、32位的 oci.dll 文件
因为PLsql Developer 为32位软件，故在访问 Oracle 11g 64位数据库时，需首先经过32位的oci.dll这个中间人再与64位oracle 数据库通信。故在PLsql Developer访问 64位oracle 数据库时，必须要能能找到 32位的 oci.dll文件位置。
2、ORACLE_HOME 目录（即 Oracle主目录）
找 ORACLE_HOME 是为了找到 tnsnames.ora .tnsnames.ora存储数据库连接信息。tnsnames.ora可通过”Net Configuration Assistant”配置，或直接从别的计算机上复制一个该文件放置到 Oracle客户端主目录\network\admin 中即可
解决方法多种多样，但要实现的目标也就上面两个。

具体操作步骤：

安装完 Oracle 64位客户端后，进行以下两步设置：
1 环境变量
新增： ORACLE_HOME,指定值为Oracle 64位客户端主目录，如 D:\app\database\product\11.2.0\client_1
使环境变量生效：注销计算机或在CMD命令中执行：C:> set ORACLE_HOME=D:\app\database\product\11.2.0\client_1

2 打开 PLsql Developer,选择“Cancel(或取消)”进入主界面。
选择 tool(工具）-> options(首选项）-> Oracle:指定以下两项
Oracle 主目录：（注：此处不设置ORACLE_HOME,环境变量中已设定）
Oci库:选择 32位oci.dll文件所在目录及文件名，如 :d:\app\oraclient\oci.dll

说明： 1、测试不在Windows 环境变量中指定ORACLE_HOME,而是直接在 PLsql Developer 中指定 “Oracle 主目录”与 “OCI库文件”,连接不成功。 2、32位 oci.dll的获取有两种方式，一是再安装一个32位Oracle 11g 客户端；二是直接从网络下载一个包含32位 oci.dll 的简易安装包。

Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g

Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g

Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g

系统环境：

操作系统： RedHat EL6

Oracle： Oracle 10g and Oracle 11g

 

手工建库相对来说很容易实现，本案例是从10g和11g，通过手工建库的方式做一个简单的对比，可以看出11g和10g之间的一个简单的差异！

VMware+Linux+Oracle 10G RAC全程详细图解

案例二：

在Oracle 11g 环境下手工建库

DB_NAME=''test1''

INSTANCE_NAME=''test1''

1、建立Instance的初始化参数文件和口令文件

[oracle@rh6 dbs]$cat inittest1.ora

db_name=''test1''

memory_target=400m //Oracle 11g增加了内存自动管理

processes = 150

audit_file_dest=''$ORACLE_BASE/admin/test1/adump''

audit_trail =''db''

db_block_size=8192

db_domain=''''

open_cursors=300

remote_login_passwordfile=''EXCLUSIVE''

undo_tablespace=''UNDOTBS1''

# You may want to ensure that control files are created on separate physical

# devices

control_files = /u01/app/oracle/oradata/test1/control01.ctl

compatible =''11.2.0''

 

[oracle@rh6 dbs]$ orapwd file=orapwtest1 password=oracle entries=3

 

2、建立数据库相关的目录

Oracle 11g增加了diagnostic directory，，默认的为$ORACLE_BASE

[oracle@rh6 dbs]$ mkdir -p $ORACLE_BASE/admin/test1/adump

[oracle@rh6 dbs]$ mkdir -p /u01/app/oracle/oradata/test1

 

3、建立建库脚本

[oracle@rh6 ~]$ cat cr_db.sql

CREATE DATABASE test1

USER SYS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

LOGFILE

GROUP 1 (''/u01/app/oracle/oradata/test1/redo01a.log'') SIZE 50M ,

GROUP 2 (''/u01/app/oracle/oradata/test1/redo02a.log'') SIZE 50M

MAXLOGFILES 10

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 200

CHARACTER SET zhs16gbk

DATAFILE ''/u01/app/oracle/oradata/test1/system01.dbf'' SIZE 325M REUSE

SYSAUX DATAFILE ''/u01/app/oracle/oradata/test1/sysaux01.dbf'' SIZE 325M REUSE

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE ''/u01/app/oracle/oradata/test1/temp01.dbf''

SIZE 100M REUSE

UNDO TABLESPACE undotbs1

DATAFILE ''/u01/app/oracle/oradata/test1/undotbs01.dbf''

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

 

4、启动Instance并建立数据库

[oracle@rh6 ~]$ export ORACLE_SID=test1

[oracle@rh6 ~]$ sqlplus ''/as sysdba''

SQL*Plus: Release 11.2.0.1.0 Production on Wed May 21 10:59:58 2014

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

Connected to an idle instance.

10:59:59 SYS@ test1>startup nomount;

ORACLE instance started.

Total System Global Area 417546240 bytes

Fixed Size 2213936 bytes

Variable Size 268437456 bytes

Database Buffers 142606336 bytes

Redo Buffers 4288512 bytes

11:00:12 SYS@ test1>@/home/oracle/cr_db

Database created.

Elapsed: 00:01:23.44

11:01:51 SYS@ test1>

 

建库告警日志：

CREATE TABLESPACE sysaux DATAFILE ''/u01/app/oracle/oradata/test1/sysaux01.dbf'' SIZE 325M REUSE

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE

Wed May 21 11:01:08 2014

Completed: CREATE TABLESPACE sysaux DATAFILE ''/u01/app/oracle/oradata/test1/sysaux01.dbf'' SIZE 325M REUSE

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE

processing ?/rdbms/admin/dplsql.bsq

processing ?/rdbms/admin/dtxnspc.bsq

CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE ''/u01/app/oracle/oradata/test1/undotbs01.dbf''

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

Wed May 21 11:01:23 2014

Successfully onlined Undo Tablespace 2.

Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE ''/u01/app/oracle/oradata/test1/undotbs01.dbf''

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE ''/u01/app/oracle/oradata/test1/temp01.dbf''

SIZE 100M REUSE

Completed: CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE ''/u01/app/oracle/oradata/test1/temp01.dbf''

SIZE 100M REUSE

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1

Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1

ALTER DATABASE DEFAULT TABLESPACE SYSTEM

Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM

processing ?/rdbms/admin/dfmap.bsq

processing ?/rdbms/admin/denv.bsq

processing ?/rdbms/admin/drac.bsq

processing ?/rdbms/admin/dsec.bsq

processing ?/rdbms/admin/doptim.bsq

processing ?/rdbms/admin/dobj.bsq

processing ?/rdbms/admin/djava.bsq

processing ?/rdbms/admin/dpart.bsq

Wed May 21 11:01:34 2014

processing ?/rdbms/admin/drep.bsq

processing ?/rdbms/admin/daw.bsq

processing ?/rdbms/admin/dsummgt.bsq

processing ?/rdbms/admin/dtools.bsq

processing ?/rdbms/admin/dexttab.bsq

processing ?/rdbms/admin/ddm.bsq

processing ?/rdbms/admin/dlmnr.bsq

processing ?/rdbms/admin/ddst.bsq

Wed May 21 11:01:43 2014

SMON: enabling tx recovery

Starting background process SMCO

Wed May 21 11:01:44 2014

SMCO started with pid=17, OS id=2816

Wed May 21 11:01:50 2014

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

Wed May 21 11:01:50 2014

QMNC started with pid=20, OS id=2826

Completed: CREATE DATABASE test1

USER SYS IDENTIFIED BY ****USER SYSTEM IDENTIFIED BY ****LOGFILE

GROUP 1 (''/u01/app/oracle/oradata/test1/redo01a.log'') SIZE 50M ,

GROUP 2 (''/u01/app/oracle/oradata/test1/redo02a.log'') SIZE 50M

MAXLOGFILES 10

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 200

CHARACTER SET zhs16gbk

DATAFILE ''/u01/app/oracle/oradata/test1/system01.dbf'' SIZE 325M REUSE

SYSAUX DATAFILE ''/u01/app/oracle/oradata/test1/sysaux01.dbf'' SIZE 325M REUSE

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE ''/u01/app/oracle/oradata/test1/temp01.dbf''

SIZE 100M REUSE

UNDO TABLESPACE undotbs1

DATAFILE ''/u01/app/oracle/oradata/test1/undotbs01.dbf''

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

 

更多详情见请继续阅读下一页的精彩内容：

10gRAC-10.2.0.4-dbca建库时配置OEM遇到BUG-p8350262

Oracle 11g R2 手动建库(create database manually)

Oracle 11g + ASM DBCA 建库问题解决心得

Linux下Oracle 10g手工建库全过程

Oracle 9i数据库手工建库过程简记

静默安装Oracle 11gR2软件并且手动建库

linux

oracle 10gR2 and oracle 11gR1 and oracle 11gR2 在RHEL 5下安

oracle 10gR2 and oracle 11gR1 and oracle 11gR2 在RHEL 5下安

Requirements For Installing Oracle 10gR2 On RHEL_OEL 5 (x86) [ID 419646.1].htm Requirements For Installing Oracle 10gR2 On RHEL 5_OEL 5 (x86_64) [ID 421308.1].htm Requirements for Installing Oracle 10gR2 RDBMS on RHEL 5 on Linux Itanium (i

 requirements for installing oracle 10gr2 on rhel_oel 5 (x86) [id 419646.1].htm

 Requirements For Installing Oracle 10gR2 On RHEL 5_OEL 5 (x86_64) [ID 421308.1].htm
 Requirements for Installing Oracle 10gR2 RDBMS on RHEL 5 on Linux Itanium (ia64) [ID 748378.1].htm
 Requirements for Installing Oracle 10gR2 RDBMS on RHEL 5 on zLinux (s390x) [ID 741646.1].htm
 Requirements for Installing Oracle 11gR1 32bit RDBMS on RHEL 5 & OEL 5 [ID 438765.1].htm
 Requirements for Installing Oracle 11gR1 RDBMS on RHEL 5 on AMD64_EM64T [ID 438766.1].htm
 Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 5 on 32-bit x86 [ID 880936.1].htm
 Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 5 on AMD64_EM64T [ID 880989.1].htm

 

Installing Oracle 10gR2 On RHEL_OEL 5 (x86)时的rpm包要求：

binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.125-3.el5
elfutils-libelf-devel-0.125
gcc-4.1.1-52
gcc-c++-4.1.1-52
glibc-2.5-12
glibc-common-2.5-12
glibc-devel-2.5-12
glibc-headers-2.5-12
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.1-52
libstdc++-4.1.1
libstdc++-devel-4.1.1-52.e15
make-3.81-1.1
sysstat-7.0.0
unixODBC-2.2.11
unixODBC-devel-2.2.11

 

Note:

As per documentation bug 7680459 , the package libXp-1.0.0-8 is also required to invoke OUI successfully.

 

所以，libXp-1.0.0-8  包要安装 ，否则在运行./runInstaller时，会报错：

Exception :java.lang.UnsatisfiedLinkError:/u01/product/oracle/jdk/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory

此报错会导致图形界面出不来，导致安装oracle软件失败。

Installing Oracle10gR2 On RHEL 5_OEL 5 (x86_64)时的rpm包要求：


binutils-2.17.50.0.6-2 (x86_64)
compat-db-4.2.52-5.1 (x86_64)
compat-libstdc++-296-2.96-138 (i386)
compat-libstdc++-33-3.2.3-61(x86_64)
compat-libstdc++-33-3.2.3-61 (i386)
control-center-2.16.0-14 (x86_64)
gcc-4.1.1-52 (x86_64)
gcc-c++-4.1.1-52 (x86_64)
glibc-2.5-12 (x86_64)
glibc-2.5-12 (i686)
glibc-common-2.5-12 (x86_64)
glibc-devel-2.5-12 (x86_64)
glibc-devel-2.5-12 (i386)
glibc-headers-2.5-12 (x86_64)
ksh-20060214-1.4 (x86_64)
libaio-0.3.106-3.2 (x86_64)
libgcc-4.1.1-52 (i386)
libgcc-4.1.1-52 (x86_64)
libgnome-2.16.0-6 (x86_64)
libgnomeui-2.16.0-5 (x86_64)
libgomp-4.1.1-52 (x86_64)
libstdc++-4.1.1-52 (x86_64)
libstdc++-devel-4.1.1-52 (x86_64)
libXp-1.0.0-8 (i386)
make-3.81-1.1 (x86_64)
sysstat-7.0.0-3 (x86_64)

 

 

Installing Oracle 10gR2 RDBMS on RHEL 5 on Linux Itanium (ia64) 时的rpm包要求：

 

II. Software:
============
   1. Red Hat Enterprise Linux Server 5.x, which is Kernel 2.6.18-8.el5 or newer.

   2. Required OS Components (per Release Notes, and Install Guide)
       a.) This list is based upon Itanium (ia64) RHEL Server 5.0. When a newer "update" level is used, the RPM release numbers (such as 2.6.18-8.el5) may be slightly higher (such as 2.6.18-53.el5 or 2.6.18-92.el5). This is fine so long as you are still using RHEL Server 5 RPMs for Itanium (ia64).
       b.) binutils-2.17.50.0.6-2.el5.ia64.rpm
       c.) compat-libstdc++-33-3.2.3-61.ia64.rpm
            aa.) The RHEL 5.0 ia64 and 5.1 ia64 media mistakenly named this same RPM as:
                   compat-libstdc33-3.2.3-61.ia64.rpm            d.) elfutils-libelf-0.125-3.el5.ia64.rpm
       e.) elfutils-libelf-devel-0.125-3.el5.ia64.rpm 
       f.)  gcc-4.1.1-52.el5.ia64.rpm
       g.) gcc-c++-4.1.2-42.el5.ia64.rpm
            aa.) The RHEL 5.0 ia64 and 5.1 ia64 media mistakenly named this same RPM as: 
                   gcc-c4.1.1-52.el5.ia64.rpm            h.) glibc-2.5-12.ia64.rpm
       i.) glibc-common-2.5-12.ia64.rpm
       j.) glibc-devel-2.5-12.ia64.rpm
       k.) glibc-headers-2.5-12.ia64.rpm
       l.) libaio-0.3.106-3.2.ia64.rpm
       m.) libaio-devel-0.3.106-3.2.ia64.rpm
       n.) libgcc-4.1.1-52.el5.ia64.rpm
       o.) libstdc++-4.1.2-42.el5.ia64.rpm
            aa.) The RHEL 5.0 ia64 and 5.1 ia64 media mistakenly named this same RPM as:
                   libstdc4.1.1-52.el5.ia64.rpm        p.) libstdc++-devel-4.1.2-42.el5.ia64.rpm
            aa.) The RHEL 5.0 ia64 and 5.1 ia64 media mistakenly named this same RPM as:
                   libstdcdevel-4.1.1-52.el5.ia64.rpm        q.) make-3.81-1.1.ia64.rpm 
       r.) sysstat-7.0.0-3.el5.ia64.rpm
       s.) unixODBC-2.2.11-7.1.ia64.rpm
       t.) unixODBC-devel-2.2.11-7.1.ia64.rpm 

   In several cases, multiple architectures of RPMs are provided on the RHEL media. You only need the "ia64" architectures. For example, you do not need "glibc-2.5-12.i686.rpm". You only need "glibc-2.5-12.ia64.rpm". 

   3. Additional Required OS Components (per the runInstaller OUI)
       a.) intentionally blank

   4. Additional Required OS Components (per this NOTE)
       a.) Please do not rush, skip, or minimize this critical step.   This list is based upon a "default-RPMs" installation of Itanium (ia64) RHEL Server 5. Additional RPMs (beyond anything known to Oracle) may be needed if a "less-than-default-RPMs" installation of Itanium (ia64) RHEL Server 5 is performed. For more information, please refer to Note 376183.1 , "Defining a "default RPMs" installation of the RHEL OS"
       b.) Other required RPMs (such as libXp-1.0.0-8.ia64.rpm) will already be present from this "default-RPMs" installation.

   5. Oracle Global Customer Support has noticed a recent trend with install problems that originates from installing too many RPMs. For example:
       a.) installing your own JDK version (prior to beginning the Oracle Software “runInstaller”) is not needed on Linux, and is not recommended on Linux. A pre-existing JDK often interferes with the correct JDK that the Linux Oracle Software “runInstaller” will place and use.
       b.) installing more than the required version of the gcc / g++ RPMs often leads to accidentally using (aka enabling or activating) the incorrect one. If you have multiple RDBMS versions installed on the same Linux machine, then you will likely have to manage multiple versions of gcc /g++ . For more information, please see Note 444084.1 , "Multiple gcc / g++ Versions in Linux"

   6. All of the RPMs in div II. are on the Red Hat Enterprise Linux 5 Itanium (ia64) distribution media.     7. Command syntax to differentiate between installed i686 RPMs and installed ia64 RPMs is presented in the "Additional Notes" div below.

 

 

Installing Oracle 10gR2 RDBMS on RHEL 5 on zLinux (s390x)

II. Software:
=========
    A. Red Hat Enterprise Linux Server 5 (Update 2 or newer) is required, which is Kernel 2.6.18-92.el5 or newer.
         1.  This NOTE is based upon x86_64 RHEL Server 5 "update 2". When a newer "update" level is used, the RPM release numbers (such as 2.6.18-92) may be slightly higher (such as 2.6.18-97). This is fine so long as you are still using RHEL Server 5 RPMs.

    B. Required OS Components (per Release Notes, and Quick Install Guide) 
         1.  intentionally blank

    C. Additional Required OS Components (per this NOTE) 
         1. Please do not rush, skip, or minimize this critical step.   This list is based upon a "default-RPMs" installation of RHEL Server 5. Additional RPMs (beyond anything known to Oracle) may be needed if a "less-than-default-RPMs" installation of RHEL Server 5 is performed. For more information, please refer to Note 376183.1 , "Defining a "default RPMs" installation of the RHEL OS" 
         2. glibc-devel-2.5-24.s390.rpm             3. libaio-0.3.106-3.2.s390x.rpm             4. sysstat-7.0.2-1.el5.s390x.rpm
         5. java-1.4.2-gcj-compat-src-1.4.2.0-40jpp.115.s390x.rpm
         6. compat-gcc-34-c++-3.4.6-4.s390x.rpm
         7. compat-gcc-34-3.4.6-4.s390x.rpm
         8. compat-libstdc++-33-3.2.3-61.s390x.rpm
         9. compat-libstdc++-295-2.95.3-85.s390x.rpm

    D.  Optional X Software Components (per this NOTE) 
         1. mesa-libGLU-devel-6.5.1-7.5.el5.s390x.rpm
         2. mesa-lib-GLw-devel-6.5.1-7.5.el5.s390x.rpm
         3. openmotif-devel-2.3.0-0.5.el5.s390x.rpm

    E.  Oracle Global Customer Support has noticed a recent trend with install problems that originates from installing too many RPMs. For example: 
         1. installing your own JDK version (prior to beginning the Oracle Software “runInstaller”) is not needed on Linux, and is not recommended on Linux. A pre-existing JDK often interferes with the correct JDK that the Linux Oracle Software “runInstaller” will place and use. 
         2. installing more than the required version of the gcc / g++ RPMs often leads to accidentally using (aka enabling or activating) the incorrect one. If you have multiple RDBMS versions installed on the same Linux machine, then you will likely have to manage multiple versions of gcc /g++ . For more information, please see Note 444084.1 , "Multiple gcc / g++ Versions in Linux"

    F.  The s390x (64-bit) packages are on the RHEL 5 zLinux distribution media. The s390 (31-bit) packages are also on the RHEL 5 zLinux distribution media. 

    G.  Command syntax to differentiate between installed s390 (31-bit) RPMs and installed s390x (64-bit) RPMs is presented in the "Additional Notes" div below. 

    H.  Note: s390 (31-bit) packages might require the --force option during installation if the 64-bit version of the same package is already installed. For example, "rpm -ivh --force glibc-devel-2.3.4-2.13.s390.rpm" may be required.

 

 

 

以下的安装需求请见各自的metalink文章：

 Requirements for Installing Oracle 11gR1 32bit RDBMS on RHEL 5 & OEL 5

 Requirements for Installing Oracle 11gR1 RDBMS on RHEL 5 on AMD64_EM64T 
 Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 5 on 32-bit x86 
 Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 5 on AMD64_EM64T
 Requirements For Installing Oracle10gR2 On RHEL 5_OEL 5 (x86_64)

 

 

 

 

Oracle 11g ACL访问控制（11g的新玩意）

Oracle 11g ACL访问控制（11g的新玩意）

写了一个存储过程用于自动发邮件，运行时报：ORA-24247 网络访问被访问控制列表 (ACL) 拒绝 

上网收集了一些资料，原来是Oracle 11g加入了一个访问控制列表（ACL）用来控制网络访问，在访问外部网络地址前需要进行配置。

弄了个脚本添加了一个访问邮箱服务器的权限

set linesize 8000
set serveroutput on
set sqlblanklines on

exec  DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl => ''acl_e900_email_server.xml'',
    description => ''User JDE send Email by 11.0.0.1'', 
    principal => ''HAHAHA'', 
    is_grant => TRUE, 
    privilege => ''connect'', 
    start_date => SYSTIMESTAMP , 
    end_date => NULL); 
COMMIT;

exec  DBMS_NETWORK_ACL_ADMIN.assign_acl ( 
    acl => ''acl_e900_email_server.xml'', 
    host => ''11.0.0.1'', 
    lower_port => 25, 
    upper_port => NULL);
COMMIT;

 

以下是一份完整比较详尽的配置脚本：

------------------------------------
-- 创建ACL：
------------------------------------

BEGIN
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
	ACL  		=> ''/sys/acls/BRDG_BMS_TO_OA.xml'',  --命名
    DESCRIPTION	=> ''ACL list'',   --描述
    PRINCIPAL   => ''CHD_ACT_FOR_BUG_PROJ'',   --要赋权限的用户
    IS_GRANT    => TRUE,   --true表示赋权，false表示取消赋权
    PRIVILEGE   => ''connect''
  );
  DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
	ACL       => ''/sys/acls/BRDG_BMS_TO_OA.xml'',
    PRINCIPAL => ''CHD_ACT_FOR_BUG_PROJ'',
    IS_GRANT  => TRUE,
    PRIVILEGE => ''resolve''
  );
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
	ACL  		=> ''/sys/acls/BRDG_BMS_TO_OA.xml'',
    HOST 		=>''*'',   --主机名，可以指定主机名，也可以使用*做为通配
    lower_port=> 1,    --端口配置视情况而定，若需要精确控制可限定主机端口范围
    upper_port=> 9999
  );
  commit；
END;

------------------------------------
-- 删除ACL：（与assign相对应）
------------------------------------
-- 删除acl这个列表文件，使用它的用户也就取消了对应的权限
begin
  dbms_network_acl_admin.drop_acl(
    ''/sys/acls/BRDG_BMS_TO_OA.xml''
  );
  commit；
end;

　　

 

今天关于Oracle 11g：取消透视多个列并包括列名称和取消透视表列总计的介绍到此结束，谢谢您的阅读，有关(PLSQL + Oracle 11g 64bit + 32位oci.dll文件) 访问Oracle 11g、Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g、oracle 10gR2 and oracle 11gR1 and oracle 11gR2 在RHEL 5下安、Oracle 11g ACL访问控制（11g的新玩意）等更多相关知识的信息可以在本站进行查询。

本文标签：

上一篇何时在MySQL上使用STRAIGHT_JOIN

下一篇更新查询if语句是否适用于Oracle（查询并更新语句oracle）

相关文章