Decrypt Password of Weblogic Domain Components

Password information’s are stored in the data file named SerializedSystemIni.dat, which is located at [DOMAIN_HOME]/security directory. This file cannot be opened in normal text mode. Encrypted passwords are used in various files like config.xml, boot.properties etc.

Using this method one can recover password for

1. weblogic Admin Console
2. KeyStore password
3. Data source Password

Process

 

1. Go to the [DOMAIN_HOME]/security

2. Create a file named Decrypt.py

 

 

3. Copy the below lines to the file and save it

 

 

from weblogic.security.internal import * from weblogic.security.internal.encryption import *    #This will prompt you to make sure you have SerializedSystemIni.dat file under #current directory from where you are running command raw_input("Please make sure you have SerializedSystemIni.dat inside the current directory, if yes press ENTER to continue.")    # Encryption service encryptionService = SerializedSystemIni.getEncryptionService(".") clearOrEncryptService = ClearOrEncryptedService(encryptionService)    # Take encrypt password from user pwd = raw_input("Please enter encrypted password (Eg. {3DES}Bxt5E3...): ")    # Delete unnecessary escape characters preppwd = pwd.replace("\\", "")    # Decrypt password                 print "Your password is: " + clearOrEncryptService.decrypt(preppwd)

 

4. Go to [DOMAIN_HOME]/bin

5. Run  . ./setDomainEnv.sh

 

 

6. Go to the [DOMAIN_HOME]/security and run the below command

 

Java weblogic.WLST Decrypt.py

 

 

 

Note: Only the password from that domain can be retrieved. Password from other domain cannot be retrieved.

 

 

 

 

 

 

Approval Workflow assignment not showing in “Pending Approval”, but visible from “Inbox” - OIM PS3

Problem Description:

After migrating OIM to PS3 from any previous version it was observed that, for all newly created SOA composite workflow assignment not getting visible in “Pending Approval” tile. But it is visible in “Inbox”. This problem occurred only with the newly created composites, not with any existing one, even if they are redeployed.

Reason:

In OIM PS3, there are some VIEWs created for displaying different types of pending approval tasks like below. These VIEWs are located in SOAINFRA schema.

In general, during SOA workflow composites deployment, the NameSpace url get registered with this view in order to display the pending approval task in the “Pending Approval” tile.

NameSpace URL

targetNamespace=http://xmlns.oracle.com/ApprovalApp/CustomManagerApproval/ApprovalTask

After upgrading OIM to PS3 from any previous version, this NameSpace url of newly created composites not getting registered with PENDING_APPROVALS_VIEW after deployment.

This problem will not occur if you install a fresh OIM PS3.

Resolution:

Register the NameSpace url of the composite manually with the PENDING_APPROVALS_VIEW. In order to perform this action, follow the below procedure:

1. Login to SOAINFRA schema (Use SQLDeveloper)
2. Open the table WFUSERTASKVIEW
3. Double Click on the BLOB and click on the pencil icon                                                   
4. Download the BLOB message in your desktop (save it as XML)       
5. Get the NameSpace url of the SOA composite from the ApprovalTask.task file and copy the same  
6. Open the BLOB message XML file and add the copied NameSapce url under the <valueList> tag as below:
7. Save the XML file.
8. Open the same SQLDeveloper and select the PENDING_APPROVALS_VIEW row of table WFUSERTASKVIEW
9. Double click on the BLOB and click on the pencil icon.
10. Click on the “Load” and select the modified XML file.       
11. Click on open the load the modified XML file.
12. Commit the changes in the database table.
13. No restart required.

Now you can see the Notification of the pending task in “Pending Approval” tile.