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

If this is the literal command you typed it is incorrect. The correct command (based upon your tnsnames.ora) is tnsping orcl
Did you issue that command?
Please always be *exact*!!!
03505 means <tnsalias> isn't in your tnsnames.ora Either your tnsnames.ora is incorrect, or the tnsping command is using a *different* incorrect tnsnames.ora

The original message means that the init.ora parameter service_name isn't orcl, consequently the listener doesn't listen for the service_name orcl, but for something else you didn't disclose.

Please *always* read the Oracle error messages manual on http://tahiti.oracle.com
and in this case the troubleshooting chapter of the Net administrators manual.
*Almost all* frequent errors are discussed there.

--
Sybrand Bakker
Senior Oracle DBA


On Oct 5, 5:22 am, "old dirtbeard" <dirtbe..._at_pacbell.net> wrote:


> Dear Joe,

>

> Thank you very much for your reply. I did some more probing and ran "tnsping

> tns_alias", and get:

>

> (C) Copyright 1985-2003 Microsoft Corp.

>

> N:\>tnsping tns_alias

>

> TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on

> 04-OCT-2

> 006 20:07:16

>

> Copyright (c) 1997, 2005, Oracle.  All rights reserved.

>

> Used parameter files:

> E:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

>

> TNS-03505: Failed to resolve name

>

> and it cannot find the alias. I looked in the tnsnames file and it seems

> fine (see below). Is there something I need to do to get Oracle to create

> the tns_alias? Sorry to be a dope here...thank you, doug:

>

> # tnsnames.ora Network Configuration File:

> E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

> # Generated by Oracle configuration tools.

>

> ORCL =

>   (DESCRIPTION =

>     (ADDRESS = (PROTOCOL = TCP)(HOST = IOMORACLE.marshall.usc.edu)(PORT =

> 1521))

>     (CONNECT_DATA =

>       (SERVER = DEDICATED)

>       (SERVICE_NAME = orcl)

>     )

>   )

>

> EXTPROC_CONNECTION_DATA =

>   (DESCRIPTION =

>     (ADDRESS_LIST =

>       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

>     )

>     (CONNECT_DATA =

>       (SID = PLSExtProc)

>       (PRESENTATION = RO)

>     )

>   )

>

> "joel garry" <joel-ga..._at_home.com> wrote in messagenews:1160002291.112217.214440_at_i42g2000cwa.googlegroups.com...

>

>

>

>

>

> > Douglas Shook wrote:

> >> Hi all,

>

> >> I just installed Oracle 10g on a server and can connect to it

> >> locally from the server using sql*plus, can create tablespaces,

> >> etc., but get the following error every time I try to connect to

> >> it remotely:

>

> >> ORA-12514:TNS:listener does not currently know of service

> >> requested in connect descriptor.

>

> >> The database started and is up and running. Using the Oracle

> >> Administration Assistant, I set the .connect database. to ORCL. I

> >> have Googled this error and cannot seem to find anything that

> >> works. Any ideas what I should try or where to look? Thank you in

> >> advance.

>

> >>From a command line, try:  lsnrctl status

> > You should see what you need to define in your tnsnames.ora or however

> > you are defining the connect string.  Be sure the host and port are

> > correct.

>

> > jg

> > --

> > @home.com is bogus.

> > Come on, get the AG's name right.

> >http://www.infoworld.com/article/06/10/04/HNdunnindict_1.html- Hide quoted text -- Show quoted text -