Re: TNS 12514 error in RedHat???

Jim Lewis <pojpl_at_ais.ucla.edu> wrote in message news:8btjqi$io2$1_at_carroll.library.ucla.edu...
> RedHat 6.1
> Oracle8i 8.1.5
>
> Error: TNS12514 : listener could not resolve SERVICE_NAME given in
> connect descriptor
>
> Cause: The SERVICE_NAME in the CONNECT_DATA was not found in the
> listener's tables.
>
> Action: Check to make sure that the SERVICE_NAME specified is
> correct.
>
> Well, I've done everything I can to understand this and to properly
> set the SERVICE_NAME to the global database name of the database we
> created on our RedHat 6.1 machine.
>
> On the RedHat6.1/Oracle8i server:
>
> Running lsnrctl status shows: "the listener supports no services"
>
> tnsping <listener name> gives "OK (10msec)"
>
> But still I get the 12514 error in the RedHat6.1/Oracle8i server
> listener.log file when I try to connect from a client machine.
>
> What am i doing wrong? This is driving me nuts!
>
>
>
>

First of all, your listener.ora is definitely incorrect, as it supports NO services, it should support at least one. Did you configure it? Using Net Easy will not config the listener, using the Net8 Assistant will. Normally you'll need to setup an address list in the listener, one address for IPC, and one address for TCP. Also you'll need to setup a list of supported sids.
Secondly, a tnsping only checks the existence of the listener, it doesn't try to connect.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Mar 29 2000 - 00:00:00 CST