×

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

@Florida

I am not a DBA, but it seems something wrong with your tnsnames.ora on client end. Try this:

cloud2001(卷云溶月)
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.
(#809316@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.

More Topics

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论