Wednesday, February 22, 2017

unable to mount iphone in ubuntu after ios10 upgrade

Refer this below link,It works

https://gist.github.com/samrocketman/70dff6ebb18004fc37dc5e33c259a0fc

Sunday, August 7, 2016

Convert accountexpires in Active Directory to Human Read format using Excel


=IF(C2>0,C2/(8.64*10^11) - 109205,"")

This formula works for GMT.



If your time zone is GMT+10, subtract 10/24 (with 7-8 decimals) leading to 109204.58333333

If it is GMT-10, Add 10/24 leading to 109205.0.416666666666667.

Tuesday, August 2, 2016

Oracle Identity Manager OIM : How to pre populate process form with OIM User Data

Go To Design Console and Click Adapter Factory and create a prepopulate adapter. 

Adapter Name: OID Prepop String
Adapter Type: Pre-populate Rule Generator
Description: Pre-Populate String Fields

Save

Click on Variable List tab and add a variable:

Variable Name: attrvalue
Type: String
Description: value to be prepopulated
Map To: Resolve at runtime

Save

Click on Adapter Tasks and click Add
Logic Task
SET VARIABLE

Adapter return value = attrvalue

Save and click Build

2. Go Back to Form Designer and find the process form

Create a new version and click on Pre-populate tab.

For each field that you want to prepopulate add the prepop adapter;
Eg:
Field Name: EndDate
Rule:Default
Adapter: OID Prepop String
Order: 1
Map the variable to the User Definition ->EndDate

Do the same for all other fields.

Make the new version of the form ACTIVE.

3. Go to access policy,  Remove the resource form and add it back.as it will pick up the new form version in the access policy.

4. At this point, the adapters should be firing when the access policy provisions the resource and the values from the user definition will be in the process form.

Friday, July 22, 2016

Unable to start second OIF server through EM


Unable to start Oracle Identity Federation using EM Console

Error:

weblogic.application.ModuleException: [HTTP:101216]Servlet: "spmanager" failed to preload on startup in Web application: "/fed".

java.lang.RuntimeException: The server could not initialize properly: oracle.security.fed.sec.util.KeySourceException: Invalid/unsupported key store or incorrect password. Please verify that the password is correct and the store is a valid PKCS#12 PFX wallet or Java KeyStore file.

Solution

Need to set below settings in the nodemanager.properites file 
CrashRecoveryEnabled=true 
StartScriptEnabled=true 

This Worked for me

Alternate Solution

The Keystore entries might be different on OIF Nodes. Config.xml has entries for keystore and it should be same on both the nodes.

1) Copy the config.xml file from from Node 1 -> Node 2.
2) Start the weblogic server with below mentioned command on Node 2.

$MW_HOME//bin/startManagedWebLogic.sh

Tuesday, July 12, 2016

Export MDS for OIM ( Oracle Identity Manager)


  • Login to Enterprise Manager console using a browser as a weblogic User
  • Go to the left pane, expand "Farm_base_domain"  ->"Identity and Access" -> "OIM"
  • Right-click  "oim(11.1.2.0.0)" and select "System MBean Browser".
  • Expand  the following "Application Defined MBeans" -> "oracle.mds.lcm" -> "Server: oim_server1" -> "Application=OIMMetadata" -> "MDSAppRuntime"
  • Click on "MDSAppRuntime" -> click on "Operations" tab.
  • Click on "exportMetadata"
  • Fill "toLocation" with a directory name (for example "/tmp/")
  • Change "createSubDir" to "True"
  • Click "Invoke".

Wednesday, June 29, 2016

Oracle Identity Manager SQL Queries


SQL Query  to check Account Status

select usr.usr_login,usr.usr_key,ost.ost_status,obj.obj_name,oiu.obi_key
from OST INNER JOIN (OBJ INNER JOIN (OBI INNER JOIN (USR INNER JOIN OIU on oiu.usr_key = usr.usr_key)
on obi.obi_key = oiu.obi_key)
on obj.obj_key = obi.obj_key)
on ost.ost_key = oiu.ost_key
where usr.usr_login = 'XXXXX';

Checks the Policy Evaluation Queue

SELECT USR.USR_KEY,
USR.USR_LOGIN,
USR.USR_STATUS,
USER_PROVISIONING_ATTRS.POLICY_EVAL_NEEDED ,
USER_PROVISIONING_ATTRS.POLICY_EVAL_IN_PROGRESS
FROM USER_PROVISIONING_ATTRS USER_PROVISIONING_ATTRS ,
USR USR
WHERE USER_PROVISIONING_ATTRS.USR_KEY = USR.USR_KEY
AND USER_PROVISIONING_ATTRS.POLICY_EVAL_NEEDED =1
AND USER_PROVISIONING_ATTRS.POLICY_EVAL_IN_PROGRESS != 1

AND USR_STATUS NOT IN ('Deleted','Disabled','Rejected','Disabled Until Start Date');

Query to find Audit Records

select * from upa_fields where upa_usr_key in (select upa_usr_key from upa_usr where usr_key ='XXXXX') order by update_date;


Thanks to Vasanth for Sharing these queries ,

user weblogic soft locked

Fix:
Stop all the servers including Adminserver.
Connect with OIM Schema to the database in my case it was PROD_OIM query usr table and you can find the USR_LAST_NAME (WEBLOGIC) is locked.

Manually
update the column like update PROD_OIM.usr set USR_LOCKED=0 where USR_LAST_NAME='WEBLOGIC'
update DEV1_OIM.usr set  USR_LOGIN_ATTEMPTS_CTR=0 where USR_LAST_NAME='WEBLOGIC'
update DEV1_OIM.usr set USR_LOCKED_ON = null where USR_LAST_NAME='WEBLOGIC'

And restart Admin server.