Re: Problems with Listener on Oracle 8 NT

From: Keith Boulton <boulke_at_globalnet.co.nospamuk>
Date: Wed, 26 Aug 1998 17:04:44 GMT
Message-ID: <35e43da5.37358618@news.globalnet.co.uk>

On Wed, 26 Aug 1998 12:33:29 +0100, "Pascal Delaplace" <delaplac_at_iway.fr> wrote:

>Hello,
>
>I have a problems with Listener on Oracle 8 NT, I have created a new
>database with the oracle database assistant, after I want create an alias on
>my new database.
>I can create a alias in bequeath (local database access) but i can't create
>an alias in tcp protocole, the connexion test failed and say that :
>ORA-12505: TNS: listener could not resolve SID given in connect descriptor.

Possibly you need to update listener.ora in <oracle home>/net8/admin so the listener knows it should listen for the database SID e.g.:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = DES)
      (SID_NAME = DES)

    )
 ...
  ) Received on Wed Aug 26 1998 - 12:04:44 CDT