Re: Oracle Client for linux

Vegard Munthe wrote:
[snip]
>
> ORA-12505: TNS:listener could not resolve SID given in connect
> descriptor

Can you post relevant sectors of tnsnames.ora?

Basically it should look something like this:

yourdatabase =
  (DESCRIPTION =

        (ADDRESS = 
          (PROTOCOL = TCP)
          (Host = 139.117.8.26)
          (Port = 1521)
        )
      (CONNECT_DATA = 
        (SID = yoursid)
           (GLOBAL_NAME = yourdatabase.world)
      )

Replace yourdatabase, yoursid as needed.

You need to know the SID from the NT machine where Oracle is running. You can probably just grab the tnsnames.ora from the NT box if you have access to it.
It will normally be in <ORACLE_HOME>\net80\Admin\tnsnames.ora where ORACLE_HOME is something like C:\orant.

Hope this helps,
Haakon

--
hts_at_core.no
Core Technology AS
Oslo, Norway