因系统内存使用率过高,导致客户端无法正常连接数据库(在服务器上sqlplus / as sysdba可以登录,但sqlplus a/a@orcl as sysdba方式不可以登录)
现象如下:
C:\Users\Administrator>sqlplus system/oracle@orcl
SQL*Plus: Release 11.2.0.3.0 Production on 星期三 6月 15 15:21:59 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12518: TNS: 监听程序无法分发客户机连接
请输入用户名:
Tnsname.ora文件配置如下:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-MIRBE4NEBAU)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
C:\Users\Administrator>tnsping orcl
TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on