oracle var/tmp,坑人的/tmp/.oracle

看似是个临时目录，但是删除它会导致RAC运行出错，只能重启RAC或server解决；另外，若启动RAC时该目录仍残留有关闭前的各种文件，也会导致RAC无法正常启动，此时需要将其删除才能成功；

The hidden directory ‘/var/tmp/.oracle’ was removed while instances & the CRS stack were up and running. Typically this directory contains a number of “special” socket files that are used by local clients to connect via the IPC protocol (sqlnet) to various Oracle processes including the TNS listener, the CSS, CRS & EVM daemons or even database or ASM instances. These files are created when the “listening” process starts

不光是RAC进程，listener也有可能会因此该目录而无法启动

1.Failure to startup after reboot:

Check if the hidden directory /tmp/.oracle or /var/tmp/.oracle is clean. Old sockets left from previous listener starts, can stop a listener from starting. Ensure tmp has space. Check permissions are correct (777) for these directories and that the owner is the oracle account who owns the binaries and correct group. Truss for failure could look similar to

25078: chmod("/tmp/.oracle", 01777) Err#1 EPERM

25078: socket(1, 1, 0) = 3

25078: access("/tmp/.oracle/sEXTPROC", 0) = 0

25078: connext(3, 0x0FFFFFFFFFFF7D00, 106) Err#79 ECONNREFUSED

--Troubleshooting TNS listener Startup Failures [ID 946508.1]

很难想象oracle把如此重要的东西放在/tmp目录下，而他们给出的解释是因为隐蔽所以估计没有人会注意到，因而不会被误删除。

以下是一个外国同行的吐槽，相信中招的DBA不在少数

However, I really was dumbstruck that Oracle would have so critical a directory in /var/tmp! I politely note this to Oracle Support, who justified this location with a few solid reasons:

1.It has always been in this location (and still is in 11gR2).

2./var/tmp/.oracle is a hidden directory, so it probably won’t be noticed by any miscreants looking to cause trouble