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 - 10:16:40 CDT
