ORA-12545: Connect failed because target host or object does not exist
873969Jul 7 2011 — edited Jul 8 2011HI,
I'm trying to connect to a database using SQL*PLUS.
I've done the following:
1) Install Oracle Instant Client and Oracle sqlplus
2) Configure the tnsnames.ora in my home with the following data:
MYNEWCONECTION=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =XX.XXX.XX.189)(PORT = 1521))
)
(CONNECT_DATA =
(SID = mydb)
(SERVER = DEDICATED)
)
)
3) I've exported the $TNS_ADMIN variable as export TNS_ADMIN = ~
And when i try to connect using the sqlplus command. I enter the password and username and i get the next error:
ORA-12545: Connect failed because target host or object does not exist
I've checked the conection doing ping, so i don't know where it can be the error.
Thnks