I have a strange behavior for remote sqlplus login to Oracle 11.2 that I cannot explain:
1) I have an Oracle 11.2 server running on a virtual host, say host1
2) I set up another VM, say host2 (CentOS 6.5 x86_64) with oracle-instantclient 126.96.36.199 64bit, built up from a minimal install ISO
3) I also downloaded a CentOS 6.5 x86_64 VM image from the net (a desktop install with everything already installed), say host3, on which I installed the same Oracle instantclient
I use the same environment and tnsnames.ora file on both host2 and host3, something like:
MONSTER= (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521)) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=CRM)))
On host2, I cannot get rid of the ORA-01017 error:
host2> sqlplus sys/<passwd>@monster as sysdba SQL*Plus: Release 188.8.131.52.0 Production on Fri Aug 1 12:09:51 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied
BUT, on host3, everything is OK:
host3> sqlplus sys/<passwd>@monster as sysdba SQL*Plus: Release 184.108.40.206.0 Production on Fri Aug 1 06:21:59 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release ... SQL>
Has someone an idea why connecting from one host is OK while connecting from the other one is KO?
NB: Needless to say this is not an issue of case sensitivity, or bad orapwd, or remote_login_passwordfile not set to EXCLUSIVE, since it works from host3.