Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNS names errors
Look at the tnsnames.ora file (in /var/opt/oracle)
where all the database connections are defined
If you do not have an entry for the remote database
you are trying to access, you need to create one
Look at the file for example or some configured
connections. You can copy and pase from one of them
and change the host and databse names appropriately
HTH
Madhu Cherukuri
dwbeauregard_at_my-dejanews.com wrote in message
<6rd635$kg3$1_at_nnrp1.dejanews.com>...
>Hello,
>
>I'm trying to connect to a remote Oracle database (7.3.4.0.1 for Sun
Solaris)
>using sqlplus. I get the following error message:
>
>ERROR: ORA-12154: TNS:could not resolve service name
>
>
>Any ideas out there?
>
>
>Daryl Beauregard
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Aug 18 1998 - 20:19:21 CDT
![]() |
![]() |