error: cannot connect to destination 
Author Message
 error: cannot connect to destination
Hello,
I have my oracle database in a remote box. When I try to log in
through sqlplus, I get the error message: cannot connect to
destination.
Is this is a tnsnames.ora issue?
Thanks for your help.

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 error: cannot connect to destination

hi,
quite sure.
check the tnsnames.ora in your database -%oraclehome%/network(or
net80)/admin

when you connect via sql plus with username/password the entry in the last
line must be the netservice name in the tnsnames.ora (= first entry in the
appropriate block).

e.g.

charly.chello.de =
   (description =
      (adress_list =
          (adress = (protocol = tcp) (host = compaq.chello.de) (port =
1521))
      )
     (connect_data =
          (service_name = oracle.via)
      )
   )

so when you log in via sql plus
the entry in the last line must be charly.chello.de

this is sometimes confusing.
when you don't have the right entry start the program net8 easy config.
there you can test your configuration.

hope this helps
gritinx
xl



Quote:
> Hello,
> I have my oracle database in a remote box. When I try to log in
> through sqlplus, I get the error message: cannot connect to
> destination.
> Is this is a tnsnames.ora issue?
> Thanks for your help.

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. TNS cannot connect to destination WHY?

2. Help: client gets error 12203 unable to connect to destination

3. error 12154. TNS: Unable to connect to destination

4. Oracle error message: TNS-12203 Unable to connect to destination

5. Cannot connect Status= 10003 DB error: 10003 Login incorrect, OS Error: -1

6. DTS: Using table from Source and table from Destination to create new table in Destination

7. SQL - Join one table in one destination to another table in another destination (DBF)

8. SQL SERVER ERROR 31 - Client cannot connect

9. Cannot connect to any SQL database (error 10061)

10. OLAP "Cannot Connect to Registry" error

11. Error: "Cannot Connect to Destination Database" during Scheduled Transfer

12. cannot connect error


 
Powered by phpBB® Forum Software