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

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-garry_at_home.com> wrote in message news: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
>