Oracle wallets

[Mladen Gogala]

Hi!

I installed Oracle 18c on one of my virtual machines. Here is the output
of the "lsnrctl status":

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 27-AUG-2018 14:08:50

Copyright (c) 1991, 2018, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora18c)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date                27-AUG-2018 14:08:17
Uptime                    0 days 0 hr. 0 min. 33 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File
/oracle/product/18.0.0/dbhome_1/network/admin/listener.ora
Listener Log File /oracle/diag/tnslsnr/ora18c/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora18c.home.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ora18c.home.com)(PORT=5500))(Security=(my_wallet_directory=/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "64a52f53a7683286e053cda9e80aed76.home.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "746f25f235024350e0533401a8c0889d.home.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl.home.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.home.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclpdb.home.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[***@ora18c admin]$

Wallets are turned on by default, despite not being configured in
sqlnet.ora. AFAIK, wallets have always been an option which needed to be
purchased separately. Does it mean that they are included in the EE? I
found the document where the changes are now described:

https://docs.oracle.com/en/database/oracle/oracle-database/18/dbimi/release-changes.html#GUID-F3DB8384-C4C9-40DF-9C00-3E7786933EE1

It says nothing about having to pay for the wallets. If wallets are now
free, I'd suggest to Oracle to make partitioning option free as well.

Regards

[Stefan Knecht]

Wallets have never been a paid option as far as I can remember.

Some features which are using wallets on the other hand are - for example
TDE to encrypt data in databases, and up to a few years ago TLS encryption
for Oracle Net has been a part of Advanced Security but is now free
(perhaps this is what you mean?)

Stefan

Post by Mladen Gogala
Hi!
I installed Oracle 18c on one of my virtual machines. Here is the output
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 27-AUG-2018 14:08:50
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora18c)(
PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 18.0.0.0.0 -
Production
Start Date 27-AUG-2018 14:08:17
Uptime 0 days 0 hr. 0 min. 33 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/18.0.0/dbhome_
1/network/admin/listener.ora
Listener Log File /oracle/diag/tnslsnr/ora18c/
listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora18c.home.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ora18c.home.com)(PORT=5500))(
Security=(my_wallet_directory=/oracle/admin/orcl/xdb_wallet)
)(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "64a52f53a7683286e053cda9e80aed76.home.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "746f25f235024350e0533401a8c0889d.home.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl.home.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.home.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclpdb.home.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
Wallets are turned on by default, despite not being configured in
sqlnet.ora. AFAIK, wallets have always been an option which needed to be
purchased separately. Does it mean that they are included in the EE? I
https://docs.oracle.com/en/database/oracle/oracle-
database/18/dbimi/release-changes.html#GUID-F3DB8384-
C4C9-40DF-9C00-3E7786933EE1
It says nothing about having to pay for the wallets. If wallets are now
free, I'd suggest to Oracle to make partitioning option free as well.
Regards
--
Mladen Gogala
Database Consultant
Tel: [phone]

[Sheehan, Jeremy]

I recently embarked on a wallet adventure and found that the same as Stefan. I was using it to store a certificate for making a connection to a secure website and no need to pay.

Jeremy


From: oracle-l-***@freelists.org <oracle-l-***@freelists.org> On Behalf Of Stefan Knecht
Sent: Monday, August 27, 2018 3:00 PM
To: Mladen Gogala <***@gmail.com>
Cc: oracle-l <oracle-***@freelists.org>
Subject: Re: Oracle wallets

CAUTION - EXTERNAL EMAIL


Wallets have never been a paid option as far as I can remember.

Some features which are using wallets on the other hand are - for example TDE to encrypt data in databases, and up to a few years ago TLS encryption for Oracle Net has been a part of Advanced Security but is now free (perhaps this is what you mean?)

Stefan



On Tue, Aug 28, 2018 at 1:17 AM, Mladen Gogala <***@gmail.com<mailto:***@gmail.com>> wrote:

Hi!

I installed Oracle 18c on one of my virtual machines. Here is the output of the "lsnrctl status":

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 27-AUG-2018 14:08:50

Copyright (c) 1991, 2018, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora18c)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date 27-AUG-2018 14:08:17
Uptime 0 days 0 hr. 0 min. 33 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/18.0.0/dbhome_1/network/admin/listener.ora
Listener Log File /oracle/diag/tnslsnr/ora18c/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora18c.home.com<http://ora18c.home.com>)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ora18c.home.com<http://ora18c.home.com>)(PORT=5500))(Security=(my_wallet_directory=/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "64a52f53a7683286e053cda9e80aed76.home.com<http://64a52f53a7683286e053cda9e80aed76.home.com>" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "746f25f235024350e0533401a8c0889d.home.com<http://746f25f235024350e0533401a8c0889d.home.com>" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl.home.com<http://orcl.home.com>" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.home.com<http://orclXDB.home.com>" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclpdb.home.com<http://orclpdb.home.com>" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[***@ora18c admin]$

Wallets are turned on by default, despite not being configured in sqlnet.ora. AFAIK, wallets have always been an option which needed to be purchased separately. Does it mean that they are included in the EE? I found the document where the changes are now described:

https://docs.oracle.com/en/database/oracle/oracle-database/18/dbimi/release-changes.html#GUID-F3DB8384-C4C9-40DF-9C00-3E7786933EE1

It says nothing about having to pay for the wallets. If wallets are now free, I'd suggest to Oracle to make partitioning option free as well.

Regards
--
Mladen Gogala

Database Consultant

Tel: [phone]