Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-12541: TNS:no listener
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