Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-12541: TNS:no listener

ORA-12541: TNS:no listener

From: Gyruss <gyruss_at_hushmail.com>
Date: Fri, 8 Oct 2004 14:59:44 +1000
Message-ID: <41661ec2_1@news.iprimus.com.au>


Dear all,

I have no trouble connecting to orcl on a windows 2000 box if I don't specify a TNS connection string, whenever I do though, I get the error:

ORA-12541: TNS:no listener

The service is running and the database name is defined in tnsnames.ora.

What gives?

Cheers,

David

# tnsnames.ora Network Configuration File: G:\apps\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = gyruss)(PORT = 1521))     (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  ) Received on Thu Oct 07 2004 - 23:59:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US