Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-12154 Errror PLease help

ORA-12154 Errror PLease help

From: nth_prime <jrojas_at_hsc.utah.edu>
Date: 26 Mar 2003 15:13:01 -0800
Message-ID: <72435b0f.0303261513.3499c2bb@posting.google.com>


I am getting this error
ORA-12154 TNS : Could resolve service name

Am I missing somthing?????? SQL.net needs to be configured?

Here is my TNSNAME.ora

GCRCDEV =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GCRCDEV)

    )
  )



Here is my listener.ora

LISTENER =
  (DESCRIPTION_LIST =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = GCRCDEV.med.utah.edu)
(ORACLE_HOME = /odata/oracle/production/9.2.0.1.0)
(SID_NAME = GCRCDEV)

    )
  ) Received on Wed Mar 26 2003 - 17:13:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US