3 Replies Latest reply: Mar 14, 2013 1:55 PM by sb92075 RSS

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

    HenryMH
      Hi all,

      Need help?

      My database keep repeating this error every 1 to 2 day:

      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
      32-bit Windows Error: 8: Exec format error

      This happen after rebuild database due to error TNS-12500: TNS:listener failed to start a dedicated server process

      Database version is 9.2.0.1 version Enterprise Edition, running on Windows 2003 Enterprise Edition SR 2 32 bits OS.

      It will runing and only llistener will have give this error.
        • 1. Re: TNS-12500: TNS:listener failed to start a dedicated server process - Repeat
          sb92075
          905252 wrote:
          Hi all,

          Need help?

          My database keep repeating this error every 1 to 2 day:

          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
          32-bit Windows Error: 8: Exec format error

          This happen after rebuild database due to error TNS-12500: TNS:listener failed to start a dedicated server process

          Database version is 9.2.0.1 version Enterprise Edition, running on Windows 2003 Enterprise Edition SR 2 32 bits OS.

          It will runing and only llistener will have give this error.
          do as below
          SQL> show parameter processes
          
          NAME                         TYPE      VALUE
          ------------------------------------ ----------- ------------------------------
          aq_tm_processes                integer      0
          db_writer_processes               integer      1
          gcs_server_processes               integer      0
          global_txn_processes               integer      1
          job_queue_processes               integer      1000
          log_archive_max_processes          integer      4
          processes                    integer      150
          SQL> select sessions_highwater from v$license;
          
          SESSIONS_HIGHWATER
          ------------------
                     9
          what clues exist within alert_SID.log file?
          • 2. Re: TNS-12500: TNS:listener failed to start a dedicated server process - Repeat
            HenryMH
            Hi sb92075,

            Shared server database setting solve the problem.

            Thanks for your help.

            Edited by: 905252 on Mar 14, 2013 11:33 AM
            • 3. Re: TNS-12500: TNS:listener failed to start a dedicated server process - Repeat
              sb92075
              905252 wrote:
              Hi sb92075,

              Shared server database setting solve the problem.
              TEMPORARILY
              You were hitting your head on the ceiling & all you did was lower the floor.