[MacPorts] #42880: Configure oracle-instantclient not to create oradiag_username directory

[MacPorts]

#42880: Configure oracle-instantclient not to create oradiag_username directory
-----------------------------+----------------------------------
 Reporter:  luke.krasnoff@…  |      Owner:  macports-tickets@…
     Type:  request          |     Status:  new
 Priority:  Normal           |  Milestone:
Component:  ports            |    Version:  2.2.1
 Keywords:  oradiag          |       Port:  oracle-instantclient
-----------------------------+----------------------------------
 The default behaviour of oracle-instantclient is to create a directory
 structure in ${HOME}/oradiag_${USER} for Oracle 11g. If you look at the
 sqlnet.log file deep inside that directory, it is looking to write logging
 information into /opt/local/lib/oracle/log. Doing an internet search shows
 that people have been complaining to Oracle about this problem for years.
 The issue is that libraries should not be writing to the file system
 without the developers consent.

 It is obvious that Oracle either doesn't agree that this is a problem, or
 doesn't intend to fix this behaviour. In view of this, a possible solution
 in this port, is to install an sqlnet.ora file in the
 $ORACLE_HOME/network/admin directory of oracle-instantclient. So the path
 would be:

 {{{
 /opt/local/lib/oracle/network/admin/sqlnet.ora
 }}}


 The contents of sqlnet.ora would be:

 {{{
 DIAG_ADR_ENABLED = OFF
 TRACE_LEVEL_CLIENT = OFF
 TRACE_DIRECTORY_CLIENT=/dev/null
 LOG_DIRECTORY_CLIENT = /dev/null
 LOG_FILE_CLIENT = /dev/null
 LOG_LEVEL_CLIENT = OFF
 }}}


 I would suggest that an sqlnet.ora file be installed as part of oracle-
 instantclient, so that by default there would be no logging. This could be
 modified later by the developer if logging was desired.

-- 
Ticket URL: <https://trac.macports.org/ticket/42880>
MacPorts <http://www.macports.org/>
Ports system for OS X