Re: Oracle Client with TCP/IP only

I think your problem is due to the setting in TNSNAMES.ORA. This file is used to specify the protocol used and their address of any Oracle server.

Examine the TNSNAMES.ORA and try to reconfig your database service with TCP/IP protocol rather than IPX/SPX. You should see the protocol used and the address of your target "service"(those connect string at the bottom of your login screen).

I would suggest you to use Net8 Easy configuration to do so.

selvakum_at_tech.iupui.edu wrote:

> Hi,
>
> Currently, we have a standard NT server installation with TCP/IP and IPX/SPX
> protocol loaded. During the installation of Oracle Server 8.x on this box, it
> seems that the TNS listener automatically configured itself to communicate
> with all underlying protocols installed on this machine.
>
> Post this operation, the client has communicated an interest to remove the
> IPX/SPX protocol from machine. After trying to remove this protocol from
> 'Network Neighborhood'. The TNS listener service failed and when trying to
> open ANY oracle enterprise tool after entering the login and service
> credentials the error TNS listener failed dialog box appeared.
>
> Consequently, the ipx/spx protocol was readded to ensure oracle DBMS
> functionality. However, we still require that this protocol is removed. How
> do we do this so that the TNS listener ONLY communicates (or is bound) to the
> TCP/IP protocol.????
>
> We understand that the following files are associated with communications,
> and that is all we know.
>
> SQLNET.ORA
> TNSNAMES.ORA
> LISTENER.ORA
> NAMES.ORA
> CMAN.ORA
>
> Any help and direction on this matter is greatly appreciated.
>
> Regards
>
> Paul W.Ford & Selva Kumar
>
> --
>
> K.Selvakumar
> selvakk_at_metamor.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Dec 15 1998 - 08:21:05 CET