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

See below

"sybrandb" <sybrandb_at_gmail.com> schreef in bericht news:1160031427.540331.86310_at_k70g2000cwa.googlegroups.com...
> 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 -
>

(Please don't top post....)

Douglas,

looking at the files and commands you show here, it looks like you're checking the TNSNAMES.ORA at the server side, but if you want a remote connection, check the TNSNAMES at the client side! I think you're checking the wrong files because of the used parameter file:
>> Used parameter files:
>> E:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
This looks like a db configuration, not a client configuration.

Maybe I'm mistaken here and do you use an Oracle Home like this at the client....

Try this at the client:
TNSPING ORCL
If it does not work, check tnsnames at the client to see if there is an entry for orcl.
If there is, try changing the entry
>> ORCL =
>> (DESCRIPTION =
in
ORCL, ORCL.WORLD =
and try to tnsping ORCL.WORLD

If this works, the entry names.default_domain in sqlnet.ora is bugging you.

About 'other TNSNAMES.ORA' files: if you want to be sure which TNSNAMES.ORA is used, create a (system) environment variable TNS_ADMIN (at the client) pointing at your client <ORACLE_HOME>\network\admin directory. If you TNSPING from a dos-box, open a new box after setting the environment variable.

Frank van Bortel wrote an article in his blog at http://vanbortel.blogspot.com/ (look for network blues) explaining all about tnsnames etc.

Courtesy to Frank van Bortel,

Robbert van der Hoorn
OSA it BV
The Netherlands Received on Thu Oct 05 2006 - 03:04:42 CDT