6 Replies Latest reply: Jul 1, 2014 8:33 AM by skrishnan RSS

    Oracle Fusion Middleware 11 - Failover - ORA-03114

    skrishnan

      We use Oracle Fusion Middleware 11.1.1.4 to run a Oracle Forms based application that connects to an Exadata - Oracle 11g 11.2.0.3  database.

      In order to test the failover to Data Guard mechanism, we changed the tnsnames.ora to include the stanza for the data guard and disaster recovery databses.


      However after changing the tnsnames.ora entry, the Fusion Forms refused to connect. It gave

      FRM-40735: ON-ERROR trigger raised unhandled exception ORA-03114

       

      Present below is the tnsnames.ora entry .

       

      The first one is the unmodified one that works(we can open up Oracle forms app and connect successfully to the database).

      The second one is the modified one with the failover phrase that does not work - gives

       

      ORA-03114. However the same entry as a jdbc connection string is working fine.

       

      Works :
      clientdb_oltp.world =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = client7-scan1)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = clientdb_oltp_srvc.world)
         )
        )
       
       
      Does NOT work:
      clientdb_oltp.world =
        (DESCRIPTION =
         (LOAD_BALANCE = OFF)
         (FAILOVER = ON)
          (ADDRESS = (PROTOCOL = TCP)(HOST = client7-scan1)(PORT = 1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = client3-scan01)(PORT = 1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = client1-scan)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = clientdb_oltp_srvc.world)
            (FAILOVER_MODE =
              (TYPE = SELECT)
              (METHOD = BASIC))))

       

      JDBC Connection string that works :
      jdbc:oracle:thin:@(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST= client7-scan1)(PORT=1521)))(CONNECT_DATA=(SERVER = DEDICATED) (SERVICE_NAME=clientdb_oltp_srvc.world)))(DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=client3-scan01)(PORT=1521))) (CONNECT_DATA=(SERVER = DEDICATED) (SERVICE_NAME= clientdb_oltp_srvc.world))) (DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=client1-scan)(PORT=1521))) (CONNECT_DATA=(SERVER = DEDICATED) (SERVICE_NAME=clientdb_oltp_srvc.world))))

       

      Could you please advise if there is any reason why Oracle Fusion Middleware will not connect with the tnsnames.ora having the failover stanza ? Does the above entry require any change ?

      We have already checked for any TAB or other non-print characters.

       

      Edit : 6/3/2014  I mistakenly gave the Forms Oracle error as ORA-12154. The error faced is "FRM-40735: ON-ERROR trigger raised unhandled exception ORA-03114"

      Updated Title and description.

      The credentials were validated multiple times. (user id and password is correct)

       

      Message was edited by: skrishnan