Oracle Weblogic Repository DB Users Password Reset

When Repository DB Schema Password  expires, then WEblogic Admin Server Could not be started, hence it will prompt following error in the Weblogic Admin  Console.

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

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLException: ORA-28000: The account is locked.


Error Code: 28000

        at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)

        at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326)

        at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138)

        at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)

        at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207)

        at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:760)

        at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:265)

        at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:731)

        at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205)

        at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305)

        at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337)

        at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303)

        at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.existsTable(JpsDBDataManager.java:1658)

        ... 85 more

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


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

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

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

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

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

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

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

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

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

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

        at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)

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

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

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

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

        at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98)

        ... 95 more


>

<Apr 28, 2023, 1:20:19,623 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED.>

<Apr 28, 2023, 1:20:19,623 AM PDT> <Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself down.>

<Apr 28, 2023, 1:20:19,623 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN.>

Stopping Derby server...

Derby server stopped.




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

Resolution:

1. Then Go to $Domain_BASE\config\jdbc and locate all files and username in them.

1.1 Open Each File and find out the User Name (if u are unware of the users)



1.2 we have to put encrypted password into these file PASSWORD TAG



2. Reset Password at the Repository Database Level (if installed in Plugable then update in plugable otherwise in normal) through SQL plus AS SYS dba

3. SINCE PASSWORD SHOULD BE IN ENCRYPTED FORM SO FOLLOW THIS TO GET THE ENCRYPTED FORM.

cd $DOMAIN_HOME/bin
. ./setDomainEnv.sh ( Source SetDomainEnv.sh)
$JAVA_HOME/bin/java weblogic.security.Encrypt
password:
<encrypted_password>

4. Execute the modification of password change in OPSS credential store:

4.1 open cmd/terminal and go to 

'C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\'

4.2 execute / run 

<oracle_home>/oracle_common/common/bin/wlst.cmd

4.3 Excute / run

wls:/offline> modifyBootStrapCredential(jpsConfigFile='jps-config-jse.xml',username='DEV_STB',password='new_pass')

wls:/offline> modifyBootStrapCredential(jpsConfigFile='jps-config-jse.xml',username='DEV_MDS',password='new_pass')

wls:/offline> modifyBootStrapCredential(jpsConfigFile='jps-config-jse.xml',username='DEV_IAU_APPEND',password='new_pass')

wls:/offline> modifyBootStrapCredential(jpsConfigFile='jps-config-jse.xml',username='DEV_IAU_VIEWER',password='new_pass')

wls:/offline> modifyBootStrapCredential(jpsConfigFile='jps-config-jse.xml',username='DEV_UMS',password='new_pass')

5. Then Go to $Domain_BASE\config\jdbc AND IN EACH RESPECTIVE FILE PASTE THE ENCRYPTED PASSWORD AND RESTART THE SERVER ADMIN SERVER


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

Comments

Post a Comment

Popular posts from this blog

Oracle Database Listener Configuration

Image
Since Listener is s Program to establish connection with the Database from other applications. Hence to establish a connection it must have a Database Service to Bind If no Service is binded then it listener will be working but showing no service in the LOG There are two type of  Service Binding in TCP/IP 1. Dynamic Service Registration Through Database . 2. Static Service Registration Through Listenr.ora .   1.  Dynamic Service Registration In this type of Registration,  service name is mapped in database in a way that, we either map listener description in the LOCAL_LISTENER parameter of the database or just add alisas in this parameter. Here I have just added the alias LOCAL_ORCLP and its detail string in mentioned in TNSNAME.ORA . You could also directly mention the string into the LOCAL_LISTENER PARAMETER Anyway, once this all is setup then we have two options to initiate the service,     1. execute the command Alter System Register     2....
Read more

Emailing With Large Text

 While using conventional PLSQL procedure, the Oracle UTL_SMTP.Write_Data have input parameter as varchar2 -- which has a limit of size, so while emailing large content through single Write_data, is not possible. so the solution is to pass the data to email through chunks. Below is the old Procedure. (Having trouble with size) CREATE OR REPLACE PROCEDURE SUPPORT_PORTAL.send_mail_html_new (    p_to            IN   VARCHAR2,    p_from          IN   VARCHAR2,    p_cc            IN   VARCHAR2,    p_bcc           IN   VARCHAR2,    p_subject       IN   VARCHAR2,    p_text_msg      IN   VARCHAR2 DEFAULT NULL,    p_attach_name   IN   VARCHAR2 DEFAULT NULL,    p_attach_mime   ...
Read more