Account is locked in DB

[Former Member]

I am not able to get in to Database through SQL because sapsr3 is locked.

Is there any way to unlock it from brtool ?

Sukrut S

[Former Member]

Hi Sukrut S,

first check SAPSR3DB is locked or unlocked status, if locked the user

unlock use the below command

ALTER USER SAPSR3DB ACCOUNT UNLOCK;

and change SAPSR3DB password using the below command from the database

ALTER USER SAPSR3DB IDENTIFIED BY <NEWPASSWORD>

Then try to change the same in configtool secure store.

Restart SAP

Login to configtool it will connect to database

Regards,

Ram

[hemanth2]

Dear Sukrut ,

Hope you are doing good.

Please first read the note below:

951167 ORA-28000: the account is locked and

562863 FAQ: Logon mechanisms (Question 7)

ALTER USER <username> ACCOUNT UNLOCK; command will be useful for this.

Set FAILED_LOGIN_ATTEMPTS to UNLIMITED. You will see how to do that reading the note above.

Then, unlock the user SAP<SID>DB.

Thank you and have a nice day :).

_____________

Kind Regards,

Hemanth

SAP AGS

[Former Member]

Hi

I unlocked the sapsr3 and sapsr3db user but still while starting the instance I am getting given below error

***********************8&******************************************

-

---

Bootstrap MODE:

<INSTANCE GLOBALS>

determined by parameter [ID0061320].

-

---

Exception occurred:

com.sap.engine.bootstrap.SynchronizationException: Database initialization failed! Check database properties!

at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:422)

at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:144)

at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:814)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

-

---

==[ Caused by: ]==----

---

*com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB. at* com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:360)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.<init>(DBConnectionPool.java:125)

at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.<init>(PersistenceHandler.java:38)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init>(ConfigurationCache.java:149)

at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:236)

at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:49)

at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:60)

at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:419)

at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:144)

at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:814)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

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

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

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

at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:790)

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

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

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

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

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

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:285)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:302)

... 14 more

[Bootstrap module]> Problem occurred while performing synchronization.

[hemanth2]

Dear Sukrut,

Hope you are doing good.

Once the account is unlocked, you need to update the JAVA config tool secure store with the password and restart the server.

Thank you and have a nice day :).

_____________

Kind Regards,

Hemanth

SAP AGS

[Former Member]

If I understand clearly, You need to unlock open sessions in DB (ask to your Dba)

[Former Member]

Hi,

No, you can not unlock users with brtools. You can do it with ALTER USER command from SQL prompt as ORASID,

Ex: SQLPLUS /NOLOG

CONNECT /AS SYSDBA

ALTER USER SAPSR3 ACCOUNT UNLOCK;

Regards

Praveen