1 Reply Latest reply: Nov 28, 2012 7:09 AM by 877440 RSS

    ora-12710 to connect from primary (failedover one) to standby(original prim

    877440
      We have: 2-node RAC Primary, 2 node RAC standby. This is our QA environment.

      The OS had issue, one of primary crashed and db failed over to 2-node RAC standby.

      And dgmgrl show configuration shows:
      DGMGRL> show configuration

      Configuration - qa_dg

      Protection Mode: MaxPerformance
      Databases:
      sqa - Primary database
      Error: ORA-16825: multiple errors or warnings, including fast-start failover-related errors or warnings, detected for the database

      qa - (*) Physical standby database (disabled)
      ORA-16661: the standby database needs to be reinstated

      Fast-Start Failover: ENABLED

      Configuration Status:
      ERROR

      So I went ahead run: reinstate database 'qa'

      This reinstate failed , and drqa.log shows: ora-12710 connecting to qa db.

      So I tested on now-primary hosts to see if sqlplus sys@qa1(2) as sysdba works. Both failed with ORA-12710.

      sqlnet.ora has inbound timeout set to 120. THis whole environment worked before.

      Then I found out the service_names created not running on now-standby hosts:
      srvctl status service -d qa
      Service qa_ro_jdbc_service is not running.
      Service qa_ro_oci_service is not running.
      Service qa_rw_jdbc_service is not running.
      Service qa_rw_oci_service is not running.

      start service -d qa
      CRS-2800: Cannot start resource 'ora.qa.db' as it is already in the INTERMEDIATE state on server 'oracle03'
      CRS-2632: There are no more servers to try to place resource 'ora.qa.qa_rw_oci_service.svc' on that would satisfy its placement policy
      CRS-2800: Cannot start resource 'ora.qa.db' as it is already in the INTERMEDIATE state on server 'oracle02'
      CRS-2800: Cannot start resource 'ora.qa.db' as it is already in the INTERMEDIATE state on server 'oracle03'
      CRS-2632: There are no more servers to try to place resource 'ora.qa.qa_ro_oci_service.svc' on that would satisfy its placement policy
      CRS-2800: Cannot start resource 'ora.qa.db' as it is already in the INTERMEDIATE state on server 'oracle02'
      CRS-2800: Cannot start resource 'ora.qa.db' as it is already in the INTERMEDIATE state on server 'oracle03'
      CRS-2632: There are no more servers to try to place resource 'ora.qa.qa_rw_jdbc_service.svc' on that would satisfy its placement policy
      CRS-2800: Cannot start resource 'ora.qa.db' as it is already in the INTERMEDIATE state on server 'oracle02'
      CRS-2800: Cannot start resource 'ora.qa.db' as it is already in the INTERMEDIATE state on server 'oracle03'
      CRS-2632: There are no more servers to try to place resource 'ora.qa.qa_ro_jdbc_service.svc' on that would satisfy its placement policy
      CRS-2800: Cannot start resource 'ora.qa.db' as it is already in the INTERMEDIATE state on server 'oracle02'


      How do I get this problem fixed?

      Thanks in advance.