我用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,
不知道是什么原因,想做一个小项目在数据库这边卡住了心碎,希望大家能帮忙看看。