PLSQL和@服务名方式都报如题错误
listener.log报
01-DEC-2011 13:18:41 * (CONNECT_DATA=(SERVICE_NAME=nms)(CID=(PROGRAM=sqlplus)(HOST=sdnms02)(USER=oracle1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.104.4)(PORT=62920)) * establish * nms * 1250
0
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
HPUX Error: 12: Not enough space
01-DEC-2011 13:19:12 * (CONNECT_DATA=(SID=nms)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.104.4)(PORT=62948)) * establish * nms * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
HPUX Error: 12: Not enough space
HPUX Error: 12再加上应用程序报：ERROR=(BUF='HPUX Error: 12: Not enough space'))
看来是关于内存的原因，但是主机内存8G，给ORACLE才不到1G。估计是本机跑有其它程序造成。
ps -ef|grep Xms发现N多占内存的如下程序：/ulms/java1.5/bin/PA_RISC2.0/NSync -Xms256m -Xmx512m -Dus
停掉之后再试ORACLE连接正常。。。。
阅读(5884) | 评论(0) | 转发(0) |
