后台服务启动报Connect database failed: ORA-12520的解决方法
启动后台服务的时候,报下列错误,
Connect database failed: ORA-12520: TNS:listener could not find available handler for requested type of server
分析:检查了DB的连接池,发现连接够用。检查了tnsnames.ora文件
ORA11 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.139.135.205)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora11)
)
)
发现是由于多了(SERVER = DEDICATED)造成的。后来找了很多这方面的解决方法,如将(SERVICE_NAME = ora11)修改成(SID = ora11)等。每个人环境不同,造成的原因也许不一样,上面的解决方法,仅供参考!