Re: newbietrying to overcome ORA-12514 using Listener

In our last gripping episode connorsjohnny_at_aol.com (ConnorsJohnny) wrote:
> I am trying to understand how to initialise and employ a listener on
 my
> standalone
> RH6.2 linux distribution. I want to initiated a shared server
 connection as
> opposed
> to a dedicated one.
> If this is possible to achieve, am I correct in starting the listener
> and issuing the command "sqlplus system/manager_at_oralin" (having
 previously
> started the database).
>
> Because on entering this, I receive the error
> "ORA-12514: TNS LISTENER could not resolve SERVICE_NAME
> given in connect descriptor"
>
> In the tnsnames.ora file "SERVICE_NAME=oralin.localhost.com" is
 present.
>
> Is this correct ? Or should I be checking other things to ensure
 correctness.
>
> Thanks in advance
>

No, it is not. The SERVICE_NAME should not be a DNS name but simply a name you want to call the service. Change the entry to 'oralin' and you should be fine.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/