Hello
Env: Oracle 11gR2 Client (11.2.0.1) on Oracle Linux 5.8 64bit
DB server: Oracle 11gR2 (11.2.0.3.6) on Oracle Linux 6.2 64bit
I installed Oracle 11gR2 client on a server and created the tnsnames.ora with required entry.
When I try to connect to the databases on the remote database server using following two ways, one of them give me "ORA-12545" error. Not sure why.
[oracle@server ~]$ sqlplus scott/tiger@proddb01
SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 10 12:24:58 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@server ~]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 10 12:25:04 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: scott
Enter password:
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Enter user-name:
Here is my env:
[oracle@server ~]$ echo $ORACLE_SID
PRODRD01
[oracle@server ~]$ echo $ORACLE_HOME
/opt/oracle/app/product/11.2.0/client_1
[oracle@server ~]$
TNS entry is:
PRODRD01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server.whatever.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PRODRD01)
)
)
I tried replacing the Host name with IP address, I still got the same error. The Database Server Host name and IP entry does not exist in the "/etc/hosts" file. Could that be the cause? I cannot modify the "/etc/hosts" file and I could not convince the sys-admin to add the DB Server Host name and IP entry to this file.
Any clues please?
Best regards