Hello Fellows,
I am trying to connect to a RAC database using sqlplus,scan-name,post and services within server as below and it is working fine :
*********************************************************************** Working **********************************************************************************************************************************************************************************
[oracle@fed3dbadm02 ~]$ sqlplus cisadmprod/cisadmprod@//fed3-scan:1521/dbm01
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jun 20 17:53:30 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Tue Jun 20 2017 17:49:12 +08:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL>
[oracle@fed3dbadm01 admin]$ sqlplus 'cisadmprod/cisadmprod@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=fed3-scan)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dbm01)))'
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jun 20 21:13:58 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Tue Jun 20 2017 17:54:50 +08:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL>
**************************************************************************************************************************************************************************************************************************************************
However if try the same connection method from a client windows machine i am getting the errors as below.
*******************************************************************************************************Not Working ***********************************************************************************************************************************************************************
C:\Users\CGSurendra>sqlplus cisadmprod/cisadmprod@//fed3dbadm02:1521/dbm01
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 20 17:54:01 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
C:\Users\CGSurendra>
C:\Users\CGSurendra>sqlplus 'cisadmprod/cisadmprod@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=fed3-scan)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dbm01)))'
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 20 21:14:43 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Can someone please suggest on resolving the issue.
Thanks
Surendra.