Oracle Linux 6.5 with oracle-instantclient11.2-sqlplus-11.2.0.4.0-1 x86_64 package.
I'm trying to use sqlplus instant client to monitor couple of things in Oracle DB and I found strange thing.
I cannot disable client logging.
Gere is part of "strace -e trace=file" output:
[pid 16511] stat("/tmp", {st_mode=S_IFDIR|S_ISVTX|0777, st_size=4096, ...}) = 0
[pid 16511] stat("/tmp", {st_mode=S_IFDIR|S_ISVTX|0777, st_size=4096, ...}) = 0
[pid 16511] access("/tmp", W_OK) = 0
[pid 16511] statfs("/tmp", {f_type="EXT2_SUPER_MAGIC", f_bsize=4096, f_blocks=30614511, f_bfree=22646824, f_bavail=21066588, f_files=31621120, f_ffree=31130963, f_fsid={0, 0}, f_namelen=255, f_frsize=4096}) = 0
[pid 16511] open("/dev/urandom", O_RDONLY) = 4
[pid 16511] open("/tmp/sh-thd-1403408543", O_WRONLY|O_CREAT|O_EXCL|O_TRUNC, 0600) = 4
[pid 16511] open("/tmp/sh-thd-1403408543", O_RDONLY) = 5
[pid 16511] unlink("/tmp/sh-thd-1403408543") = 0
[pid 16511] execve("/usr/bin/sqlplus64", ["/usr/bin/sqlplus64", "-s", "monitoring/monitoring@MONITORING"], [/* 30 vars */]) = 0
[pid 16511] access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
[pid 16511] open("/etc/ld.so.cache", O_RDONLY) = 4
[pid 16511] open("/usr/lib/oracle/11.2/client64/lib/libsqlplus.so", O_RDONLY) = 4
[pid 16511] open("/usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1", O_RDONLY) = 4
[pid 16511] open("/usr/lib/oracle/11.2/client64/lib/libnnz11.so", O_RDONLY) = 4
[pid 16511] open("/lib64/libdl.so.2", O_RDONLY) = 4
[pid 16511] open("/lib64/libm.so.6", O_RDONLY) = 4
[pid 16511] open("/lib64/libpthread.so.0", O_RDONLY) = 4
[pid 16511] open("/lib64/libnsl.so.1", O_RDONLY) = 4
[pid 16511] open("/lib64/libc.so.6", O_RDONLY) = 4
[pid 16511] open("/usr/lib64/libaio.so.1", O_RDONLY) = 4
[pid 16511] open("/usr/lib/oracle/11.2/client64/lib/libsqlplusic.so", O_RDONLY) = 4
[pid 16511] open("/usr/lib/oracle/11.2/client64/lib/libociei.so", O_RDONLY) = 4
[pid 16511] getcwd("/home"..., 256) = 6
[pid 16511] access("/network/admin/sqlnet.ora", F_OK) = -1 ENOENT (No such file or directory)
[pid 16511] access("/usr/lib/oracle/11.2/client64/network/admin/sqlnet.ora", F_OK) = 0
[pid 16511] open("/usr/lib/oracle/11.2/client64/network/admin/sqlnet.ora", O_RDONLY) = 4
[pid 16511] access("/root/.sqlnet.ora", F_OK) = -1 ENOENT (No such file or directory)
[pid 16511] stat("/usr/lib/oracle/11.2/client64/log", 0x7fffc318da40) = -1 ENOENT (No such file or directory)
[pid 16511] stat("/root", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
[pid 16511] open("/proc/self/fd/", O_RDONLY|O_NONBLOCK|O_DIRECTORY) = 4
[pid 16511] stat("/usr/lib/oracle/11.2/client64/log", 0x7fffc318e9a0) = -1 ENOENT (No such file or directory)
[pid 16511] stat("/root", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
[pid 16511] access("/network/admin/sqlnet.ora", F_OK) = -1 ENOENT (No such file or directory)
[pid 16511] access("/usr/lib/oracle/11.2/client64/network/admin/sqlnet.ora", F_OK) = 0
[pid 16511] open("/usr/lib/oracle/11.2/client64/network/admin/sqlnet.ora", O_RDONLY) = 5
[pid 16511] access("/network/admin/intchg.ora", F_OK) = -1 ENOENT (No such file or directory)
[pid 16511] access("/etc/intchg.ora", F_OK) = -1 ENOENT (No such file or directory)
[pid 16511] access("/usr/lib/oracle/11.2/client64/network/admin/intchg.ora", F_OK) = -1 ENOENT (No such file or directory)
[pid 16511] access("/network/admin/tnsnav.ora", F_OK) = -1 ENOENT (No such file or directory)
[pid 16511] access("/etc/tnsnav.ora", F_OK) = -1 ENOENT (No such file or directory)
[pid 16511] access("/usr/lib/oracle/11.2/client64/network/admin/tnsnav.ora", F_OK) = -1 ENOENT (No such file or directory)
[pid 16511] mkdir("/root/oradiag_root", 0775) = -1 EEXIST (File exists)
[pid 16511] stat("/root/oradiag_root/diag", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/trace", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/alert", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/incident", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata_pv", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata_dgif", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/incpkg", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/sweep", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/lck", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/cdump", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/stage", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
[pid 16511] lstat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_CONTROL.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_CONTROL.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
[pid 16511] lstat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_INVALIDATION.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_INVALIDATION.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
[pid 16511] lstat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/INC_METER_IMPT_DEF.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/INC_METER_IMPT_DEF.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
[pid 16511] lstat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/INC_METER_PK_IMPTS.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/INC_METER_PK_IMPTS.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
[pid 16511] lstat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_CONTROL.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_CONTROL.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_CONTROL.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_CONTROL.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
[pid 16511] open("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_CONTROL.ams", O_RDONLY) = 5
[pid 16511] statfs("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_CONTROL.ams", {f_type="EXT2_SUPER_MAGIC", f_bsize=4096, f_blocks=30614511, f_bfree=22646823, f_bavail=21066587, f_files=31621120, f_ffree=31130962, f_fsid={0, 0}, f_namelen=255, f_frsize=4096}) = 0
[pid 16511] open("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_CONTROL.ams", O_RDONLY|O_DIRECT) = 5
[pid 16511] statfs("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_CONTROL.ams", {f_type="EXT2_SUPER_MAGIC", f_bsize=4096, f_blocks=30614511, f_bfree=22646823, f_bavail=21066587, f_files=31621120, f_ffree=31130962, f_fsid={0, 0}, f_namelen=255, f_frsize=4096}) = 0
[pid 16511] statfs("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_CONTROL.ams", {f_type="EXT2_SUPER_MAGIC", f_bsize=4096, f_blocks=30614511, f_bfree=22646823, f_bavail=21066587, f_files=31621120, f_ffree=31130962, f_fsid={0, 0}, f_namelen=255, f_frsize=4096}) = 0
[pid 16511] open("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/metadata/ADR_CONTROL.ams", O_RDONLY|O_SYNC|O_DIRECT) = 5
[pid 16511] open("/etc/gai.conf", O_RDONLY) = -1 ENOENT (No such file or directory)
[pid 16511] lstat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/alert/log.xml", {st_mode=S_IFREG|0640, st_size=2268, ...}) = 0
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/alert/log.xml", {st_mode=S_IFREG|0640, st_size=2268, ...}) = 0
[pid 16511] open("/etc/localtime", O_RDONLY) = 5
[pid 16511] lstat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/alert/log.xml", {st_mode=S_IFREG|0640, st_size=2268, ...}) = 0
[pid 16511] open("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/alert/log.xml", O_WRONLY|O_CREAT|O_APPEND, 0660) = 5
[pid 16511] stat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/alert/log.xml", {st_mode=S_IFREG|0640, st_size=2534, ...}) = 0
[pid 16511] lstat("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/trace/sqlnet.log", {st_mode=S_IFREG|0640, st_size=551, ...}) = 0
[pid 16511] open("/root/oradiag_root/diag/clients/user_root/host_1435714048_80/trace/sqlnet.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = 5
[pid 16511] open("/usr/lib64/libnuma.so", O_RDONLY) = -1 ENOENT (No such file or directory)
[pid 16511] open("/usr/lib64/libnuma.so.1", O_RDONLY) = 5
[pid 16511] open("/sys/devices/system/node", O_RDONLY|O_NONBLOCK|O_DIRECTORY) = 5
[pid 16511] open("/proc/self/status", O_RDONLY) = 5
[pid 16511] open("/proc/sys/kernel/shmmax", O_RDONLY) = 5
[pid 16511] open("/proc/meminfo", O_RDONLY) = 5
[pid 16511] open("/usr/lib64/libnuma.so", O_RDONLY) = -1 ENOENT (No such file or directory)
[pid 16511] open("/proc/self/status", O_RDONLY) = 5
[pid 16511] getcwd("/home"..., 256) = 6
[pid 16511] access("/root/.tnsnames.ora", F_OK) = -1 ENOENT (No such file or directory)
[pid 16511] access("/network/admin/tnsnames.ora", F_OK) = -1 ENOENT (No such file or directory)
[pid 16511] access("/etc/tnsnames.ora", F_OK) = -1 ENOENT (No such file or directory)
[pid 16511] access("/usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora", F_OK) = 0
[pid 16511] stat("/usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora", {st_mode=S_IFREG|0644, st_size=206, ...}) = 0
[pid 16511] open("/usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora", O_RDONLY) = 5
[pid 16511] open("/proc/self/cmdline", O_RDONLY) = 5
[pid 16511] getcwd("/home"..., 256) = 6
[pid 16511] stat("/usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora", {st_mode=S_IFREG|0644, st_size=206, ...}) = 0
[pid 16511] getcwd("/home"..., 256) = 6
[pid 16511] getcwd("/home"..., 256) = 6
[pid 16511] open("/usr/lib/oracle/11.2/client64/lib/libnque11.so", O_RDONLY) = -1 ENOENT (No such file or directory)
[pid 16511] open("/etc/hostid", O_RDONLY) = -1 ENOENT (No such file or directory)
[pid 16511] open("/etc/resolv.conf", O_RDONLY) = 5
[pid 16511] getcwd("/home"..., 256) = 6
[pid 16511] stat("login.sql", 0x7fffc318fdf0) = -1 ENOENT (No such file or directory)
[pid 16511] stat("glogin.sql", 0x7fffc318fdf0) = -1 ENOENT (No such file or directory)
In /usr/lib/oracle/11.2/client64/network/admin/sqlnet.ora I have:
SQLNET.EXPIRE_TIME=15
TRACE_LEVEL_CLIENT=OFF
Seems that TRACE_LEVEL_CLIENT=OFF doesn't work and by this sqlplus command is writing completely useless files (fo me) files in "/oradiag_<username>/ directory.
Bug or I'm doing something wrong?
Every time when client is executed additionally in /root/oradiag_root/diag/clients/user_root/host_1435714048_80/trace/sqlnet.lo I see new log entries like:
Directory does not exist for read/write [/usr/lib/oracle/11.2/client64/log] []
Should I open SR for this?