Re: [Oracle 10g 10.1.0.2] TNS:listener does not currently know of service requested in connect

From: mike henkins <dd_at_nospam.com>
Date: Sat, 30 Jul 2005 16:18:57 +0200
Message-ID: <42eb8c51$0$3132$8fcfb975@news.wanadoo.fr>

Thanks. I modified it like your example:

# listener.ora Network Configuration File:
c:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

     (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ECLIPSE)(PORT = 1521))
     )
     (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = cambridg))
     )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = cambridg)
      (ORACLE_HOME = c:\oracle\product\10.1.0\Db_1)
      (SID_NAME = cambridg)

    )
  )

I still get the same boring and annoying error : C:\Documents and Settings\bob>sqlplus scott/tiger_at_localhost:1521:cambridg

SQL*Plus: Release 10.1.0.2.0 - Production on Sam. Juil. 30 16:18:22 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Any suggestion please ?

"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> a écrit dans le message de news: Xns96A344F37131DSunnySD_at_68.6.19.6...

> "mike henkins" <dd_at_nospam.com> wrote in
> news:42eb824a$0$3122$8fcfb975_at_news.wanadoo.fr:
>
> > Well,
> >
> > I tried to modify it like this, and i get the same error:
>
> Plz do NOT top post.
>
> Below is from a working production DB system.
> listener =
>   (DESCRIPTION_LIST =
>     (DESCRIPTION =
>       (ADDRESS_LIST =
>         (ADDRESS = (PROTOCOL = TCP)(HOST = cdb1.example.com)(PORT = 1521))
>       )
>       (ADDRESS_LIST =
>         (ADDRESS = (PROTOCOL = IPC)(KEY = cdb1))
>       )
>     )
>   )
>
> sid_list_listener =
>   (SID_LIST =
>     (SID_DESC =
>       (GLOBAL_DBNAME = cdb1)
>       (ORACLE_HOME = /b/oracle/product/9.2.0)
>       (SID_NAME = cdb1)
>     )
>   )
>
> Do you notice any differences between this & yours?

Received on Sat Jul 30 2005 - 09:18:57 CDT