A little understanding of/var/tmp/.oracle and Oracle Listener (listening)

On the role of/var/tmp/.oracle test

~---to view/var/tmp permissions

[email protected] var]# LL
Total 164
。。。
DRWXRWXRWT 3 root root 4096 Oct 13:16 tmp

[email protected]. oracle]# LL
Total 0
SRWXRWXRWX 1 oracle10g oinstall 0 Oct 14:11 s#12569.1
SRWXRWXRWX 1 oracle10g oinstall 0 Oct 14:11 s#12569.2
SRWXRWXRWX 1 oracle10g oinstall 0 Oct 14:11 sEXTPROC0

-----Change permissions for/var/tmp

[Email protected] var]# chmod 444 tmp
[email protected] var]# LL
。。。
dr--r--r-- 3 root root 4096 Oct 13:16 tmp
。。。

-----Try to start monitoring

[[email protected] ~]$ lsnrctl start

Lsnrctl for linux:version 10.2.0.1.0-production on 31-oct-2014 14:13:31

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting/u02/app/oracle/product/10.2.0/db_1/bin/tnslsnr:please wait ...

Tnslsnr for Linux:version 10.2.0.1.0-production
System parameter File Is/u02/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages Written To/u02/app/oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (Address= (PROTOCOL=IPC) (Partial=yes) (queuesize=1))
No Longer listening on: (Description= (Address= (protocol=tcp) (Host=lixora) (port=1521)))
Tns-12557:tns:protocol Adapter Not loadable
Tns-12560:tns:protocol Adapter Error
Tns-00527:protocol Adapter not loadable

Listener failed to start. See the error message (s) above ...

----To change/var/tmp permissions again

[Email protected] var]# chmod 777 tmp
[email protected] var]# LL
。。。
drwxrwxrwx 3 root root 4096 Oct 13:16 tmp
。。。

To start monitoring again, to start normally.

About errors

ORA-12557:	Tns:protocol Adapter Not loadable
Cause:	On some platforms (such as OS/2) protocol adapters is loaded at Run-time. If the shared library (or DLL) for the protocol adapter are missing or one of its supporting libraries are missing then this Error is returned.
Action:	For further details, turn on tracing and reexecute the operation. The trace file would include the name of the shared library (or DLL) that is could not being loaded.

1. Make sure the%oracle_home%/bin directory are in your PATH.
2. Make sure the protocol are typed/specified correctly in your Tnsnames.ora file or whatever source you ' re using to Resolv E servicenames.
3. TCP is the default protocol and was installed by default. Ifyou ' re using something different (like SPX) Make sure you installed the protocol adapter.
4. Make sure TOAD are using the correct Oracle home if you have multiple homes installed

It seems that there is no related error descriptive narrative Ah! But what exactly is the document under/var/tmp/.oracle? According to the descriptive description of the document:

[email protected]. oracle]# LL
Total 0
SRWXRWXRWX 1 oracle10g oinstall 0 Oct 14:08 s#12538.1
SRWXRWXRWX 1 oracle10g oinstall 0 Oct 14:08 s#12538.2
SRWXRWXRWX 1 oracle10g oinstall 0 Oct 14:08 sEXTPROC0
[email protected]. oracle]# Ps-ef|grep 12538
54322 12538 1 0 14:08? 00:00:00/u02/app/oracle/product/10.2.0/db_1/bin/tnslsnr listener-inherit

These files are socket files, and 12568 in s#12368.1 is the process number, verified to be the process number of the listener

So what do these scoket for?

ODM Find:

The hidden directory '/var/tmp/.oracle ' (or/tmp/.oracle on some platforms) or its content is removed while instances &A mp The CRS stack were up and running. Typically this directory contains a number of "special" sockets files that isused 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 data Base or ASM instances. These files is created when the "listening" process starts.  

That is to say: These sockets are used as local clients using interprocess communication Protocol (IPC) and different Oracle process communications, which include: TNS Listener, CSS, CRS,EVM daemon, and even database and ASM instances. These sockets are created by the ' active listener ' process. Here Oracle TNS Listener creates these socket files that are primarily used as Pmon and Tnslsnr communication from the error message to be able to see the problem:

Error listening on: (Address= (PROTOCOL=IPC) (Partial=yes) (queuesize=1))

Do not know whether the above analysis is accurate, improper place please shoot brick:-)

A little understanding of/var/tmp/.oracle and Oracle Listener (listening)