4 Replies Latest reply on Mar 28, 2016 6:08 AM by 2773452

    unable to change EBS R12.1.3 apps password using FNDCPASS

    2773452

      Hi,

       

      We have upgraded our  database to 12.1.0.2 from 11.2.0.3 using DBUA with EBS R12.1.3

       

      post upgrade all the dba users account status was changed to "EXPIRED & LOCKED" and the same is resolved by suggest by SR

       

      SQL> create table user$_backup as select * from user$;

       

       

      Table created.

       

       

      SQL> begin

        2

        3

        4  for rec in (select name, spare4 from user$ where type#=1 and name not in ('SYS','SYSTEM','XS$NULL','ANONYMOUS') and spare4 is not null) loop

        5

        6  execute immediate 'alter user '||rec.name ||' identified by values '''||rec.spare4||'''';

        7  execute immediate 'alter user '||rec.name ||' account unlock';

        8

        9  end loop;

      10  end;

      11  /

       

       

      PL/SQL procedure successfully completed.

       

       

      SQL> begin

        2

        3

        4  for rec in (select name, password from user$ where type#=1 and name not in ('SYS','SYSTEM','XS$NULL','ANONYMOUS') and spare4 is null) loop

        5

        6  execute immediate 'alter user '||rec.name ||' identified by values '''||rec.password||'''';

        7  execute immediate 'alter user '||rec.name ||' account unlock';

       

       

        8    9  end loop;

      end;

      10   11  /

       

       

      PL/SQL procedure successfully completed.

       

       

      SQL>

      SQL>

       

       

      After that we were able to complete autoconfig on both database and appstier.

       

      Now current issue unable to change the apps password using FNDCPASS and we are unable to access front end URL, while accessing the front end URL apps user is getting locked out.

       

      [appldev@erpdev ~]$ FNDCPASS apps/findev#789 0 Y system/findevsys#123 SYSTEM APPLSYS devnewpwd

      Log filename : L3848278.log

       

       

       

       

      Report filename : O3848278.out

      [appldev@erpdev ~]$

      [appldev@devserver ~]$ cat L3848278.log

      +---------------------------------------------------------------------------+

      Application Object Library: Version : 12.0.0

       

       

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

       

       

      module:

      +---------------------------------------------------------------------------+

       

       

      Current system time is 22-MAR-2016 22:52:11

       

       

      +---------------------------------------------------------------------------+

       

       

      Working...

       

       

      +---------------------------------------------------------------------------+

      Concurrent request completed

      Current system time is 22-MAR-2016 22:52:11

       

       

      +---------------------------------------------------------------------------+

      [appldev@devserver ~]$

      [appldev@devserver ~]$

      [appldev@devserver ~]$ sqlplus apps/devnewpwd -------------------not able to login new password

       

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Tue Mar 22 22:53:23 2016

       

       

      Copyright (c) 1982, 2005, Oracle. All rights reserved.

       

       

      ERROR:

      ORA-01017: invalid username/password; logon denied

       

       

       

       

      Enter user-name: [appldev@devserver ~]$ sqlplus apps/findev#789 -----only able to login only old passwd

       

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Tue Mar 22 22:53:42 2016

       

       

      Copyright (c) 1982, 2005, Oracle. All rights reserved.

       

       

       

       

      Connected to:

      Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics

      and Real Application Testing options

       

       

      SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics

      and Real Application Testing options

      [appldev@devserver ~]$

       

       

       

       

      Also we found below exception is the application.log.($LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log)

       

      Caused by: java.lang.RuntimeException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28000: the account is locked

       

       

              at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:856)

              at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:230)

              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

              at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

              at oracle.apps.fnd.common.Pool.createObject(Pool.java:1276)

              ... 50 more

      Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28000: the account is locked

       

       

              at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1573)

              at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1299)

              at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1194)

              at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1183)

              at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:839)

              ... 56 more

      Caused by: java.sql.SQLException: ORA-28000: the account is locked

       

       

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381)

              at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:564)

              at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431)

              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)

              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

              at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)

              at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)

              at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359)

              at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)

              at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)

              at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

              at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)

              at java.sql.DriverManager.getConnection(DriverManager.java:582)

              at java.sql.DriverManager.getConnection(DriverManager.java:154)

              at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1560)

              ... 60 more

       

       

      Kindly help us in resolving this issue.

       

      Regards,

      Chandrasekar S

        • 1. Re: unable to change EBS R12.1.3 apps password using FNDCPASS
          Hussein Sawwan-Oracle

          ORA-28000: the account is locked

           

          Check the status of apps/applsys accounts and unlock them if needed. See the following docs for details:

           

          (Doc ID 727407.1)

          (Doc ID 1114244.1)

          (Doc ID 420001.1)

           

          Can you also confirm that AutoConfig complete successfully on all tier nodes?

           

          Thanks,

          Hussein

          • 2. Re: unable to change EBS R12.1.3 apps password using FNDCPASS
            2773452

            Hi Hussein,

             

            Thanks for your revert.

             

             

            Autoconfig is completing fine on both db and appstier.

             

            Account status are open and when we try to access the URL ,  only the apps users account_status getting LOCKED(TIMED)

             

            SQL> select username,user_id,password,account_status,lock_date,expiry_date from dba_users where USERNAME in ('APPS', 'APPLSYSPUB','APPLSYS');

             

             

            USERNAME      USER_ID PASSWORD   ACCOUNT_STATUS                   LOCK_DATE          EXPIRY_DATE

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

            APPLSYSPUB         33            OPEN

            APPLSYS            32            OPEN

            APPS              173            OPEN

            SQL>

             

            Also getting below error in application.log

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

            Caused by: java.lang.RuntimeException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28000: the account is locked

             

             

                    at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:856)

                    at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:230)

                    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

                    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

                    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

                    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

                    at oracle.apps.fnd.common.Pool.createObject(Pool.java:1276)

                    ... 50 more

            Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28000: the account is locked

             

             

                    at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1573)

                    at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1299)

                    at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1194)

                    at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1183)

                    at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:839)

                    ... 56 more

            Caused by: java.sql.SQLException: ORA-28000: the account is locked

             

             

                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388)

                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381)

                    at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:564)

                    at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431)

                    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)

                    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

                    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)

                    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)

                    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359)

                    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)

                    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)

                    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

                    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)

                    at java.sql.DriverManager.getConnection(DriverManager.java:582)

                    at java.sql.DriverManager.getConnection(DriverManager.java:154)

                    at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1560)

                    ... 60 more

            16/03/22 22:31:52.715 html: Servlet error

            java.lang.ExceptionInInitializerError

                    at oracle.apps.fnd.sso.Utils.<clinit>(Utils.java:674)

                    at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:225)

                    at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:291)

                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpApplication.loadServlet(HttpApplication.java:2528)

                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:5006)

                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4930)

                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:3139)

                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:775)

                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)

                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)

                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)

                    at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)

                    at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)

                    at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)

                    at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)

                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

                    at java.lang.Thread.run(Thread.java:619)

            Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.

                    at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1509)

                    at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:362)

                    at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:211)

                    at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:171)

                    at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)

                    at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1294)

                    at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1149)

                    at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1118)

                    at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1085)

                    at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1072)

                    at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)

                    at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:604)

                    at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:581)

                    at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:535)

                    at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:301)

                    at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:745)

                    at oracle.apps.fnd.sso.Utils.getAppsContext(Utils.java:549)

                    at oracle.apps.fnd.sso.SessionMgr.loadInstalledLanguages(SessionMgr.java:4058)

                    at oracle.apps.fnd.sso.SessionMgr.getInstalledLanguages(SessionMgr.java:3852)

                    at oracle.apps.fnd.sso.Utils.getBaseInstalledLangCode(Utils.java:1490)

                    at oracle.apps.fnd.sso.Authenticator.<clinit>(Authenticator.java:45)

                    ... 17 more

            Caused by: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.

                    at oracle.apps.fnd.common.Pool.createObject(Pool.java:1289)

                    at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1028)

                    at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:585)

                    at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:345)

                    at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1758)

                    at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2316)

                    at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2253)

                    at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2110)

                    at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1920)

                    at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1764)

                    at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1777)

                    at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1492)

                    at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:170)

                    at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)

                    ... 37 more

            Caused by: java.lang.RuntimeException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28000: the account is locked

             

             

                    at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:856)

                    at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:230)

                    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

                    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

                    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

                    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

                    at oracle.apps.fnd.common.Pool.createObject(Pool.java:1276)

                    ... 50 more

            Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28000: the account is locked

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

             

            login1q_dev.pnglogin2q_dev.png

            • 3. Re: unable to change EBS R12.1.3 apps password using FNDCPASS
              Ratnesh Kumar

              Hello,

               

              Follow this document

               

              How to Change Applications Passwords using Applications Schema Password Change Utility (FNDCPASS or AFPASSWD) (Doc ID 437260.1)

              • 4. Re: unable to change EBS R12.1.3 apps password using FNDCPASS
                2773452

                My issue got resolved by following : Removing Credentials from a Cloned EBS Production Database ( Doc ID 419475.1 )

                 

                Thanks.