This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

Check the environment first

kew888(西竹)

I think you can try one of these options
1. Check your processes parameter value in init.ora, if this value is high enough check the AIX/ OS parameters, the max number of processes / user allowed, if this is small increase the processes value
2.increase the swap space may be the resources are not available to allow connections
3.if otrace is enabled disable that.
Stop the Oracle database.
b. Go to the $ORACLE_HOME/otrace/admin directory.
c. Delete all files with a '.dat' extension.
d. Restart the Oracle database.

(#809408@0)
Last Updated: 2002-10-21
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

工作学习 / IT技术讨论 / 现在有没有资深的ORACLE的DBA在论坛上，我需要帮助。ORACLE的监听会报错，是TNS-125000。TNS-0051。最后的错是说SOLARIS的资源不够。 -with2001(with2001); 2002-10-21 {349} (#809292@0)
现在有没有资深的ORACLE的DBA在论坛上，我需要帮助。我的数据库是在SOLARIS8上的，现在的现象是我能在SOLATIS8的机器上登陆ORACLE，但是不能用ORACLE客户端登陆ORACLE。ORACLE的监听会报错，是TNS-125000。TNS-0051。最后的错是说SOLARIS的资源不够。我把SOLARIS有关ORACLE的参数都调很大了，还是没用。数据库总是在运行一段时间后出现这种情况。不知道该怎么解决了。内存2G。

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)
1. open command prompt and type the command: tnsping [your host string], if it is not OK then
2. use net assistant to do the configuration or change your tnsnames.ora directly if you can.

BTW, the error messge should be TNS-12500? I could not find TNS-125000.

TNS-12500 TNS:listener failed to start a dedicated server process

Cause: The process of starting up a dedicated server process failed. The executable could not be found or the environment may be set up incorrectly.

Action: Turn on tracing at the ADMIN level and re-execute the operation. Verify that the Oracle Server executable is present and has execute permissions enabled. Ensure that the Oracle environment is specified correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being called may not be installed on the local hard drive. Check that the correct Protocol Adapter are successfully linked. If the error persists, contact Oracle Customer Support.

多谢。但是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)
I think you can try one of these options
1. Check your processes parameter value in init.ora, if this value is high enough check the AIX/ OS parameters, the max number of processes / user allowed, if this is small increase the processes value
2.increase the swap space may be the resources are not available to allow connections
3.if otrace is enabled disable that.
Stop the Oracle database.
b. Go to the $ORACLE_HOME/otrace/admin directory.
c. Delete all files with a '.dat' extension.
d. Restart the Oracle database.
查看一下，你有多少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'... -handd(大熊猫®); 2002-10-21 {259} (#809465@0)
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.
我的专项啊！！哈哈！我估计是你的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. -unionville(Unionville); 2002-10-21 {499} (#810778@0)
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.
Don't worry. The problem due to the total connection processes exceeded maximum process number allowed by OS. (see inside) -wanld(wanld); 2002-10-22 {117} (#811452@0)
For Sun, edit /etc/system file:
increase vale of maximum process number by
set max_nprocs=xxx
then reboot server.

@Florida

Check the environment first

Replies, comments and Discussions:

More Topics