Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

rajesh815
Occasional Visitor

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

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
4 REPLIES
Steven E. Protter
Exalted Contributor

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

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Peter Godron
Honored Contributor

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

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
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