Re: unable to open RPC connection to external procedure agent

From: Richard Aas <richard_at_foo.bar>
Date: Thu, 27 Jun 2002 16:41:08 GMT
Message-ID: <3D1B3F4E.7020904@foo.bar>

Khalid Eidoo wrote:

> Thanks for the suggestion Richard. I commented out the NAMES.DEFAULT_DOMAIN
> in my sqlnet.ora file. I then altered extproc_connection_data to
> extproc_connection_data.terida.com; After bouncing the listener, I am still
> getting the same error.

No... What I meant was either comment out NAMES.DEFAULT_DOMAIN _or_ alter extproc_connection_data. Doing both at the same time won't do.

Try to just comment out NAMES.DEFAULT_DOMAIN first...

> 
> Khalid.
> 
> "Richard Aas" <richard_at_foo.bar> wrote in message
> news:3D1B2B83.8060002_at_foo.bar...
> 

>>Try to comment out/remove your NAMES.DEFAULT_DOMAIN entry in sqlnet.ora.
>>Or (if you need the default_domain entry) alter extproc_connection_data
>>to extproc_connection_data.your_default_domain in tnsnames.ora.
>>
>>Khalid Eidoo wrote:
>>
>>>Hi Rauf,
>>>
>>>I made the changes you suggested, however I am still having problems
>>

> with
> 

>>>the listener. I restarted the listener (./lsnrctl stop FORSYS; ./lsnrctl
>>>start FORSYS), and the extproc part appears to start, but I am unable to
>>

> get
> 

>>>an RPC connection. Based on the suggestions I understood from your
>>

> response,
> 


>>>my .ora files look like this:

>>>

>>># LISTENER.ORA Network Configuration File:

>>>/home/oracle/config/9.0.1/listener.ora

>>># Generated by Oracle configuration tools.

>>>

>>>FORSYS =

>>>(DESCRIPTION_LIST =

>>>  (DESCRIPTION =

>>>    (ADDRESS = (PROTOCOL = TCP)(HOST = forsys.terida.com)(PORT = 1521))

>>>  )

>>>  (DESCRIPTION =

>>>    (ADDRESS = (PROTOCOL = ipc)(KEY = extproc))

>>>  )

>>>)

>>>SAVE_CONFIG_ON_STOP_FORSYS = TRUE

>>>

>>>SID_LIST_FORSYS =

>>>   (SID_LIST =

>>>      (SID_DESC =

>>>         (GLOBAL_DBNAME = forsys.terida.com)

>>>  (ORACLE_HOME = /opt/oracle/product/9.0.1)

>>>  (SID_NAME = forsys)

>>>      )

>>>      (SID_DESC =

>>>         (SID_NAME = extproc)

>>>         (ORACLE_HOME = /opt/oracle/product/9.0.1)

>>>  (PROGRAM = extproc)

>>>      )

>>>   )

>>>

>>># TNSNAMES.ORA Network Configuration File:

>>>C:\oracle\ora90\network\admin\tnsnames.ora

>>># Generated by Oracle configuration tools.

>>>

>>>FORSYS =

>>>

>>>(DESCRIPTION =

>>>

>>>(ADDRESS_LIST =

>>>

>>>(ADDRESS = (PROTOCOL = TCP)(HOST = forsys.terida.com)(PORT = 1521))

>>>

>>>)

>>>

>>>(CONNECT_DATA =

>>>

>>>(SERVICE_NAME = forsys.terida.com)

>>>

>>>)

>>>

>>>)

>>>

>>>extproc_connection_data =

>>>

>>>(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))

>>>

>>>(CONNECT_DATA=(SID=extproc)))

>>>

>>>

>>>
>>>
>>

>
> Received on Thu Jun 27 2002 - 11:41:08 CDT