3 Replies Latest reply on Sep 17, 2013 2:14 AM by sb92075

    数据库报ora-12519错误

    1040961

      数据库环境:linux-64位-oracle10.2.0.5.0,中间层是tomcat。

      只要连接就报这个错误,把session与process由原来的150调整1100依然还报这个错误。但通过在主机上sqlplus "/as sysdba"登录上去。select count(*) from v$session,记录数据只有20多个记录。调整后,重新启动机器也主机,依然没有效果。把中间层停了,依然还报这个错。

        • 1. Re: 数据库报ora-12519错误
          sb92075

          b8f83154-8ed5-4398-8621-c24eb8b617a4 wrote:

           

          数据库环境:linux-64位-oracle10.2.0.5.0,中间层是tomcat。

          只要连接就报这个错误,把session与process由原来的150调整1100依然还报这个错误。但通过在主机上sqlplus "/as sysdba"登录上去。select count(*) from v$session,记录数据只有20多个记录。调整后,重新启动机器也主机,依然没有效果。把中间层停了,依然还报这个错。

           

          COPY & PASTE what you did (SQL statements) & how Oracle responded

           

          [oracle@localhost ~]$ oerr ora 12519

          12519, 00000, "TNS:no appropriate service handler found"

          // *Cause: The listener could not find any available service handlers that

          // are appropriate for the client connection.

          // *Action: Run "lsnrctl services" to ensure that the instance(s) have

          // registered with the listener, and are accepting connections.

          [oracle@localhost ~]$

           

          How do I ask a question on the forums?

          https://forums.oracle.com/message/9362002#9362002

          1 person found this helpful
          • 2. Re: 数据库报ora-12519错误
            1040961

            监听状态为unkown

            • 3. Re: 数据库报ora-12519错误
              sb92075

              b8f83154-8ed5-4398-8621-c24eb8b617a4 wrote:

               

              监听状态为unkown

               

              ditto