Oracle binary options description

 

1. Oracle binary options description

 

For more information about oracleoptions, see:

Summary of Oracle component series

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

 

We can view the related information through the V $ option view:

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;

 

These components are Oracle components. On the Linux/Unix platform, applications are generally not deployed as a complete executable file due to system design issues. Instead, separate object files are deployed separately. The Library archives and some source files of the object files are obtained at the system level during the installation process, and the links of these objects are used to create executable files.

 

Applications forunix are generally not distributed as complete executables.

Oracle, like distributed 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.

 

Therefore, installing software on Linux/Unix involves link and relink. This is why I wrote these articles.

 

 

Ii. Disable enabling binary options

Mos article:

How to check and enable/disable oraclebinary options [ID 948061.1]

 

This section only describes how to disable and enable oraclebinary options in Unix. relinkingoptions in a single instance or RAC environment is separately divided into two blogs.

 

2.1 view option status

The binary options involved in this article are as follows:

RAC (real application cluster)

Rat (real application testing)

OLS (Oracle Label Security)

DV (Database Vault)

ASM (Automatic Storage Management)

OLAP (Oracle OLAP)

Part (Oracle partitioning)

CTX (context management text)

 

 

Enter the directory:

% Cd $ ORACLE_HOME/rdbms/lib

 

Run the following command to view the options status:

% Ar-T libknlopt. A | grep-c {file}

 

The file parameter can contain the following content:

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

 

Example:

 

Non-Aix environment:

% Ar-T libknlopt. A | grep-C kcsm. o

AIX environment:

% Ar-x64-T libknlopt. A | grep-C kcsm. o

 

If the returned value is 0, option is disabled,

If the returned value is 1, option is 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 enable and disable options

Run the following command to enable or disable SAS:

% Make-F ins_rdbms.mk {Option}

 

The options here can use the following values:

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

 

Example:

[Oracle @ localhost lib] $ ar-T libknlopt. A | grep-C kciwcx. o

1

 

Disable 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

 

Enable 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

 

Note:

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.

 

Finally, Oracle binary requires relink:

% Make-F rdbms/lib/ins_rdbms.mk ioracle

 

Note:

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

-- During relink, shutdown is required for all DB under $ ORACLE_HOME.

 

Iii. Additional instructions

 

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

-- Since Oracle 11.2, Oracle has provided a chopt tool for all platforms.

 

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

 

 

Note:

Switching on asmshocould only be done on grid infrastructure homes in Oracle 11gr2. Doing it onstandard RDBMS will result in errors on startup.

 

 

 

 

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Skype: tianlesoftware

QQ: tianlesoftware@gmail.com

Email: tianlesoftware@gmail.com

Blog: http://www.tianlesoftware.com

WEAVER: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

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

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

 

 

------- Add a group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, reject the application ----

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Dba6 group: 158654907 dba7 group: 172855474 DBA group: 104207940