000013770 - Authentication Manager 7.1- Replica install fails with Failed to attach the replica to the primary site

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000013770
Applies ToAuthentication Manager 7.1 on All supported platforms
Appliance 3.0
Replica Install

Attach Replica Dynamic Display
Caused by: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL []; SQL state [66000]; error code [12541]; ORA-12541: TNS:no listener
; nested exception is java.sql.SQLException: ORA-12541: TNS:no listener


Error:
Replica Setup failed with exit code: 1

Issue

Replica install fails with the following errors in the Config_trace.log:


09 Jun 14:22:27.723 ERROR - Main Thread - config.ConfigEngine - Failed to attach the replica to the primary site:
09 Jun 14:22:27.723 ERROR - Main Thread - config.ConfigEngine - Additional stack:
com.rsa.replication.ReplicationSystemException: Testing database link to servername:[iwtf17mu] from s2k3app7
at com.rsa.ims.replication.AbstractReplicationSystem.executeWithMonitoringError(AbstractReplicationSystem.java:832)
at com.rsa.ims.replication.AbstractReplicationSystem.testDatabaseLink(AbstractReplicationSystem.java:560)
at com.rsa.ims.replication.AbstractReplicationSystem.testDatabaseLink(AbstractReplicationSystem.java:534)
at com.rsa.installfwrk.config.command.SetupReplicaSiteCmd.setupReplica(SetupReplicaSiteCmd.java:185)
at com.rsa.installfwrk.config.command.SetupReplicaSiteCmd.execute(SetupReplicaSiteCmd.java:163)
at com.rsa.installfwrk.config.ConfigEngine.execute(ConfigEngine.java:185)
at com.rsa.installfwrk.config.ConfigUtil.runConfig(ConfigUtil.java:53)
at com.rsa.installfwrk.config.ConfigUtil.main(ConfigUtil.java:35)
Caused by: com.rsa.ims.replication.ProcedureExecutionException: Testing database link to servername:[iwtf17mu] from s2k3app7
... 8 more
Caused by: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL []; SQL state [66000]; error code [12170]; ORA-12170: TNS:Connect timeout occurred
; nested exception is java.sql.SQLException: ORA-12170: TNS:Connect timeout occurred
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120


)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:354)
at com.rsa.ims.replication.streams.TestDatabaseLink.executeProcedure(TestDatabaseLink.java:63)
at com.rsa.ims.replication.AbstractReplicationSystem.executeWithMonitoringError(AbstractReplicationSystem.java:799)... 7 more

Caused by: java.sql.SQLException: ORA-12170: TNS:Connect timeout occurred
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:194)
at com.rsa.ims.replication.streams.TestDatabaseLink.doInStatement(TestDatabaseLink.java:73)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:343)... 9 more


ORA-12560: TNS:protocol adapter error ORA-12541: TNS:no listener The database connection to remote site <primanry> is disconnected
 
Cause

 Replica installation fails if there is a firewall blocking the ports in between the primary and replica servers. Make sure all the required ports, specifically the replication  port 2334/TCP is open.


 


You can test by using either Telnet from a CMD prompt or http from a Browser to port 2334, e.g.


DOS CMD prompt> telnet <replica IP or Name> 2334


Browser on Primary:   http://<replica>:2334


Browser of Replica:   http://<Primary>:2334


Time out or restricted means port is blocked or not listening, blank screen means you received a TCP SYN ACK back from the port so it is not blocked

For a complete list of port usage for Authentication Manager 7.1, please refer to page 19 of the Authentication Manager Installation Guide.

ResolutionOpen up all the required ports between the Replica and primary instance. Most importantly the replication Port 2334/TCP.
Legacy Article IDa46352

Attachments

    Outcomes