2 u012348400 u012348400 于 2013.10.08 14:05 提问

oracle 11g 64位plsql登陆问题

我用myeclipse创建了web应用并且用jdbc驱动创建数据库连接,兵配置好监听器和tnsname,当我在doc界界面启动数据库和监听器后一切正常,tnsping 服务名也可以通过,但是登陆plsql出现登陆超时错误,sqlplus 登录名/密码@服务名出现TNS:监听程序无法分发客户机连接。在myeclipse上想测试连接
Connection conn=DButils.getInstance().getconn();
System.out.println(conn);
控制台输出错误java.sql.SQLException:Listener refused the connection with the following error:ORA-12518,TNS:litener could not hand off client connection
。。。。null.

下面是我的监听器和tnsname配置:

listener.ora Network Configuration File: F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:F:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = orcl)
(ENVS = "EXTPROC_DLLS=ONLY:F:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 27.151.20.130)(PORT = 1521))
)
)

ADR_BASE_LISTENER = F:\app\Administrator

tnsnames.ora Network Configuration File: F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora

Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 27.151.20.130)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

我查看session值session——cached_cuesors50,sesssion_max_open_files 10,sessions 248,
parameter值sga_max_size 1600M,

不知道是什么原因,想做一个小项目在数据库这边卡住了心碎,希望大家能帮忙看看。

2个回答

xiongjutao
xiongjutao   2014.01.09 14:20
已采纳

这个首先你要看服务器本机能不能登录上数据库,没问题就把本机的TNS配置复制到客户机的PL/SQL去试下,不行重新配置一下客户机的监听,还不行PING一下服务器的1521端口,这个要看具体报什么错才能给你解决

qq_28202493
qq_28202493   2016.06.02 18:17

你好,我也遇到这个问题了,你最后是怎么解决的,我从PLSQL登录都没有问题,就是从myeclipse的db上连接测试提示ora-12518错误

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!