TNS LISTENER ERROR ON ORACLE RAC VIRTUAL SERVER IRULE
What steps should be listed in the Oracle RAC irule, when load balancing oracle db servers. I get the following error on my VIP (Green) (10.1.232.89:1521). Connection test failed. Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack The Connection descriptor used by the client was: (description= (address=(protocol=tcp)(host=10.1.232.89)(port=1521))(connect_data=(SERVICE_NAME=tpp_n4))) oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112) oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173) oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:460) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411) oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:490) oracle.jdbc.driver.T4CConnection.(T4CConnection.java:202) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:474) com.bea.console.utils.jdbc.JDBCUtils.testConnection(JDBCUtils.java:505) com.bea.console.actions.jdbc.datasources.createjdbcdatasource.CreateJDBCDataSource.testConnectionConfiguration(CreateJDBCDataSource.java:369) sun.reflect.GeneratedMethodAccessor797.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:870) org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809) org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478) org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306) org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336) org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:52) ...
However,all the three DB servers connection test from Oracle Server are fine, 10.1.232.191,10.1.232.192,10.1.232.193.
The service name is tpp_n4, and the irule is in the comments