jrojas_at_hsc.utah.edu said...
> 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)
> )
> )
>
One thing that always seems to snag people is having a default domain
specified in sqlnet.ora (such as .world). If you have that line, comment
it out and see what happens. Doesn't seem to be any glaring errors in
your other .ora files ... assuming you are getting the ORA-12154 error
while trying to connect on your localhost.
--
/Karsten
DBA > retired > DBA
Received on Wed Mar 26 2003 - 18:03:23 CST
