Friends,
I am experiencing this strange issue in 11G R2. When I use tnsalias and connect using sqlplus username/password@TNS it shows ORA-01017: invalid username/password . But the same works with ORACLE_SID. See below.
-bash-3.00$ uname -a
SunOS ibs-ash-sr147 5.10 Generic_144489-06 i86pc i386 i86pc
-bash-3.00$ env | grep ORACLE
ORACLE_SID=DB1
ORACLE_BASE=/project/oracle/orabase
ORACLE_HOME=/project/oracle/orabase/product/11.2.0/dbhome_1
-bash-3.00$ tnsping DB
TNS Ping Utility for Solaris: Version 11.2.0.1.0 - Production on 17-JUN-2011 12:23:12
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/project/oracle/orabase/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = crs-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB)))
OK (0 msec)
-bash-3.00$ sqlplus IRES_USER@DB
SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 17 12:30:22 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show parameter sec_case_sensitive_logon
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
-bash-3.00$ sqlplus IRES_USER/U9$bvs#ir@DB
SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 17 12:34:30 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: ^C
My understanding is that both connections use a TNS alias, but second is not working. Any help is appreciated.
Thanks in Advance,
SSN
Edited by: SSNair on Jun 17, 2011 5:43 AM