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

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