i deleter (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) from listener

[rajesh815]

hi,

in my box some problems with listener so
i delete (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
from the listener and now all datbases working fine


is there any problem with this delete

[Steven E. Protter]

Shalom,

To answer, I'd need to know more about the entire configuration file.

The good news is everything seems to be working.

I'd watch the alert logs and make sure tnsping works properly on all systems that need access.

SEP

[Peter Godron]

Hi,
and welcome to the forums !

What version of Oracle ?
Deleted from $ORACLE_HOME/network/admin/listener.ora or
$ORACLE_HOME/network/admin/tnsnames.ora ?

You may want to read:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=12622

Please also read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#33 on how to reward any useful answers given to your questions.

Out of interest, what was the original problem ?

[rajesh815]

i test all alias(with tnsping) all are working fine and

all database are working fine

[Ben Dehner]

In general, there shouldn't be a problem. This directive used in two places:

1) if you have a user-created external library set up with the 'create library' DDL, or

2) if you use IPC-type shared server connections to your database. These are not the default (TCP is the default), and must be manually configured.

This forces all communication to the listener to be done via TCP/IP. This will not affect implicit bequeath connections such as "set ORACLE_SID=SID; sqlpulus / as sywsdba" which don't use the listener anyway.