Recently I have installed a client on a local machine and I was trying to connect the database. I know I have everything right but still I was getting this error.
C:\Users\localhost>tnsping orcl
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 19-NOV-2
014 15:22:45
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\app\oracle\product\11.2.0\client_1\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
C:\Users\localhost>
I went back to check the Tnsnames.ora file to see if there is anything wrong in it. But no luck I couldn't find anything.
Sample Tnsnames.ora on my machine.
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
)
)
Wondered what could have gone wrong.
Then figured that there was a simple mistake that I made. There was a empty space in front of the orcl. I deleted the empty space and everything worked.
No comments:
Post a Comment