/Var/tmp/. oracle and oracle listener (listener)

/Var/tmp/. oracle and oracle listener (listener)

 

Test the functions of/var/tmp/. oracle

~ --- View/var/tmp Permissions

[Root @ lixora var] # ll
Total 164
...
Drwxrwxrwt3 root 4096 Oct 31 tmp

 

[Root @ lixora. oracle] # ll
Total 0
Srwxrwxrwx 1 oracle10g oinstall 0 Oct 31 14:11 s #12569.1
Srwxrwxrwx 1 oracle10g oinstall 0 Oct 31 14:11 s #12569.2
Srwxrwxrwx 1 oracle10g oinstall 0 Oct 31 14:11 sEXTPROC0

 

----- Modify/var/tmp Permissions

[Root @ lixora var] # chmod 444 tmp
[Root @ lixora var] # ll
...
Dr -- r --3 root 4096 Oct 31 tmp
...

 

----- Try to start the listener

[Oracle10g @ lixora ~] $ Lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0-Production on 31-OCT-2014 14:13:31

Copyright (c) 1991,200 5, 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) abve...

 

 

 

---- Modify the permissions of/var/tmp again

[Root @ lixora var] # chmod 777 tmp
[Root @ lixora var] # ll
...
Drwxrwxrwx3 root 4096 Oct 31 tmp
...

 

Start the listener again.

Errors

ORA-12557:	TNS: protocol adapter not loadable
Cause:	On some platforms (such as OS/2) protocol adapters are loaded at run-time. if the shared library (or DLL) for the protocol adapter is missing or one of its supporting libraries is missing then this error is returned.
Action:	For further details, turn on tracing and reexecute the operation. The trace file will include the name of the shared library (or DLL) that cocould not be loaded.

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

 

It seems that no error descriptions are involved! But what is the file under/var/tmp/. oracle? Based on the description of the file:

[Root @ lixora. oracle] # ll
Total 0
Srwxrwxrwx 1 oracle10g oinstall 0 Oct 31 s #12538.1
Srwxrwxrwx 1 oracle10g oinstall 0 Oct 31 s #12538.2
Srwxrwxrwx 1 oracle10g oinstall 0 Oct 31 14:08 sEXTPROC0
[Root @ lixora. oracle] # pss-ef | grep 12538
54322 12538 1 0? 00:00:00/u02/app/oracle/product/10.2.0/db_1/bin/Tnslsnr LISTENER-inherit

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

So what is scoket used?

ODM find:

The hidden directory '/var/tmp /. oracle '(or/tmp /. oracle on some platforms) or its content was removed while instances & the CRS stack were up and running. typically this directory contains a number of "special" socket files that areUsed by local clients to connect via the IPC protocol (sqlnet) to varous 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.

 

That is to say, these socket files are used as local clients to communicate with different oracle processes using the inter-process communication protocol (ipc). These processes include tns listening, css, crs, evm daemon, and even database and asm instances. These sockets are created by the 'active listener' process. Here, oracle tns listener is used to create these socket files for communication between pmon and tnslsnr. The problem can be seen from the error message:

Error listening on: (ADDRESS = (PROTOCOL = ipc) (PARTIAL = yes) (QUEUESIZE = 1 ))

 

 

I do not know whether the above analysis is accurate. If not, please click here :-)

 

 

 

 

 

 

 

 

 

 

What is the relationship between oracle OracleOraHome92TNSListener service and LISTENNER in oracle net manager?

The OracleOraHome92TNSListener Service corresponds to the LISTENNER in oracle net manager. When you use Net Configuration Assitant to create a Listener, in the system service, you can create a corresponding OracleOraHome92TNSListener Service (the last few letters of the service name are different because the name of the listener you created is different). net manager also has an additional listener.

Oracle does not have a listener, and listener and tnsnames services are configured.

DEMO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.22.12.33) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = demo)
)
)

Change SERVICE_NAME in to the same as the SID in the listener, that is, SERVICE_NAME = ORCL;

If not, tnsping will take a look at the results.