Forum Stats

  • 3,838,691 Users
  • 2,262,394 Discussions


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

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]


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

    (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))
    (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.