oracle-instantclient: don't create oradiag_username directory

[luke.krasnoff@…]

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.

[ryandesign (Ryan Carsten Schmidt)]

Thanks for explaining how to disable this behavior; I didn't know it was possible. I'll see about updating the port.

[stronk7 (Eloy Lafuente)]

Cc Me!