2 Replies Latest reply on Jan 19, 2010 10:02 PM by 606997

    ERROR=(CODE=1153)

    606997
      my application team uses a jdbc connection to access the database. . when they tried to insert a record in dev, got the 1153 error ().

      Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(ERROR_STACK=(ERROR=(CODE=1153)(

      but the The application is working when accessing only 1 db node, it does not work if we use the url string for the db rack.

      we are using 10 g 4 node rac on linux.

      Please adive me to trouble shoot.

      I checked all the services or online and alert log looking fine.
        • 1. Re: ERROR=(CODE=1153)
          sb92075
          post tail end of listener.log file right after this error occurs.
          • 2. Re: ERROR=(CODE=1153)
            606997
            meta link gave me the followin info.

            JDBC - Version: 9.2.0.1.0
            This problem can occur on any platform.

            Symptoms
            Using 9.2.0.1 JDBC Thin driver to access a RAC cluster with the following connect string :

            jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(LOAD_BALANCE=ON)(ADDRESS = (PROTO = TCP)(HOST =host2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521)))(CONNECT_DATA =(SERVER =DEDICATED)(SERVICE_NAME = DB102)))

            At connection time, the following exception is occuring :
            java.sql.SQLException: Io exception: Connection refused (DESCRIPTION=(ERR=1153)(VSNNUM=153093632)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTO =TCP)(HOST=hostname)(PORT=1521))'))(ERROR=(ODE=305)(EMFI=1)))).]

            Cause
            The cause of this problem has been identified and verified in an unpublished Bug 2427185.

            It is caused by the fact that the JDBC Thin does not support redirection to another NET listener

            Solution
            Upgrade the JDBC driver version to the latest version, for example 9.2.0.8.