cancel
Showing results for 
Search instead for 
Did you mean: 

Question about the listener.ora

SOLVED
Go to solution
fly_fisher
Advisor

Question about the listener.ora

Hi all,

I've got this listener.ora:
LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= NMPROD))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host= mbtphp1)(Port= 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= NMPROD.world)
(ORACLE_HOME= /opt/app/oracle/product/8.1.6)
(SID_NAME = NMPROD)
)

(SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /opt/app/oracle/product/8.1.6)
(PROGRAM = extproc)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF

But I have seen some other listener.ora with:
(ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROC)) instead
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))

Could anybody tell me whats the difference between

(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
and
(ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROC))

Could it have any effect in the performance if I change this line ?

It's Oracle 8.1.6

Thanks,
Best Regards.
Catch and release !!!!!!
3 REPLIES
Steve Steel
Honored Contributor

Re: Question about the listener.ora

Hi

Different protocol only

see

http://www.siue.edu/~dbock/cis565/o18-net8administration.htm


Steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)
Sanjay_6
Honored Contributor

Re: Question about the listener.ora

Aashish Raj
Valued Contributor
Solution

Re: Question about the listener.ora

For IPC protocol, you have to provide a key(extproc) which tell the listener to listen for external procedure.
In the sid_list_listener part of listener.ora, you need to add following entries.
(SID_DESC =
(SID_NAME = jvmtst_ep)
(ORACLE_HOME = /oracle/prod)
(ENVS = LD_LIBRARY_PATH=/oracle/prod/ctx/lib)
(PROGRAM = extproc)

In the tnsnames.ora , you need to add following entry .
EXTPROC_CONNECTION_DATA.abc.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = jvmtst))
)
(CONNECT_DATA =
(SID = jvmtst_ep)
)
Where SID should match the SID_NAME which you specified in listener.ora and the KEY is the database name.

If you are not using external procedure, you can remove those entries from your listener.ora file.

AR