Re: Connecting to Oracle Instances - N00B

Thanks for the help. I went into the tnsnames.ora file. this is what I have. I had to change the host = because the ip was wrong. Can I just make that localhost? Is there anything else wrong with this because when I tried to test the connection via ODBC drivers, I get the TNS:no listener error. There are two instances listed in the tnsnames file. Do I need to take one of the instances out since they are both referencing the same port#?

Thanks

SID =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.x.xxx)(PORT = 1521))
(CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = sid)