TNS-12518 Can Not Connect To RAC 11gR2 Database

(Doc ID 1088754.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Net Services - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 03-May-2013***

Symptoms


Just installed and configured 11gR2 Grid Infrastructure and database, sqlplus can not connect to the new 11.2 database using SCAN connection.

$ sqlplus test/*******@rac-scan:2010/dbrac

SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 24 17:40:48 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:
ORA-12537: TNS:connection closed

Enter user-name:



From the listener.log:

24-MAR-2010 17:40:51 * (CONNECT_DATA=(SERVICE_NAME=dbrac)(CID=(PROGRAM=sqlplus)(HOST=myracdbhost)(USER=oracle))(SERVER=dedicated)(INSTANCE_NAME=t1rac2)) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.XX.XX.XX)(PORT=13788)) * establish * dbrac * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
  TNS-12560: TNS:protocol adapter error
   TNS-00517: Lost contact
   Linux Error: 32: Broken pipe

 

Changes

New installation.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms