Re: could not connect

From: Dino Hsu <dino1.nospam_at_ms1.hinet.net>
Date: Tue, 16 Oct 2001 22:33:46 +0800
Message-ID: <dufostsmus7enmn5c9q1feh4d0t42d6dhc@4ax.com>

Dear Andreas,

<quote begin>

ORA-12505 TNS:Listener could not resolve SID given in connect descriptor
<quote end>

Please post the error message in addition to error number next time, it saves others the efforts of searching the doc. You didn't mention what the error number of the second problem is, either, so I can only deal with the first one here.

Firstly look at server side listener.ora (under c:\orant\net80\admin) and then the SID_LIST_LISTNER part for the section with the SID you are configuring:

SID_LIST_LISTENER =
  (SID_LIST =
    ...
    (SID_DESC =

      (ORACLE_HOME = C:\orant)
      (SID_NAME = <SID>)

    )
    ...
  )

If you edit this file, remember to stop and start the listener service to make the change effective.

Secondly look at client side tnsnames.ora (under c:\orawin95\net80\admin, the file that easy configuration edits) and then the section you are configuring:

<connect_string>.WORLD =

(DESCRIPTION =

      (ADDRESS_LIST = 
          (ADDRESS = (PROTOCOL=TCP)(Host=<host_name>)(Port=1521))
       )
       (CONNECT_DATA=(SID=<SID>))

)

Make sure the <SID> in listener.ora matches that in tnsnames.ora, test with, say, SQL*Plus again (any change is immediately effective once saved).

HTH,
Dino

On Tue, 16 Oct 2001 06:24:37 GMT, anlommel_at_gmx.de (Andreas Lommel) wrote:

>I have Oracle 8.0.5. on NT 4 Server. First I created a second
>instance. Then I changed the IP-address. Then I installed a second
>database. The first problem: I could not connect with net8easy with
>the first instance- ora-12505. I changed the IP back. Now I also could
>not connet with my second instance.
>Who can help ???

Received on Tue Oct 16 2001 - 09:33:46 CDT

Re: could not connect - HELP