#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