Re: ORA-12541 TNS:no listener

Hey Jeff,

   I tried this but am still getting same error. Did I do it wrong? # D:\ORANT\NETWORK\ADMIN\LISTENER.ORA Configuration File:D:\orant\network\admin\listener.ora # Generated by Oracle Net8 Assistant

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =


        (ADDRESS = (PROTOCOL = TCP)(HOST = 128.32.000.00)(PORT = 1521))
      )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\orant)
(PROGRAM = extproc)

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME=spare03.ppcs)
(ORACLE_HOME= D:\orant)
(SID_NAME=spare03)

     )
   )

In article <3A11FFEB.BC8EB7D8_at_tatca.tc.faa.gov>,   Jeff Jackson <jeff_at_tatca.tc.faa.gov> wrote: > You need to add your database instance to the list of service names  in the

[Quoted] > SID_LIST_LISTENER section such as the following: ( I am on UNIX )
> SID_LIST_LISTENER =
>   (SID_LIST =
>     (SID_DESC =
>       (GLOBAL_DBNAME=tfmdw02.ctas0)
>       (ORACLE_HOME=/oradw01/svr/oracle/product/8.1.5)
>       (SID_NAME=tfmdw02) )
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 15 2000 - 22:54:25 CET