How to increase value of open_cursors and processes in Oracle DB.

Error : RCU-6107: DB Init Param Prerequisite failure for OPEN_CURSORS.

To resolve the above warning do the following:

If the database is in Linux then execute this commands on putty or vnc else it is windows then take Remote desktop connection.

 

1. Go to location : ORACLE_HOME\bin 

2. Execute following command :  

•  sqlplus.exe / as sysdba; (If database is in windows)

•  ./sqlplus / as sysdba; (If database is in Linux)

      3. Then run the command: alter system set processes=500 scope=spfile;

      4. If spfile doesn’t exist then execute following command: create spfile from pfile; and execute step 3.

      5. Then execute the command : alter system set open_cursors=800 scope=spfile;

      6. commit;

      7. shutdown immediate;

      8. startup;

 

 

To check open_cursors and processes values, execute following command:

 

         SELECT value FROM v$parameter WHERE name ='processes';

         SELECT value FROM v$parameter WHERE name ='open_cursors';

 

                          
Happy Learning!!!
      

Configure Java Connector Server in OIM.

Login to System Administrator Console and click on "IT Resource" .

Click on "Create IT Resource". 

 Provide IT Resources name and select IT Resource Type as Connector Server .

Click on “Continue”. 

Provide parameters values. 

Click on “Continue”.

Click on “Continue”.

Click on “Continue”.

Click on “Finish”.

Happy Learning!!!

How to hide attibutes from process form.

Login to Identity Self Service console with sysadmin credential and go to Sandboxes as shown in below screen shot. 

 

Go to Create Sandbox. 

Give sandbox name and click on Save and Close.

Go to Home tab.

Click on Request for Self. 

Add application instance to the cart for which you want to hide attribute from process form. 

 Click on Next button. 

Click on customize on top right corner of the Identity console.

Click on Structure tab.

Click on Edit.

Select attribute which you want to hide. 

Uncheck the Visible property.

Click on Apply. 

Click on Close button.

Go to manage sandboxes and publish sandbox.

Happy Learning!!!

OIM - How to create/delete request profile in 11gR2PS3.

Login to Identity Self Service console with sysadmin credential and go to Request for Self as shown in below screen shot.

 Add multiple catalog entities to the cart and then click on Next.

 Click on Profile. 

Enter Profile Name and then click on Save. 

Profile created successfully. 

 We can see our created profile in Request Profile tab.

 Steps to remove Request Profile :

 Click on cross symbol as highlighted below.

Click on "Yes". 

Profile removed successfully. 

Happy Learning!!!

How to add UDF i.e custom attribute to catalog in OIM 11gR2PS3.

·         Go to System Administrator console.

·         Click on Sandboxes, shown in below screen shot.

 

Click on Create Sandbox.

Give sandbox name and click on Save and Close.

Go to Catalog tab.

·         Click on create custom field.

·         Select Field Type as “Text” or "Lookup".

·         Enter Display Label field and then click on “Save and Close”.

·         Custom field is created.

·         Go to Manage sandboxes and publish that sandbox.

The custom field is now registered in the “Catalog” Table.

Now to add the custom field "AppOwner" is catalog form, follow the below steps:   

 

 

·         Login to Identity Self Service console.

·         Create a new sandbox and activate it.

Click on Request for self.

Click on the information button on any of the catalog item.

·         Click on customize on top right corner of the Identity console.

Click on Structure tab.

Click on Edit.

·         Click on the area containing these text fields and then click on add symbol.

·         Open Data component-Catalog.

·         Open EditCartItemsVO.

·         Search for added custom field and click on Add.

·         Select the option : ADF Input text with label.

Click on Close button.

Select added custom field and then click edit icon.

Set EL expression for Value Change Listener. 

 

Enter below EL expression:

#{backingBeanScope.catReqBean.inputTextChangeListener}

Apply the changes.

Click on Close button.

·         Go to manage sandboxes and publish sandbox.

We can see, "AppOwner" custom field added successfully.

Related Posts :
OIM 11g R2 PS3 - Create UDF(User Defined Field) or Custom Field in Role Form
OIM 11g R2 PS3 - Create UDF(User Defined Field) or Custom Field in User Form



Happy Learning!!!