Database - RAC/Scalability (MOSC)

MOSC Banner

ORA-12537: TNS:connection closed

edited Jul 12, 2017 5:00AM in Database - RAC/Scalability (MOSC) 1 commentAnswered

Two node RAC,Version 11.2.0.4.0

[oracle@CRMDB ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jun 24 10:57:57 2017

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

SQL> conn system/xxxxx@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db1-vip)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=CRMDB)(INSTANCE_NAME=CRMDB1)))

Connected.

SQL> conn system/xxxxx@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db2-vip)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=CRMDB)(INSTANCE_NAME=CRMDB2)))

ERROR:

ORA-12537: TNS:connection closed

SQL>

listener log:

24-JUN-2017 11:01:42 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=crmdb2)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0

24-JUN-2017 11:01:50 * (CONNECT_DATA=(SERVICE_NAME=CRMDB)(INSTANCE_NAME=CRMDB2)(CID=(PROGRAM=sqlplus)(HOST=CRMDB)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=66.0.191.95)(PORT=62140)) * establish * CRMDB * 12518

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center