MIME-Version: 1.0
References: <19cacd0ec5764fc08e31f7bb34656f54@vontobel.com>
In-Reply-To: <19cacd0ec5764fc08e31f7bb34656f54@vontobel.com>
From: Adric Norris <landstander668@gmail.com>
Date: Wed, 7 Jul 2021 10:24:42 -0500
Message-ID: <CAJueESqV9jhV+szDnmSU4W_zHuh+xAeDGXZeP14zizzXhQTgSQ@mail.gmail.com>
Subject: Re: chopt - show disabled options
To: nenad.noveljic@vontobel.com
Cc: "ORACLE-L (oracle-l@freelists.org)" <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="00000000000063080605c68a252b"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: landstander668@gmail.com
--00000000000063080605c68a252b
Content-Type: text/plain; charset="UTF-8"

Here's the script I use for this purpose.

$ cat oracle_options_state.sh
#!/bin/bash

if [[ -z $ORACLE_HOME ]]; then
   echo "ERROR: The ORACLE_HOME environment variable must be set" >&2
   exit 1
fi

echo "Oracle options set for ORACLE_HOME=$ORACLE_HOME"
echo

{ # Attempt to interpret the enabled/disabled options from libknlopt.a, per
the information
  # from note 948061.1.
  ar -t $ORACLE_HOME/rdbms/lib/libknlopt.a \
     | awk '/^kfon\.o$/     { print "Automatic Storage Management (ASM) -
Enabled"  ; next }
            /^kfoff\.o$/    { print "Automatic Storage Management (ASM) -
Disabled" ; next }
            /^dmwdm\.o$/    { print "Advanced Analytics (Data Mining) -
Enabled"    ; next }
            /^dmndm\.o$/    { print "Advanced Analytics (Data Mining) -
Disabled"   ; next }
            /^kciwcx\.o$/   { print "Context Management Text - Enabled
(mandatory)" ; next }
            /^kzvidv\.o$/   { print "Database Vault - Enabled"
         ; next }
            /^kzvndv\.o$/   { print "Database Vault - Disabled"
        ; next }
            /^xsyeolap\.o$/ { print "OLAP - Enabled"
         ; next }
            /^xsnoolap\.o$/ { print "OLAP - Disabled"
        ; next }
            /^kzlilbac\.o$/ { print "Label Security - Enabled"
         ; next }
            /^kzlnlbac\.o$/ { print "Label Security - Disabled"
        ; next }
            /^kkpoban\.o$/  { print "Partitioning - Enabled"
         ; next }
            /^ksnkkpo\.o$/  { print "Partitioning - Disabled"
        ; next }
            /^kcsm\.o$/     { print "Real Application Clusters (RAC) -
Enabled"     ; next }
            /^ksnkcs\.o$/   { print "Real Application Clusters (RAC) -
Disabled"    ; next }
            /^kecwr\.o$/    { print "Real Application Testing (RAT) -
Enabled"      ; next }
            /^kecnr\.o$/    { print "Real Application Testing (RAT) -
Disabled"     ; next }
            /^kzaiang\.o$/  { print "Unified Auditing - Enabled"
         ; next }
            /^kzanang\.o$/  { print "Unified Auditing - Disabled"
        ; next }
#           { print $0 }   # uncomment to see items with unknown mappings'

  # For some reason DirectNFS is handled differently. This check should
work for 12c and later.
  if [[ $( ls -1 $ORACLE_HOME/rdbms/lib/odm/libnfsodm*.so | wc -l ) -gt 0
]]; then
     echo "Direct NFS (dNFS) - Enabled"
  else
     echo "Direct NFS (dNFS) - Disabled"
  fi
} | sort

On Wed, Jul 7, 2021 at 1:14 AM Noveljic Nenad <nenad.noveljic@vontobel.com>
wrote:

> Is it possible to figure out disabled options (in the binaries, not in the
> db registry) without connecting to a database?
>
>
>
> Best regards,
>
>
>
> Nenad
>
> ____________________________________________________
>
> Please consider the environment before printing this e-mail.
>
> Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
>
>
> Important Notice
>
> This message is intended only for the individual named. It may contain
> confidential or privileged information. If you are not the named addressee
> you should in particular not disseminate, distribute, modify or copy this
> e-mail. Please notify the sender immediately by e-mail, if you have
> received this message by mistake and delete it from your system.
> Without prejudice to any contractual agreements between you and us which
> shall prevail in any case, we take it as your authorization to correspond
> with you by e-mail if you send us messages by e-mail. However, we reserve
> the right not to execute orders and instructions transmitted by e-mail at
> any time and without further explanation.
> E-mail transmission may not be secure or error-free as information could
> be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also
> processing of incoming e-mails cannot be guaranteed. All liability of
> Vontobel Holding Ltd. and any of its affiliates (hereinafter collectively
> referred to as "Vontobel Group") for any damages resulting from e-mail use
> is excluded. You are advised that urgent and time sensitive messages should
> not be sent by e-mail and if verification is required please request a
> printed version.
> Please note that all e-mail communications to and from the Vontobel Group
> are subject to electronic storage and review by Vontobel Group. Unless
> stated to the contrary and without prejudice to any contractual agreements
> between you and Vontobel Group which shall prevail in any case,
> e-mail-communication is for informational purposes only and is not intended
> as an offer or solicitation for the purchase or sale of any financial
> instrument or as an official confirmation of any transaction.
> The legal basis for the processing of your personal data is the legitimate
> interest to develop a commercial relationship with you, as well as your
> consent to forward you commercial communications. You can exercise, at any
> time and under the terms established under current regulation, your rights.
> If you prefer not to receive any further communications, please contact
> your client relationship manager if you are a client of Vontobel Group or
> notify the sender. Please note for an exact reference to the affected group
> entity the corporate e-mail signature. For further information about data
> privacy at Vontobel Group please consult www.vontobel.com.
>


-- 
"In the beginning the Universe was created. This has made a lot of people
very angry and been widely regarded as a bad move." -Douglas Adams

--00000000000063080605c68a252b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Here&#39;s the script I use for this purpose.</div><d=
iv><br></div><div style=3D"margin-left:40px"><span style=3D"font-family:mon=
ospace">$ cat oracle_options_state.sh</span></div><div style=3D"margin-left=
:40px"><span style=3D"font-family:monospace">#!/bin/bash<br><br>if [[ -z $O=
RACLE_HOME ]]; then<br>=C2=A0 =C2=A0echo &quot;ERROR: The ORACLE_HOME envir=
onment variable must be set&quot; &gt;&amp;2<br>=C2=A0 =C2=A0exit 1<br>fi<b=
r><br>echo &quot;Oracle options set for ORACLE_HOME=3D$ORACLE_HOME&quot;<br=
>echo<br><br>{ # Attempt to interpret the enabled/disabled options from lib=
knlopt.a, per the information<br>=C2=A0 # from note 948061.1.<br>=C2=A0 ar =
-t $ORACLE_HOME/rdbms/lib/libknlopt.a \<br>=C2=A0 =C2=A0 =C2=A0| awk &#39;/=
^kfon\.o$/ =C2=A0 =C2=A0 { print &quot;Automatic Storage Management (ASM) -=
 Enabled&quot; =C2=A0; next }<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
/^kfoff\.o$/ =C2=A0 =C2=A0{ print &quot;Automatic Storage Management (ASM) =
- Disabled&quot; ; next }<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /^dm=
wdm\.o$/ =C2=A0 =C2=A0{ print &quot;Advanced Analytics (Data Mining) - Enab=
led&quot; =C2=A0 =C2=A0; next }<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 /^dmndm\.o$/ =C2=A0 =C2=A0{ print &quot;Advanced Analytics (Data Mining=
) - Disabled&quot; =C2=A0 ; next }<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 /^kciwcx\.o$/ =C2=A0 { print &quot;Context Management Text - Enabled=
 (mandatory)&quot; ; next }<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /^=
kzvidv\.o$/ =C2=A0 { print &quot;Database Vault - Enabled&quot; =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0; next }<=
br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /^kzvndv\.o$/ =C2=A0 { print &=
quot;Database Vault - Disabled&quot; =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ; next }<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 /^xsyeolap\.o$/ { print &quot;OLAP - Enabled&quot; =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0; next }<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 /^xsnoolap\.o$/ { print &quot;OLAP - Disabled&quot; =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 ; next }<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /^kzlil=
bac\.o$/ { print &quot;Label Security - Enabled&quot; =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0; next }<br>=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /^kzlnlbac\.o$/ { print &quot;Label Secu=
rity - Disabled&quot; =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 ; next }<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /^k=
kpoban\.o$/ =C2=A0{ print &quot;Partitioning - Enabled&quot; =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0; next=
 }<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /^ksnkkpo\.o$/ =C2=A0{ prin=
t &quot;Partitioning - Disabled&quot; =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ; next }<br>=C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 /^kcsm\.o$/ =C2=A0 =C2=A0 { print &quot;Real Applicati=
on Clusters (RAC) - Enabled&quot; =C2=A0 =C2=A0 ; next }<br>=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 /^ksnkcs\.o$/ =C2=A0 { print &quot;Real Applica=
tion Clusters (RAC) - Disabled&quot; =C2=A0 =C2=A0; next }<br>=C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /^kecwr\.o$/ =C2=A0 =C2=A0{ print &quot;Real A=
pplication Testing (RAT) - Enabled&quot; =C2=A0 =C2=A0 =C2=A0; next }<br>=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /^kecnr\.o$/ =C2=A0 =C2=A0{ print=
 &quot;Real Application Testing (RAT) - Disabled&quot; =C2=A0 =C2=A0 ; next=
 }<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /^kzaiang\.o$/ =C2=A0{ prin=
t &quot;Unified Auditing - Enabled&quot; =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0; next }<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 /^kzanang\.o$/ =C2=A0{ print &quot;Unified Auditing - Disable=
d&quot; =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ; ne=
xt }<br># =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 { print $0 } =C2=A0 # uncommen=
t to see items with unknown mappings&#39;<br><br>=C2=A0 # For some reason D=
irectNFS is handled differently. This check should work for 12c and later.<=
br>=C2=A0 if [[ $( ls -1 $ORACLE_HOME/rdbms/lib/odm/libnfsodm*.so | wc -l )=
 -gt 0 ]]; then<br>=C2=A0 =C2=A0 =C2=A0echo &quot;Direct NFS (dNFS) - Enabl=
ed&quot;<br>=C2=A0 else<br>=C2=A0 =C2=A0 =C2=A0echo &quot;Direct NFS (dNFS)=
 - Disabled&quot;<br>=C2=A0 fi<br>} | sort</span></div></div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Jul 7, 2021 =
at 1:14 AM Noveljic Nenad &lt;<a href=3D"mailto:nenad.noveljic@vontobel.com=
">nenad.noveljic@vontobel.com</a>&gt; wrote:<br></div><blockquote class=3D"=
gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex">


<div lang=3D"DE-CH">
<div class=3D"gmail-m_-9156530397833698153WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:&quot;Aria=
l&quot;,sans-serif" lang=3D"EN-US">Is it possible to figure out disabled op=
tions (in the binaries, not in the db registry) without connecting to a dat=
abase?<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:&quot;Aria=
l&quot;,sans-serif" lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:&quot;Aria=
l&quot;,sans-serif" lang=3D"EN-US">Best regards,<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:&quot;Aria=
l&quot;,sans-serif" lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:&quot;Aria=
l&quot;,sans-serif" lang=3D"EN-US">Nenad<u></u><u></u></span></p>
</div>

<p class=3D"MsoNormal"><span style=3D"color:green" lang=3D"EN-US">_________=
___________________________________________<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"color:green" lang=3D"EN-US">Please co=
nsider the environment before printing this e-mail.<u></u><u></u></span></p=
>
<p class=3D"MsoNormal"><span style=3D"color:green">Bitte denken Sie an die =
Umwelt, bevor Sie dieses E-Mail drucken.</span><span style=3D"color:green">=
<u></u><u></u></span></p>


<p>
<br>Important Notice<br>
<br>
This message is intended only for the individual named. It may contain conf=
idential or privileged information. If you are not the named addressee you =
should in particular not disseminate, distribute, modify or copy this e-mai=
l. Please notify the sender immediately by e-mail, if you have received thi=
s message by mistake and delete it from your system.<br>
Without prejudice to any contractual agreements between you and us which sh=
all prevail in any case, we take it as your authorization to correspond wit=
h you by e-mail if you send us messages by e-mail. However, we reserve the =
right not to execute orders and instructions transmitted by e-mail at any t=
ime and without further explanation.<br>
E-mail transmission may not be secure or error-free as information could be=
 intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also p=
rocessing of incoming e-mails cannot be guaranteed. All liability of Vontob=
el Holding Ltd. and any of its affiliates (hereinafter collectively referre=
d to as &quot;Vontobel Group&quot;) for any damages resulting from e-mail u=
se is excluded. You are advised that urgent and time sensitive messages sho=
uld not be sent by e-mail and if verification is required please request a =
printed version.<br>
Please note that all e-mail communications to and from the Vontobel Group a=
re subject to electronic storage and review by Vontobel Group. Unless state=
d to the contrary and without prejudice to any contractual agreements betwe=
en you and Vontobel Group which shall prevail in any case, e-mail-communica=
tion is for informational purposes only and is not intended as an offer or =
solicitation for the purchase or sale of any financial instrument or as an =
official confirmation of any transaction.<br>
The legal basis for the processing of your personal data is the legitimate =
interest to develop a commercial relationship with you, as well as your con=
sent to forward you commercial communications. You can exercise, at any tim=
e and under the terms established under current regulation, your rights. If=
 you prefer not to receive any further communications, please contact your =
client relationship manager if you are a client of Vontobel Group or notify=
 the sender.
Please note for an exact reference to the affected group entity the corpora=
te e-mail signature.
For further information about data privacy at Vontobel Group please consult=
=C2=A0<a href=3D"https://www.vontobel.com" target=3D"_blank">www.vontobel.c=
om</a>.<br>
</p></div>

</blockquote></div><br clear=3D"all"><br>-- <br><div dir=3D"ltr" class=3D"g=
mail_signature"><div dir=3D"ltr">&quot;In the beginning the Universe was cr=
eated. This has made a lot of people very angry and been widely regarded as=
 a bad move.&quot; -Douglas Adams<br></div></div>

--00000000000063080605c68a252b--
--
http://www.freelists.org/webpage/oracle-l