Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

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

Occasional Visitor

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


in my box some problems with listener so
from the listener and now all datbases working fine

is there any problem with this delete
Steven E. Protter
Exalted Contributor

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


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.

Steven E Protter
Owner of ISN Corporation
Peter Godron
Honored Contributor

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

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:

Please also read: on how to reward any useful answers given to your questions.

Out of interest, what was the original problem ?

Occasional Visitor

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

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

all database are working fine
Ben Dehner
Trusted Contributor

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

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.
Trust me, I know what I'm doing