3 Replies Latest reply: Jun 14, 2013 6:57 PM by Hussein Sawwan-Oracle RSS

    Auto config is getting failed and apps user is getting locked while running autoconfig on dbTier

    user10721329


      Hi Team,

       

      1) I have cold cloning.after cloning  i tried to run autoconfig on the db side.i am getting the following error

      2) unlocked the apps user and after unlocking executing the adautoconfig apps user is getting locked simuntaneously after executing the adautocfg.sh

       

       

       

      JDBC URL: jdbc:oracle:thin:@cimk.na.tcl.com:1528:PIMDev
          Exception occurred: java.sql.SQLException: ORA-28000: the account is locked

          Trying to connect using SID as ServiceName
      getConnectionUsingServiceName() -->
          JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cimk.na.tcl.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=PIMDev)))
          Exception occurred: java.sql.SQLException: ORA-28000: the account is locked

          Trying to connect using SID as ServiceName.DomainName
      getConnectionUsingServiceName() -->
          JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cimk.na.tcl.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=PIMDEV.na.tcl.com)))
          Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

          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 /u01/pimdev/11.2.0/appsutil/log/PIMDev_tcl/06141934/adcvmlog.xml.06141934


      [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>

                                                                                           

       

      [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: /u01/pimdev/11.2.0/appsutil/install/PIMDev_tcl
            afdbprf.sh              INSTE8_PRF         1

        [APPLY PHASE]
        AutoConfig could not successfully execute the following scripts:
          Directory: /u01/pimdev/11.2.0/appsutil/install/PIMDev_tcl

            adcrobj.sh              INSTE8_APPLY       1


      AutoConfig is exiting with status 2

      AutoConfig execution completed on Fri Jun 14 19:34:18 2013

      Time taken for AutoConfig execution to complete : 0 mins  13 secs

       

       

      Please help me out                                           

        • 1. Re: Auto config is getting failed and apps user is getting locked while running autoconfig on dbTier
          Hussein Sawwan-Oracle
          Exception occurred: java.sql.SQLException: ORA-28000: the account is locked

           

          Please implement the solution in the following docs.

           

          APPS User Account Is Locked While Applying a Patch. Patch Fails With "ORA-28000" [ID 420001.1]

          R12: Clone fails with error "ORA-28000 The account is locked" [ID 1114244.1]

           

          Unlock the apps/applsys accounts then and run AutoConfig.

           

          $ sqlplus / as sysdba
          SQL> alter user apps account unlock;
          SQL> alter user applsys account unlock;
          
          
          

           

          Thanks,

          Hussein

          • 2. Re: Auto config is getting failed and apps user is getting locked while running autoconfig on dbTier
            user10721329

            Hi Hussein

             

            SQL> select username,account_status from dba_users where username='APPS';

            USERNAME                       ACCOUNT_STATUS
            ------------------------------ --------------------------------
            APPS                           LOCKED

            SQL> select username,account_status from dba_users where username='APPLSYS';

            USERNAME                       ACCOUNT_STATUS
            ------------------------------ --------------------------------
            APPLSYS                        OPEN

            SQL> alter user apps account unlock;

            User altered.

            SQL> select username,account_status from dba_users where username='APPS';

            USERNAME                       ACCOUNT_STATUS
            ------------------------------ --------------------------------
            APPS                           OPEN

            SQL> select username,account_status from dba_users where username='APPLSYS';

            USERNAME                       ACCOUNT_STATUS
            ------------------------------ --------------------------------
            APPLSYS                        OPEN

            SQL>

             

             

            After running the adautoconfig facing the same issue and apps user is getting locked

             

            SQL> select username,account_status from dba_users where username='APPS';

            USERNAME                       ACCOUNT_STATUS
            ------------------------------ --------------------------------
            APPS                           LOCKED

            • 3. Re: Auto config is getting failed and apps user is getting locked while running autoconfig on dbTier
              user10721329

              Hi Hussien

               

              I have altered the profiles by using the following docR12: Clone fails with error "ORA-28000 The account is locked" [ID 1114244.1],it helped me.Issue has resolved and autoconfig ran successfully