Forum Stats

  • 3,838,691 Users
  • 2,262,394 Discussions
  • 7,900,733 Comments

Discussions

How To create TNSNAMES.ORA where server has 2 LAN Cards install

535287
535287 Member Posts: 1
Dear Friends,

I have a problem to connect node with server.

Server configuration :
OS --> Window XP is install
LAN Card --> 1 regular card
Other Card --> Ethernet Card for inter net.

Client configuration :
OS --> Window 98

On the server , i can connect oracle at server with regular TCP/IP protocol. But at node i m not able to connect oracle. IT IS GIVING ERROR TNS-ERROR not able to connect.

Please give me your valuable suggetions.
Email : [email protected]

Comments

  • Santosh Kumar
    Santosh Kumar Member Posts: 1,306
    Put ip-address of the server in host name like this

    fulprod=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.54)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = fulprod)
    )
    )

    try to ping using "tnsping fulprod". If it is successful then try to connect like
    sql>conn username/[email protected]
This discussion has been closed.