Database Reference
In-Depth Information
object module in a static library. For someone who knows how to use the commands
ar
and
make
, it is fairly easy to manually apply an interim patch. This is useful when OPatch fails for
whatever reason. For example, newer releases of OPatch (starting in versions 1.0.0.0.54 and
10.2.0.x) are able to verify that a new object module (extension
.o
, e.g.,
dbsdrv.o
) was correctly
inserted into a static library (extension
.a
, e.g.,
libserver10.a
) by extracting the object module
and comparing it to the one shipped with the patch. This very reasonable test failed on Solaris
64-bit ORACLE installations, since Solaris 10 pads object files with newline characters (use
od
-c
filename
to check this). OPatch complained with a message that said “Archive failed: failed
to update” and backed out the interim patch. Setting the environment variable
OPATCH_DEBUG=TRUE
,
which is documented in
Oracle Universal Installer and OPatch User's Guide 10g Release 2
, revealed
that it was not the
ar
command that was failing, but instead the verification. Meanwhile this
issue has been taken care of (see Metalink note 353150.1 for details).
The same approach of exchanging object modules is used to add or remove ORACLE
server options. Options can only be purchased with the Enterprise Edition of the ORACLE DBMS.
Currently, ten options exist, among them are the following:
Label Secur ty
Partitioning
Real Application Clusters
Spa ial
Data Mining
The Oracle10
g
OUI has a bug that causes Data Mining to be installed unconditionally—
even when it was deselected on the relevant OUI screen. The approach to add and remove
options, which will be presented shortly, may be used to work around this bug.
Which options are installed becomes evident when SQL*Plus is started.
$ sqlplus ndebes/secret
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Jul 26 02:21:43 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Oracle Label Security and Data
Mining options
SQL*Plus takes this information from the view
V$OPTION
:
SQL> SELECT parameter, value FROM v$option
WHERE parameter IN ('Partitioning','Real Application Clusters',
'Oracle Label Security','Data Mining')
PARAMETER VALUE
-------------------------------------- ------
Partitioning TRUE
Real Application Clusters TRUE
Oracle Label Security TRUE
Data Mining TRUE
As an option is added or removed by linking,
V$OPTION.VALUE
becomes
TRUE
or
FALSE
.
