8 Replies Latest reply: May 16, 2013 3:08 PM by Zeeshan BaiG RSS

    ORA - 28000 account is locked

    Shiry
      Hi,

      I've faced ORA-28000 Error after resetting schema password here are the steps I've followed

      1- First I faced Error 28001 "Schema Password expired "
      2- then i rest schema password and changed it from weblogic console Service -> data source -> Connection pool
      3- Restarting Admin server , OIM and SOA Managed servers
      4- i faced Error 28000 " Account is locked and could create connection pool "
      5- i've checked the DB schema and we find the only locked account is DEV_MDS

      here is the Error LOG

      [2013-05-15T10:40:02.597+02:00] [soa_server1] [NOTIFICATION] [] [oracle.mds] [tid: MDSPollingThread-[soa-infra, jdbc/mds/MDS_LocalTxDataSource]] [userId: <anonymous>] [ecid: 0000Jd4qQu7B_65LRQw0yd1GSyrr000002,0] [APP: soa-infra] [[
      oracle.mds.exception.MDSRuntimeException: java.sql.SQLException: Data Source mds-soa does not exist.
      Data Source mds-soa does not exist.
           at oracle.mds.internal.persistence.db.BaseReposAccess.<init>(BaseReposAccess.java:395)
           at oracle.mds.internal.persistence.db.shredded.ShreddedReposAccess.<init>(ShreddedReposAccess.java:281)
           at oracle.mds.internal.persistence.db.shredded.ShreddedDBMSConnection.createReposAccess(ShreddedDBMSConnection.java:445)
           at oracle.mds.internal.persistence.db.BaseDBMSConnection.getOrCreateReposAccess(BaseDBMSConnection.java:2549)
           at oracle.mds.internal.persistence.db.BaseDBMSConnection.queryStoreForLatestCommitNumber(BaseDBMSConnection.java:2990)
           at oracle.mds.internal.persistence.db.DBPChangeProvider.queryStoreForLatestCommitNumber(DBPChangeProvider.java:468)
           at oracle.mds.internal.persistence.db.DBPChangeProvider.getChanges(DBPChangeProvider.java:115)
           at oracle.mds.internal.persistence.db.DBMetadataStoreCommunicator.signalChanges(DBMetadataStoreCommunicator.java:173)
           at oracle.mds.internal.persistence.db.ChangePollingThread.run(ChangePollingThread.java:128)
      Caused by: oracle.mds.internal.persistence.db.fcf.MDSDBIOException: java.sql.SQLException: Data Source mds-soa does not exist.
      Data Source mds-soa does not exist.
           at oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl.fetchConnection(JNDIConnectionManagerImpl.java:102)
           at oracle.mds.internal.persistence.db.ConnectionManager.getConnection(ConnectionManager.java:347)
           at oracle.mds.internal.persistence.db.BaseReposAccess.<init>(BaseReposAccess.java:382)
           ... 8 more
      Caused by: java.sql.SQLException: java.sql.SQLException: Data Source mds-soa does not exist.
           at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:259)
           at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:352)
           at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:369)
           at oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl.fetchConnection(JNDIConnectionManagerImpl.java:97)
           ... 10 more
      Caused by: java.sql.SQLException: Data Source mds-soa does not exist.
           at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:100)
           at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:350)
           ... 12 more

      ]]
      [2013-05-15T10:40:32.800+02:00] [soa_server1] [NOTIFICATION] [] [oracle.mds] [tid: MDSPollingThread-[soa-infra, jdbc/mds/MDS_LocalTxDataSource]] [userId: <anonymous>] [ecid: 0000Jd4qQu7B_65LRQw0yd1GSyrr000002,0] [APP: soa-infra] [[
      oracle.mds.exception.MDSRuntimeException: java.sql.SQLException: Data Source mds-soa does not exist.
      Data Source mds-soa does not exist.
           at oracle.mds.internal.persistence.db.BaseReposAccess.<init>(BaseReposAccess.java:395)
           at oracle.mds.internal.persistence.db.shredded.ShreddedReposAccess.<init>(ShreddedReposAccess.java:281)
           at oracle.mds.internal.persistence.db.shredded.ShreddedDBMSConnection.createReposAccess(ShreddedDBMSConnection.java:445)
           at oracle.mds.internal.persistence.db.BaseDBMSConnection.getOrCreateReposAccess(BaseDBMSConnection.java:2549)
           at oracle.mds.internal.persistence.db.BaseDBMSConnection.queryStoreForLatestCommitNumber(BaseDBMSConnection.java:2990)
           at oracle.mds.internal.persistence.db.DBPChangeProvider.queryStoreForLatestCommitNumber(DBPChangeProvider.java:468)
           at oracle.mds.internal.persistence.db.DBPChangeProvider.getChanges(DBPChangeProvider.java:115)
           at oracle.mds.internal.persistence.db.DBMetadataStoreCommunicator.signalChanges(DBMetadataStoreCommunicator.java:173)
           at oracle.mds.internal.persistence.db.ChangePollingThread.run(ChangePollingThread.java:128)
      Caused by: oracle.mds.internal.persistence.db.fcf.MDSDBIOException: java.sql.SQLException: Data Source mds-soa does not exist.
      Data Source mds-soa does not exist.
           at oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl.fetchConnection(JNDIConnectionManagerImpl.java:102)
           at oracle.mds.internal.persistence.db.ConnectionManager.getConnection(ConnectionManager.java:347)
           at oracle.mds.internal.persistence.db.BaseReposAccess.<init>(BaseReposAccess.java:382)
           ... 8 more
      Caused by: java.sql.SQLException: java.sql.SQLException: Data Source mds-soa does not exist.
           at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:259)
           at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:352)
           at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:369)
           at oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl.fetchConnection(JNDIConnectionManagerImpl.java:97)
           ... 10 more
      Caused by: java.sql.SQLException: Data Source mds-soa does not exist.
           at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:100)
           at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:350)
           ... 12 more

      ]]
      [2013-05-15T10:41:02.944+02:00] [soa_server1] [NOTIFICATION] [] [oracle.mds] [tid: MDSPollingThread-[soa-infra, jdbc/mds/MDS_LocalTxDataSource]] [userId: <anonymous>] [ecid: 0000Jd4qQu7B_65LRQw0yd1GSyrr000002,0] [APP: soa-infra] [[
      oracle.mds.exception.MDSRuntimeException: java.sql.SQLException: Data Source mds-soa does not exist.
      Data Source mds-soa does not exist.
           at oracle.mds.internal.persistence.db.BaseReposAccess.<init>(BaseReposAccess.java:395)
           at oracle.mds.internal.persistence.db.shredded.ShreddedReposAccess.<init>(ShreddedReposAccess.java:281)
           at oracle.mds.internal.persistence.db.shredded.ShreddedDBMSConnection.createReposAccess(ShreddedDBMSConnection.java:445)
           at oracle.mds.internal.persistence.db.BaseDBMSConnection.getOrCreateReposAccess(BaseDBMSConnection.java:2549)
           at oracle.mds.internal.persistence.db.BaseDBMSConnection.queryStoreForLatestCommitNumber(BaseDBMSConnection.java:2990)
           at oracle.mds.internal.persistence.db.DBPChangeProvider.queryStoreForLatestCommitNumber(DBPChangeProvider.java:468)
           at oracle.mds.internal.persistence.db.DBPChangeProvider.getChanges(DBPChangeProvider.java:115)
           at oracle.mds.internal.persistence.db.DBMetadataStoreCommunicator.signalChanges(DBMetadataStoreCommunicator.java:173)
           at oracle.mds.internal.persistence.db.ChangePollingThread.run(ChangePollingThread.java:128)
      Caused by: oracle.mds.internal.persistence.db.fcf.MDSDBIOException: java.sql.SQLException: Data Source mds-soa does not exist.
      Data Source mds-soa does not exist.
           at oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl.fetchConnection(JNDIConnectionManagerImpl.java:102)
           at oracle.mds.internal.persistence.db.ConnectionManager.getConnection(ConnectionManager.java:347)
           at oracle.mds.internal.persistence.db.BaseReposAccess.<init>(BaseReposAccess.java:382)
           ... 8 more
      Caused by: java.sql.SQLException: java.sql.SQLException: Data Source mds-soa does not exist.
           at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:259)
           at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:352)
           at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:369)
           at oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl.fetchConnection(JNDIConnectionManagerImpl.java:97)
           ... 10 more
      Caused by: java.sql.SQLException: Data Source mds-soa does not exist.
           at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:100)
           at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:350)
           ... 12 more

      Edited by: Shereen Reda on May 15, 2013 7:39 AM
        • 1. Re: ORA - 28000 account is locked
          Shiry
          Please i need support ASAP where i couldn't access identity manager console any more !

          Thanks
          • 2. Re: ORA - 28000 account is locked
            Shiry
            Please i need support ASAP where i couldn't access identity manager console any more !

            Thanks
            • 3. Re: ORA - 28000 account is locked
              Saurabh Tripathi
              Hi,

              You can check the data source connection from WLS console. There is some issue with the data source connection.
              Test the connection by choosing Admin Server as the target.

              Thanks,
              Saurabh
              • 4. Re: ORA - 28000 account is locked
                delhi
                Was it there before? If not, then try creating it using WLS Console and restart your servers.

                Also, these schema is not used by OIM.
                • 5. Re: ORA - 28000 account is locked
                  Shiry
                  Hi ,

                  I've followed the below steps to update schema password please let me know if there is something wrong      


                  1- Through web console I Navigated to Datasources "Summary of JDBC Data source " -> configuration then i ve changed schemaaa password for all the below data sources


                  EDNDATASource
                  EDNLocalTxDataSource
                  mds-oim
                  mds-owsm
                  mds-soa
                  oimJMSStoreDS
                  oimOperationsDB
                  OraSDPMDataSource
                  SOADataSource
                  SOALocaLTxtDataSource

                  2- In the WebLogic Administrative console, navigate to Security Realms, myrealm, and then Providers.
                  - Click OIMAuthenticationProvider
                  - Click Provider Specific.
                  -In the DBPassword field, enter the new Oracle Identity Manager database schema password

                  3. Change domain credential store configuration:
                  - Login to Enterprise Manager by using the following URL http://ADMIN_SERVER/em
                  - Navigate to Weblogic Domain, and then DOMAIN_NAME.
                  - Right click oim, and navigate to Security, Credentials, and then oim.
                  - Select OIMSchemaPassword, and click Edit.
                  - In the Password field, enter the new password, and click OK

                  4. Restart the WLS AdminServer

                  5. Start the SOA managed server
                  • 6. Re: ORA - 28000 account is locked
                    Shiry
                    I got same error each time ( Error 28000 " Account is locked and could create connection pool " )

                    any advise please
                    • 7. Re: ORA - 28000 account is locked
                      delhi
                      Have you tried shutting down your appilcation, get the db accounts unlocked and reset password if required and then starting them again?
                      • 8. Re: ORA - 28000 account is locked
                        Zeeshan BaiG
                        you have to reset password of database users in your repository.

                        Run the following commands on database servers using SYSDBA account

                        1.
                        alter user DEV_MDS identified by newpassword;
                        alter user DEV_MDS account unlock;
                        Repeat the above command for all other repository users

                        2. Login to weblogic console and update the passwords in Connection Pool settings of JDBC data sources

                        3. Restart your weblogic server including all managed servers.

                        Hope it helps,
                        Zeeshan

                        Edited by: Zeeshan BaiG on May 16, 2013 3:08 PM