This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 现在有没有资深的ORACLE的DBA在论坛上，我需要帮助。ORACLE的监听会报错，是TNS-125000。TNS-0051。最后的错是说SOLARIS的资源不够。现在有没有资深的ORACLE的DBA在论坛上，我需要帮助。我的数据库是在SOLARIS8上的，现在的现象是我能在SOLATIS8的机器上登陆ORACLE，但是不能用ORACLE客户端登陆ORACLE。ORACLE的监听会报错，是TNS-125000。TNS-0051。最后的错是说SOLARIS的资源不够。我把SOLARIS有关ORACLE的参数都调很大了，还是没用。数据库总是在运行一段时间后出现这种情况。不知道该怎么解决了。内存2G。
-with2001(with2001);
2002-10-21
{349}
(#809292@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 ;
-with2001(with2001);
2002-10-21
(#809310@0)
-
I am not a DBA, but it seems something wrong with your tnsnames.ora on client end. Try this:
-cloud2001(卷云溶月);
2002-10-21
{940}
(#809316@0)
-
多谢。但是TNSNAME.ORA应该是对的。重新将服务器端的监听启动起来后，又能用一段时间，但是一会又不行了。
-with2001(with2001);
2002-10-21
(#809326@0)
-
It's beyond my ability, help you up, any DBA can help? I want to know too.
-cloud2001(卷云溶月);
2002-10-21
(#809351@0)
-
Need to know how many users are connected and how big is your database SGA
-kew888(西竹);
2002-10-21
(#809341@0)
-
SGA700多M。文件数8000多个
-with2001(with2001);
2002-10-21
(#809396@0)
-
show us your listener.log. include system error message.
-peidudu();
2002-10-21
(#809365@0)
-
LOG上就是那些错，一个一个连着出来的
-with2001(with2001);
2002-10-21
(#809391@0)
-
what's 资源不够
-peidudu();
2002-10-21
(#809416@0)
-
Solaris Error: 12: Not enough space
-with2001(with2001);
2002-10-21
(#809482@0)
-
check your operate system swap space first, actually the problem is in O/S .
-peidudu();
2002-10-21
(#809488@0)
-
Check the environment first
-kew888(西竹);
2002-10-21
{534}
(#809408@0)
-
查看一下，你有多少session数，如果超过参数processes（没有用MTS的话）增加processes数，如果超过500应考虑用MTS
-onewayticket(onewayticket);
2002-10-21
(#809440@0)
-
SESSION 才100多啊。设的有300多
-with2001(with2001);
2002-10-21
(#809459@0)
-
Go to metalink, search 'TNS-00510'...Here is the one piece which I grabed from there:
"I experienced a similer problem..All same messages.. but it was in HP UX, I increaed the OS limit of maximum files that can be opened at a time"
You probably are interesting in NOTE 171636.1 in Metalink.
-handd(大熊猫®);
2002-10-21
{259}
(#809465@0)
-
我的专项啊！！哈哈！我估计是你的SWAP 区不够，命令swap -l 把结果给我就可以了，或者直接新增加一个交换区
-arthurxu(ArthurXu OCP8,9i);
2002-10-21
(#809784@0)
-
我以前处理过几个类似的问题，是移动的１８６客户服务系统，ＨＰＵＸ
-arthurxu(ArthurXu OCP8,9i);
2002-10-21
(#809795@0)
-
不会啊，我的SWAP有4个G啊
-with2001(with2001);
2002-10-21
(#810404@0)
-
我觉得还是不够，你先加上２Ｇ看看，９０％能解决！
-arthurxu(ArthurXu OCP8,9i);
2002-10-21
(#810665@0)
-
前提－－是你的kernel param都按照Oracle文档进行配置的！！
-arthurxu(ArthurXu OCP8,9i);
2002-10-21
(#810730@0)
-
但是用TOP看，内存还有500多M，SWAP有2G剩余
-with2001(with2001);
2002-10-22
(#810958@0)
-
It's due to the enabled DCD.In your SQLNET.ora (server side), check if u have EXPIRE_TIME=xx, if so, comment it out then should be OK.
This option is useful to let the Oracle's PMON to clean up orphan processes which are abandoned, like powering down client PC without exiting from Oracle. However, this nice functionality comes with some cons which introduce lots extra CPU cycles hence may exhaust CPU resource. MTS may make it worse since while some memory consumption down, CPU becomes more busy on handling dispatchers.
-unionville(Unionville);
2002-10-21
{499}
(#810778@0)
-
Don't worry. The problem due to the total connection processes exceeded maximum process number allowed by OS. (see inside)For Sun, edit /etc/system file:
increase vale of maximum process number by
set max_nprocs=xxx
then reboot server.
-wanld(wanld);
2002-10-22
{117}
(#811452@0)