1 2 Previous Next 19 Replies Latest reply on May 22, 2015 6:34 PM by yoonas

    Autoconfig completea with error on db Tier and Apps Tier

    Williams Oluwafemi

      Hi all,

      the server for my ebs was down for some hours but when i came back up i ran autoconfig on the db tier and the apps tier but they both complete with errors, tried it agsin still the same result.

       

      can someone please help with a solution.

       

      thank you.

        • 1. Re: Autoconfig completea with error on db Tier and Apps Tier
          Bashar.

          Hi,

           

          Please post the autoconfig log.

           

          Regards,

          Bashar

          • 2. Re: Autoconfig completea with error on db Tier and Apps Tier
            Williams Oluwafemi

            hi Bashar, this is the later part of the log

             

             

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

             

             

             

             

            adcvmlog.xml renamed to /d03/oracle/TRAIN/db/tech_st/10.2.0/appsutil/log/TRAIN_i

            psprdb1/05201555/adcvmlog.xml.05201602

             

             

             

             

            [CVM Error Report]

            The following report lists errors encountered during CVM Phase

                  <filename>  <return code where appropriate>

              /d03/oracle/TRAIN/db/tech_st/10.2.0/appsutil/bin/adgentns.pl  25600

             

             

            No of scripts failed in CVM phase: 1

                Exception occurred: java.sql.SQLException: Io exception: The Network Adapter

            could not establish the connection

                Trying to connect using SID as ServiceName

            getConnectionUsingServiceName() -->

                JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ipsprd

            b1.accessbankplc.com)(PORT=1524))(CONNECT_DATA=(SERVICE_NAME=TRAIN)))

                Exception occurred: java.sql.SQLException: Io exception: The Network Adapter

            could not establish the connection

                Trying to connect using SID as ServiceName.DomainName

            getConnectionUsingServiceName() -->

                JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ipsprd

            b1.accessbankplc.com)(PORT=1524))(CONNECT_DATA=(SERVICE_NAME=TRAIN.accessbankplc

            .com)))

                Exception occurred: java.sql.SQLException: Io exception: The Network Adapter

            could not establish the connection

                Connection could not be obtained; returning null

             

             

            -------------------ADX Database Utility Finished---------------

             

             

                    Verifying connection to the Database   : Could not be stablished

                    No Restore Profile file created.

             

             

             

             

            Restore Profile utility ran successfully

             

             

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

             

             

             

             

            adcvmlog.xml renamed to /d03/oracle/TRAIN/db/tech_st/10.2.0/appsutil/log/TRAIN_i

            psprdb1/05201555/adcvmlog.xml.05201602

             

             

             

             

            [CVM Error Report]

            The following report lists errors encountered during CVM Phase

                  <filename>  <return code where appropriate>

              /d03/oracle/TRAIN/db/tech_st/10.2.0/appsutil/bin/adgentns.pl  25600

             

             

            No of scripts failed in CVM phase: 1

             

             

            [CVM Error Report]

            The following report lists errors encountered during CVM Phase

                  <filename>  <return code where appropriate>

              /d03/oracle/TRAIN/db/tech_st/10.2.0/appsutil/bin/adgentns.pl  25600

             

             

            No of scripts failed in CVM phase: 1

             

             

             

             

            [AutoConfig Error Report]

            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>

             

             

              [PROFILE PHASE]

              AutoConfig could not successfully execute the following scripts:

                Directory: /d03/oracle/TRAIN/db/tech_st/10.2.0/appsutil/install/TRAIN_ipsprd

            b1

                  afdbprf.sh              INSTE8_PRF         1

             

             

              [APPLY PHASE]

              AutoConfig could not successfully execute the following scripts:

                Directory: /d03/oracle/TRAIN/db/tech_st/10.2.0/appsutil/install/TRAIN_ipsprd

            b1

                  adcrobj.sh              INSTE8_APPLY       1

             

             

             

             

            AutoConfig is exiting with status 2

            • 3. Re: Autoconfig completea with error on db Tier and Apps Tier
              Bashar.

              Hi,

               

              Check the database connectivity from the application tier.

               

              Regards,

              Bashar

              • 4. Re: Autoconfig completea with error on db Tier and Apps Tier
                2846585

                Hi

                What is your EBS version, Is it two-node apps? How did you run the apps tier and db tier 'autoconfing'? Did anybody changed apps password?

                 

                Thanks

                Arizuddin

                • 5. Re: Autoconfig completea with error on db Tier and Apps Tier
                  yoonas

                  please tell us

                  Is your database up?

                  status of database listener - lsnrctl status <listener_name>

                  Any recent changes ?

                   

                  Regards

                  Yoonas

                  • 6. Re: Autoconfig completea with error on db Tier and Apps Tier
                    ora_tech

                    Hi,

                     

                    Please check you are able to connect database using tns alias name.

                     

                    thanks,

                    X A H E E R

                    • 7. Re: Autoconfig completea with error on db Tier and Apps Tier
                      Williams Oluwafemi

                      hi, my ebs version is R12.1.3, its one node, sh adstrtal.sh apps/password

                      • 8. Re: Autoconfig completea with error on db Tier and Apps Tier
                        Williams Oluwafemi

                        hi, thanks.

                        but i started my db already

                         

                        here is the status of my listener

                         

                        $ lsnrctl status TRAIN

                         

                         

                        LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Production on 21-MAY-2015 10:47:12

                         

                         

                        Copyright (c) 1991, 2006, Oracle.  All rights reserved.

                         

                         

                        Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCTRAIN))

                        STATUS of the LISTENER

                        ------------------------

                        Alias                     TRAIN

                        Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Production

                        Start Date                21-MAY-2015 10:41:11

                        Uptime                    0 days 0 hr. 6 min. 1 sec

                        Trace Level               off

                        Security                  ON: Local OS Authentication

                        SNMP                      ON

                        Listener Parameter File   /d03/oracle/TRAIN/db/tech_st/10.2.0/network/admin/TRAIN_ipsprdb1/listener.ora

                        Listener Log File         /d03/oracle/TRAIN/db/tech_st/10.2.0/network/admin/train.log

                        Listening Endpoints Summary...

                          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCTRAIN)))

                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ipsprdb1.accessbankplc.com)(PORT=1524)))

                        Services Summary...

                        Service "PLSExtProc" has 1 instance(s).

                          Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

                        Service "TRAIN" has 1 instance(s).

                          Instance "TRAIN", status UNKNOWN, has 1 handler(s) for this service...

                        The command completed successfully

                         

                         

                        thank you.

                        • 9. Re: Autoconfig completea with error on db Tier and Apps Tier
                          Williams Oluwafemi

                          hi ora_tech,

                          pleas what do you mean by  connect database using tns alias name

                          i connected as sysdba and also connected as apps

                          sqlplus / as sysdba

                          connect apps/password

                           

                          from the db tier.

                          thanks.

                          • 10. Re: Autoconfig completea with error on db Tier and Apps Tier
                            Williams Oluwafemi

                            hi Bashar,

                            well, i really do not understand what you mean by  Check the database connectivity from the application tier

                             

                            but this is the result when i tried starting the apps tier.

                             

                             

                            sh adstrtal.sh

                             

                             

                            You are running adstrtal.sh version 120.15.12010000.3

                             

                             

                             

                             

                            Enter the APPS username: apps

                             

                             

                            Enter the APPS password:

                             

                             

                            adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.

                             

                             

                            USAGE:  adstrtal.sh <appsusername/appspassword>

                                    adstrtal.sh <applications_username/applications_password> -secureapps

                                    adstrtal.sh -nodbchk

                             

                             

                             

                             

                            adstrtal.sh: exiting with status 1

                             

                             

                            thank you.

                            • 11. Re: Autoconfig completea with error on db Tier and Apps Tier
                              yoonas

                              start sqlplus and try connecting

                               

                              sqlplus apps/password@

                              sqlplus apps/password@ipsprdb1.accessbankplc.com:1524/TRAIN

                              Create Net Services Aliases

                               

                              Did you try running autoconfig on db tier after starting up database services

                               

                              Please post tnsnames.ora

                              • 12. Re: Autoconfig completea with error on db Tier and Apps Tier
                                yoonas

                                So you can run autoconfig without issues on db tier.

                                Try to ping from application tier to db server

                                source application tier env and try connecting to database server

                                sqlplus apps/pass@<service_alias>

                                or

                                sqlplus apps/password@ipsprdb1.accessbankplc.com:1524/TRAIN

                                 

                                tnsping TRAIN

                                • 13. Re: Autoconfig completea with error on db Tier and Apps Tier
                                  Williams Oluwafemi

                                  nnow this is the status,

                                   

                                  i ran autoconfig on the db tier it was successful then i ran it on he apps tier it was also successful the i started the apps tier services with sh.adstrtal.sh then it completed with status 4, below is the later part of the log

                                  thank you.

                                   

                                   

                                   

                                   

                                   

                                  [Service Control Execution Report]

                                  The report format is:

                                    <Service Group>            <Service>                                   <Script

                                  >         <Status>

                                   

                                   

                                    Root Service

                                            Enabled

                                    Root Service               Oracle Process Manager for TRAIN_drcapperp  adopmnc

                                  tl.sh     Started

                                    Web Entry Point Services

                                            Enabled

                                    Web Entry Point Services   Oracle HTTP Server TRAIN_drcapperp          adapcct

                                  l.sh      Failed

                                    Web Entry Point Services   OracleTNSListenerAPPS_TRAIN_drcapperp       adalnct

                                  l.sh      Started

                                    Web Application Services

                                            Enabled

                                    Web Application Services   OACORE OC4J Instance TRAIN_drcapperp        adoacor

                                  ectl.sh   Failed

                                    Web Application Services   FORMS OC4J Instance TRAIN_drcapperp         adforms

                                  ctl.sh    Failed

                                    Web Application Services   OAFM OC4J Instance TRAIN_drcapperp          adoafmc

                                  tl.sh     Failed

                                    Batch Processing Services

                                            Enabled

                                    Batch Processing Services  OracleConcMgrTRAIN_drcapperp                adcmctl

                                  .sh       Started

                                    Batch Processing Services  Oracle Fulfillment Server TRAIN_drcapperp   jtffmct

                                  l.sh      Started

                                    Other Services

                                            Enabled

                                   

                                   

                                   

                                   

                                  ServiceControl is exiting with status 4

                                   

                                   

                                   

                                   

                                  05/21/15-12:29:46 :: You are running adstrtal.sh version 120.15.12010000.3

                                   

                                   

                                   

                                   

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

                                  • 14. Re: Autoconfig completea with error on db Tier and Apps Tier
                                    Williams Oluwafemi

                                    now this is the status,

                                     

                                    i ran autoconfig on the db tier it was successful then i ran it on he apps tier it was also successful the i started the apps tier services with sh.adstrtal.sh then it completed with status 4, below is the later part of the log

                                    thank you.

                                     

                                     

                                     

                                     

                                     

                                    [Service Control Execution Report]

                                    The report format is:

                                      <Service Group>            <Service>                                   <Script

                                    >         <Status>

                                     

                                     

                                      Root Service

                                              Enabled

                                      Root Service               Oracle Process Manager for TRAIN_drcapperp  adopmnc

                                    tl.sh     Started

                                      Web Entry Point Services

                                              Enabled

                                      Web Entry Point Services   Oracle HTTP Server TRAIN_drcapperp          adapcct

                                    l.sh      Failed

                                      Web Entry Point Services   OracleTNSListenerAPPS_TRAIN_drcapperp       adalnct

                                    l.sh      Started

                                      Web Application Services

                                              Enabled

                                      Web Application Services   OACORE OC4J Instance TRAIN_drcapperp        adoacor

                                    ectl.sh   Failed

                                      Web Application Services   FORMS OC4J Instance TRAIN_drcapperp         adforms

                                    ctl.sh    Failed

                                      Web Application Services   OAFM OC4J Instance TRAIN_drcapperp          adoafmc

                                    tl.sh     Failed

                                      Batch Processing Services

                                              Enabled

                                      Batch Processing Services  OracleConcMgrTRAIN_drcapperp                adcmctl

                                    .sh       Started

                                      Batch Processing Services  Oracle Fulfillment Server TRAIN_drcapperp   jtffmct

                                    l.sh      Started

                                      Other Services

                                              Enabled

                                     

                                     

                                     

                                     

                                    ServiceControl is exiting with status 4

                                     

                                     

                                     

                                     

                                    05/21/15-12:29:46 :: You are running adstrtal.sh version 120.15.12010000.3

                                    1 2 Previous Next