• Oracle Binary Options 说明


    一. Oracle Binary Options 说明

    关于OracleOptions,之前有整理过一系列文章,参考:

    Oracle 组件 系列 小结

    http://blog.csdn.net/tianlesoftware/article/details/7339998

    我们可以通过v$option视图来查看相关的信息:

    V$OPTION displaysOracle Database options and features. Typically, although not always, options mustbe separately licensed, whereas features come with the product and are enabledbased on the product that is running (Standard Edition, Enterprise Edition, andso on).

    SQL> select * from v$option;

    SQL> select comp_id,comp_name from dba_registry;

    这些组件是Oracle 的组件,在Linux/UNIX 平台下,因为系统设计的问题,应用通常不是作为一个完整的可执行文件来部署的。而是分散部署单独的对象文件,对象文件的library archives 和一些源文件,然后在安装过程中,在系统级别获取这些对象的link,并用其创建可执行文件。

    Applications forUNIX are generally not distributed as complete executables. 

           Oracle,like many application vendors who create products for UNIX, distributeindividual object files, library archives of object files, and some sourcefiles which then get "relinked" at the operating system level duringinstallation to create usable executables. This guarantees a reliable integration with functions provided by the OSsystem libraries.

           所以我们在Linux/UNIX 上安装软件就会涉及link和Relink的问题。这个也是我写这几篇文章的原因。

    二. 禁用启用Binary Options说明

    MOS 文章:

    How to Check and Enable/Disable OracleBinary Options [ID 948061.1]

    这里只说明UNIX 环境下OracleBinary Options的禁用与启用问题,关于单实例和RAC 环境下RelinkingOptions 问题会单独整理成2片Blog 来说明。

    2.1 查看Option 状态


    这篇文章涉及到的Binary Options 如下:

    RAC (Real Application Cluster)

    RAT (Real Application Testing)

    OLS (Oracle Label Security)

    DV (Database Vault)

    ASM (Automated Storage Management)

    OLAP (Oracle OLAP)

    PART (Oracle Partitioning)

    CTX (Context Management Text)

    进入目录:

    % cd $ORACLE_HOME/rdbms/lib 

    执行如下命令查看Options状态:

    % ar -t libknlopt.a | grep -c {file}

    这里的file 参数可以包含内容:

    RAC - kcsm.o 
    RAT - kecwr.o 
    OLS - kzlilbac.o 
    DV - kzvidv.o 
    ASM - kfon.o 
    OLAP - xsyeolap.o 
    PART - kkpoban.o 
    CTX - kciwcx.o

    示例:

    非AIX 环境:

    % ar -t libknlopt.a | grep -c kcsm.o 

    AIX 环境:

    % ar -X64 -t libknlopt.a | grep -c kcsm.o

    如果返回值是0 Option 就是disabled的,

    如果返回值是1option就是enabled的。

    [oracle@localhost ~]$ cd $ORACLE_HOME/rdbms/lib

    [oracle@localhost lib]$ ar -t libknlopt.a |grep -c kcsm.o

    0

    [oracle@localhost lib]$ ar -t libknlopt.a |grep -c kfon.o

    0

    [oracle@localhost lib]$ ar -t libknlopt.a |grep -c kzlilbac.o

    0

    [oracle@localhost lib]$ ar -t libknlopt.a |grep -c kciwcx.o

    1

    2.2 Options 的启用与关闭


    启用和关闭使用如下命令:

    % make -f ins_rdbms.mk {option}

    这里的Option 可以使用使用如下值:

    RAC - rac_on / rac_off 
    RAT - rat_on / rat_off 
    OLS - lbac_on / lbac_off 
    DV - dv_on / dv_off 
    ASM - asm_on / asm_off 
    OLAP - olap_on / olap_off 
    PART - part_on / part_off 
    CTX - ctx_on / ctx_off 
    DM - dm_on / dm_off

    示例:

    [oracle@localhost lib]$ ar -t libknlopt.a |grep -c kciwcx.o

    1

    关闭CTX:

    [oracle@localhost lib]$ make -fins_rdbms.mk ctx_off

    Warning: ctx is always turned on. ctx_offis disabled.

    [oracle@localhost lib]$ ar -t libknlopt.a |grep -c kciwcx.o

    1

    启用CTX:

    [oracle@localhost lib]$ make -fins_rdbms.mk ctx_on

    /usr/bin/ar cr/home/oracle_app/rdbms/lib/libknlopt.a /home/oracle_app/rdbms/lib/kciwcx.o

    [oracle@localhost lib]$ ar -t libknlopt.a |grep -c kciwcx.o

    1

    注意事项:

    The V$OPTION isunchanged and you will need to refer to other documentation to change it inorder to complete the changes to the options. This include but not limited torunning sql scripts which changes the DB Catalog.

    最后,Oracle binary 需要进行relink

    % make -f rdbms/lib/ins_rdbms.mk ioracle

    注意:

    Any databasesrunning from the $ORACLE_HOME must be shutdown before running this command

    --relink 时,$ORACLE_HOME 下的所有DB 都需要shutdown

    三.补充说明

    Starting withOracle11g Release 2 (11.2), a new "chopt" utility is available on allplatforms (including Windows).

    --Oracle 11.2 开始,Oracle 争对所有平台提供了了一个chopt工具。

    Besides workingon Windows platforms, another useful feature is the fact that on UNIX/Linuxplatforms, it neatly displays the commands that need to be executed and alsoexecutes them:

    % chopt disable rat 
    Writing to <ORACLE_HOME>/install/disable_rat.log... 
    %s_unixOSDMakePath% -f/grdbms/64bit/patchdb/app/oracle/product/p11201b/rdbms/lib/ins_rdbms.mk rat_off 
    %s_unixOSDMakePath% -f/grdbms/64bit/patchdb/app/oracle/product/p11201b/rdbms/lib/ins_rdbms.mk ioracle

    Where %s_unixOSDMakePath% = make

    注意:

    Switching on ASMshould only be done on Grid Infrastructure Homes in Oracle 11gR2. Doing it onstandard RDBMS will result in errors on startup.

    -------------------------------------------------------------------------------------------------------

    版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!

    Skype: tianlesoftware

    QQ:              tianlesoftware@gmail.com

    Email:   tianlesoftware@gmail.com

    Blog:     http://www.tianlesoftware.com

    Weibo: http://weibo.com/tianlesoftware

    Twitter: http://twitter.com/tianlesoftware

    Facebook: http://www.facebook.com/tianlesoftware

    Linkedin: http://cn.linkedin.com/in/tianlesoftware

    -------加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请----

    DBA1 群:62697716(满);   DBA2 群:62697977(满)  DBA3 群:62697850(满)  

    DBA 超级群:63306533(满);  DBA4 群:83829929   DBA5群: 142216823

    DBA6 群:158654907    DBA7 群:172855474   DBA总群:104207940

  • 相关阅读:
    selenium设置user-agent以及对于是否是浏览器内核进行反爬
    python-Redis模块常用的方法汇总
    Eight HDU-1043 (bfs)
    4 Values whose Sum is 0 (二分)
    Jmeter的优点是什么?除了轻量级,它和LoadRunner有什么本质区别
    selenuim,qtp,loadrunner,jmeter有何区别,想学个脚本语言python和测试工具应该从哪里入门呢。
    Jquery消息提示插件toastr
    排除Transformation Errors
    Group By Rollup
    Group By Grouping Sets
  • 原文地址:https://www.cnblogs.com/tianlesoftware/p/3609290.html
Copyright © 2020-2023  润新知