1 2 Previous Next 15 Replies Latest reply: Nov 25, 2009 12:00 AM by Hussein Sawwan-Oracle RSS

    Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1

    689285
      After MT Migration when i am trying to run autoconfig its failing with following error

      ==========================================


      Params=fnd_jdbc_stmt_cache_free_mem=TRUE
      fnd_jdbc_buffer_min=1
      fnd_jdbc_buffer_max=5
      fnd_jdbc_buffer_decay_interval=300
      fnd_jdbc_buffer_decay_size=5
      fnd_jdbc_usable_check=false
      fnd_jdbc_context_check=true
      fnd_jdbc_plsql_reset=false


      Unique constraint error (00001) is OK if key already exists
      java.sql.SQLException: ORA-01403: no data found
      ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 298
      ORA-06512: at line 1
      - Database error modifying the server

      ADD call failed with exit code 1

      Trying to update information ...

      ADD call failed with exit code 1

      Trying to update information ...


      UPDATE call failed with exit code 1
      Updating parameters: fnd_jdbc_stmt_cache_free_mem=TRUE fnd_jdbc_buffer_min=1 fnd_jdbc_buffer_max=5

      Updating parameters: fnd_jdbc_buffer_decay_interval=300 fnd_jdbc_buffer_decay_size=5 fnd_jdbc_usable_check=false

      Updating parameters: fnd_jdbc_context_check=true fnd_jdbc_plsql_reset=false

      DBC generation failed with exit code 1



      The following report lists errors AutoConfig encountered during each
      phase of its execution. Errors are grouped by directory and phase.
      The report format is:
      <filename> <phase> <return code where appropriate>

      [SETUP PHASE]
      AutoConfig could not successfully execute the following scripts:
      Directory: /xxx/tech/comn/admin/install/xxxxx
      adgendbc.sh INSTE8_SETUP 1

      Edited by: HumanDBA on Nov 24, 2009 1:40 PM
        • 1. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
          689285
          I ran adgendbc.sh but i got same error

          adgendbc.sh apps apps

          adgendbc.sh started at Tue Nov 24 16:49:00 EST 2009

          ./adgendbc.sh: line 75: /u08/tech/appl/ad/11.5.0/bin/adident: cannot execute binary file
          ./adgendbc.sh: line 76: [: -gt: unary operator expected

          Enter the APPS username: apps

          Enter the APPS password:

          SQL*Plus: Release 8.0.6.0.0 - Production on Tue Nov 24 16:49:09 2009

          (c) Copyright 1999 Oracle Corporation. All rights reserved.

          Enter value for 1: Enter value for 2: Enter value for 3: Connected.
          Updated profile option value - 1 row(s) updated
          Application Id : 0
          Profile Name : APPS_DATABASE_ID
          Level Id : 10001
          New Value : ofmstech
          Old Value : ofmstech

          PL/SQL procedure successfully completed.


          Commit complete.

          Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
          With the Partitioning, OLAP, Data Mining and Real Application Testing options


          Params=fnd_jdbc_stmt_cache_free_mem=TRUE
          fnd_jdbc_buffer_min=1
          fnd_jdbc_buffer_max=5
          fnd_jdbc_buffer_decay_interval=300
          fnd_jdbc_buffer_decay_size=5
          fnd_jdbc_usable_check=false
          fnd_jdbc_context_check=true
          fnd_jdbc_plsql_reset=false


          Unique constraint error (00001) is OK if key already exists
          java.sql.SQLException: ORA-01403: no data found
          ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 298
          ORA-06512: at line 1
          - Database error modifying the server

          ADD call failed with exit code 1

          Trying to update information ...


          UPDATE call failed with exit code 1
          Updating parameters: fnd_jdbc_stmt_cache_free_mem=TRUE fnd_jdbc_buffer_min=1 fnd_jdbc_buffer_max=5

          Updating parameters: fnd_jdbc_buffer_decay_interval=300 fnd_jdbc_buffer_decay_size=5 fnd_jdbc_usable_check=false

          Updating parameters: fnd_jdbc_context_check=true fnd_jdbc_plsql_reset=false

          DBC generation failed with exit code 1

          Generating /u08/tech/appl/fnd/11.5.0/secure/dbora90.lgeenergy.int_ofmstech.dbc
          DBC argument specified, ignoring SECURE_PATH

          DBC generation failed with exit code 1
          Updating parameters: fnd_jdbc_stmt_cache_free_mem=TRUE fnd_jdbc_buffer_min=1 fnd_jdbc_buffer_max=5
          DBC argument specified, ignoring SECURE_PATH

          Updating parameters: fnd_jdbc_buffer_decay_interval=300 fnd_jdbc_buffer_decay_size=5 fnd_jdbc_usable_check=false
          DBC argument specified, ignoring SECURE_PATH

          Updating parameters: fnd_jdbc_context_check=true fnd_jdbc_plsql_reset=false
          DBC argument specified, ignoring SECURE_PATH

          DBC generation failed with exit code 1

          Generating /u08/tech/appl/fnd/11.5.0/secure/dbora90_ofmstech.dbc
          DBC argument specified, ignoring SECURE_PATH

          DBC generation failed with exit code 1
          Updating parameters: fnd_jdbc_stmt_cache_free_mem=TRUE fnd_jdbc_buffer_min=1 fnd_jdbc_buffer_max=5
          DBC argument specified, ignoring SECURE_PATH

          Updating parameters: fnd_jdbc_buffer_decay_interval=300 fnd_jdbc_buffer_decay_size=5 fnd_jdbc_usable_check=false
          DBC argument specified, ignoring SECURE_PATH

          Updating parameters: fnd_jdbc_context_check=true fnd_jdbc_plsql_reset=false
          DBC argument specified, ignoring SECURE_PATH

          DBC generation failed with exit code 1

          Updating Server Security Authentication
          java.sql.SQLException: Io exception: Invalid number format for port number
          Database connection to jdbc:oracle:thin:@host_name:port_number:database failed
          Updating Server Security Authentication failed with exit code 1
          adgendbc.sh exiting with status 1
          ERRORCODE = 1 ERRORCODE_END
          • 2. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
            Hussein Sawwan-Oracle
            Danny,

            I believe you will need to clean FND_NODES table and run AutoConfig -- See (Note: 954165.1 - adgendbc.sh : ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 298) for details.

            Regards,
            Hussein
            • 3. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
              689285
              I glad to see you back, Is this issue with FND_NODES wrong entries..? I will check it and let you know.
              • 4. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
                Hussein Sawwan-Oracle
                Danny,

                Most probably yes, so purge the table and run AutoConfig on the database tier then on the application tier.

                Regards,
                Hussein
                • 5. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
                  689285
                  Do you want me apply patch mentiond in note.
                  • 6. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
                    689285
                    I already applied patch before migration

                    SQL> select bug_number from ad_bugs where bug_number like '7164202';

                    BUG_NUMBER
                    ------------------------------
                    7164202

                    SQL>
                    • 7. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
                      Hussein Sawwan-Oracle
                      Danny,

                      Not necessarily (Patch 7164202 is the latest Rapid Clone patch). However, it is recommended you have this patch applied later (in case purging FND_NODES did not fix the issues, then you may need to consider applying this patch).

                      Regards,
                      Hussein
                      • 8. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
                        689285
                        Sawwan,

                        Same issue after puring FND_NODES, node name looks


                        even after cleaning fnd_nodesthe hostsname should be listen in UPPERCASE in FND_NODES, but its still showing small letters


                        Params=fnd_jdbc_stmt_cache_free_mem=TRUE
                        fnd_jdbc_buffer_min=1
                        fnd_jdbc_buffer_max=5
                        fnd_jdbc_buffer_decay_interval=300
                        fnd_jdbc_buffer_decay_size=5
                        fnd_jdbc_usable_check=false
                        fnd_jdbc_context_check=true
                        fnd_jdbc_plsql_reset=false


                        Unique constraint error (00001) is OK if key already exists
                        java.sql.SQLException: ORA-01403: no data found
                        ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 298
                        ORA-06512: at line 1
                        - Database error modifying the server

                        ADD call failed with exit code 1

                        Trying to update information ...


                        UPDATE call failed with exit code 1
                        Updating parameters: fnd_jdbc_stmt_cache_free_mem=TRUE fnd_jdbc_buffer_min=1 fnd_jdbc_buffer_max=5

                        Updating parameters: fnd_jdbc_buffer_decay_interval=300 fnd_jdbc_buffer_decay_size=5 fnd_jdbc_usable_check=false

                        Updating parameters: fnd_jdbc_context_check=true fnd_jdbc_plsql_reset=false

                        DBC generation failed with exit code 1

                        Generating /u08/tech/appl/fnd/11.5.0/secure/XXXXX.dbc
                        DBC argument specified, ignoring SECURE_PATH

                        DBC generation failed with exit code 1
                        Updating parameters: fnd_jdbc_stmt_cache_free_mem=TRUE fnd_jdbc_buffer_min=1 fnd_jdbc_buffer_max=5
                        DBC argument specified, ignoring SECURE_PATH

                        Updating parameters: fnd_jdbc_buffer_decay_interval=300 fnd_jdbc_buffer_decay_size=5 fnd_jdbc_usable_check=false
                        DBC argument specified, ignoring SECURE_PATH

                        Updating parameters: fnd_jdbc_context_check=true fnd_jdbc_plsql_reset=false

                        Edited by: HumanDBA on Nov 24, 2009 2:29 PM
                        • 9. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
                          Hussein Sawwan-Oracle
                          Danny,

                          Did you verify the entries in FND_NODES table?

                          Any other details about the error in the log files? Could you please send me the log file by email?

                          Regards,
                          Hussein
                          • 11. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
                            Hussein Sawwan-Oracle
                            Danny,

                            I see the following in the log:
                            Updating Server Security Authentication
                            java.sql.SQLException: Io exception: Invalid number format for port number
                            Database connection to jdbc:oracle:thin:@host_name:port_number:database failed
                            Updating Server Security Authentication failed with exit code 1
                            Please see if these documents help.

                            Note: 340354.1 - Autoconfig fails while running adgendbc.Sh
                            Note: 376077.1 - adgendbc.sh fails with invalid arguments
                            Note: 356397.1 - ORA-01422: exact fetch returns more than requested number of rows, ORA-06512: at APPS.FND_APP_SEVER_PKG, line 106

                            Regards,
                            Hussein
                            • 12. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
                              689285
                              let me check the metalink notes, i will get back you.
                              • 13. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
                                689285
                                I checked all documents which you refered, but every thing looks good, Please check your email
                                • 14. Re: Autoconfig failed with  adgendbc.sh INSTE8_SETUP 1
                                  Hussein Sawwan-Oracle
                                  Danny,

                                  The query does not show the node name which supports the CP and the ADMIN node, so did you run AutoConfig on all the application tier nodes after purging the FND_NODES table?

                                  Regards,
                                  Hussein
                                  1 2 Previous Next