SOA - Hello World SOA Composite Application.

Prerequisite: Oracle SOA Composite Extension should be installed in your JDeveloper.

 

Create new SOA Application by going to File > New Application. Select the SOA Application from the Items list. 

Provide the application name and package prefix and then click next.

Provide the project name and click next.

Select Empty Composite and then click Finish.

Now we can see, SOA Application got created.

Select the BPEL Process from the Service Components palette and drop the same into the Components area which is in the center of the work-area. A dialog will appear which will need some inputs. Provide the same as shown in the snapshot below.

The BPEL process will be added and the composite will look like the snapshot shown below.

On double clicking the BPEL process the following screen is displayed. "receiveInput" is a receive activity and is used to receive the input from the client and store it in an input variable. "replyOutput" is an invoke activity that will return the output back to the client through sayhelloworldbpelprocess partner link.

Now from component palette drag and drop one assign activity between receive and invoke activity. This activity provides a method for data manipulation, such as copying the contents of one variable to another. Copy operations enable you to transfer information between variables, expressions, endpoints, and other elements.

Double click on the Assign1 component and drill down to the outputVariable/payload/processResponse/result in right hand side.

Click on the result and select ‘Expression’ from the popup menu. Type the below mentioned code in the Expression window.

 

concat("Hello", bpws:getVariableData('inputVariable','payload','/client:process/client:input')

 

Click on Apply and OK and then click on the File > Save All menu option. This will save all the changed files.

Once the files are saved now you can deploy the SCA composite.

Deploy using a SAR file i.e. a SOA Archive (SAR). The archive file extension is JAR. The below snapshots show the SAR file creation process.

On clicking the Finish button the SCA Application is compiled and then the artifacts are packaged into a jar file. If there are any errors the same are displayed in the Messages log. If there are no errors then the SCA archive can be found at location ${WORKSPACE_DIR}/${PROJECT_NAME}/deploy.

 

Once the SAR file is ready we can now proceed with deploying the SCA Application in the SOA Server.

 

Login to Enterprise Manager(http://<HOST_NAME>:7001/em).

 

Expand Weblogic farm base domain from Enterprise Manager. (Farm_base_domain -> SOA -> soa-infra)

 

Select and right click on “soa-infra" and then select SOA Deployment -> Deploy

 

 

On the “Select Archive” page, choose “Archive is on the machine where this web browser is running” option, browse the composite to upload and then click “Next”.

Select "default" and then click "Next".

Click on "Deploy" button.

Composite has been successfully deployed.

The SCA application when successfully deployed can be tested using EM console.

 

Click on the Test button as shown in the snapshot.

The test webservice window opens as can be seen in the snapshot below. Since my SCA application needs only one input of type string the same can be seen as a textbox in the snapshot below in the payload section.

Now we can see output in Response tab.

Happy Learning!!!

OIM 11g - Exporting MDS Data Using EM Console.

 

Exporting OIM(Oracle Identity Manager) MDS Data :-

Login to Enterprise Manager(http://<HOST_NAME>:7001/em).

 

 

Select Identity and Access>OIM>oim(11.1.2.0.0)

 

 

Select System MBean Browser > Application Defined MBeans from Oracle Identity Manager dropdown.

 

 

Browse to: Application Defined MBeans >  oracle.mds.lcm > Server:oim_server1 > Application:OIMMetadata > MDSAppRuntime > MDSAppRuntime and navigate to Operations tab and then click “exportMetadata”.

toLocation : Enter complete path where repository will be exported in text box.

Note : Leave all parameters as default.

Click on Invoke button.

 

Exporting SOA MDS Data :-

 

- Login to Enterprise Manager.
- Go to Farm_base_domain>SOA>soa-infra

- Go to Administration>MDS Configuration from SOA infrastructure drop down

 

 

Select “Export metadata documents to a directory or archive on the machine where this application is running” and Enter complete path where repository will be exported in text box. 

 

Click the Export button.

 

 

 

 Happy Learning!!!

OIM - How to change schema password when it got expired.

To view schema name and status: 

 

SELECT username, account_status FROM dba_users;

 

Change Schema Password:

 

Case 1: If password is known to you :-

For 11gR2PS3 :
ALTER USER <Schema_Name>_OIM IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_OPSS IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_ORASDPM IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_SOAINFRA IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_BIPLATFORM IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_MDS IDENTIFIED BY <Password>;

For 11gR2PS2 and 11gR2PS2 :
ALTER USER <Schema_Name>_OIM IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_OPSS IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_ORASDPM IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_SOAINFRA IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_MDS IDENTIFIED BY <Password>;


Case 2: If you do not know old password and you want to set same password :-

To view old password:
select password from user$ where name='<Schema_Name>_OIM';
<9DFEB538BA32F694>

For 11gR2PS3 :
ALTER USER <Schema_Name>_OIM IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_OPSS IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_ORASDPM IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_SOAINFRA IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_BIPLATFORM IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_MDS IDENTIFIED BY <9DFEB538BA32F694>;

For 11gR2PS2 and 11gR2PS2 :
ALTER USER <Schema_Name>_OIM IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_OPSS IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_ORASDPM IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_SOAINFRA IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_MDS IDENTIFIED BY <9DFEB538BA32F694>;

How to Unlock OIM Schema.

To view schema name and status:

SELECT username, account_status FROM dba_users;

Unlock Schema:

ALTER USER <Schema_Name>_OIM ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_MDS ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_OPSS ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_ORASDPM ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_SOAINFRA ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_BIPLATFORM ACCOUNT UNLOCK;

SOA - Configuring BPEL Process Service Engine classpath.

The extra classpath need to be set when compiling bepl generated java source.

 

Login to the em(Enterprise Manager) console and then go to the BEPL Properties as shown in below screen shot:

 

Go to More BEPL Configuration Properties... 

Click on BpelcClasspath.

 

 

Put required classpath in highlighted text box.

Sample value:

MW_HOME/oracle_common/modules/oracle.jps_11.1.1/jps-api.jar:/MW_HOME/oracle_common/modules/oracle.jps_11.1.1/jps-manifest.jar:/MW_HOME/Oracle_IDM1/server/client/oimclient.jar

Click Apply.

 Happy Learning!!!

OIM Bulk Load Utility - Load Role Membership.

To load Roles Membership in OIM, follow the below steps:

 

Step 1: Copy the “oimbulkload” folder from OIM machine to database machine (i.e. the machine where Oracle database is installed and used by OIM). If database is on the OIM machine itself then skip this step.

 

The oimbulkload folder is present in the following location:

          MW_HOME/Oracle_IDM1/server/db/oim/oracle/Utilities/oimbulkload

 

 

Step 2: Create the .csv file and place it in /oimbulkload/csv_files folder.

(Some of the sample csv files are present in / oimbulkload/sample_data folder which can be used as reference).

 

 

The Rolem.csv file looks like,

 

UGP_NAME,USR_LOGIN
CRM Administrator,jbaker
CRM Administrator,abadal
AD Admin,ukumar
AD Admin,akumar

 

 

Step 3: Create a .txt file named master.txt. Enter the name of the csv file which you want to use for bulk load operation and place it in /oimbulkload/csv_files folder.

 

 

 

 

 

 

 

 

 

 

In this case, master.txt file looks like below:

 

 

 

 

 

 

 

 

 

 

 

Step 4: The following variables need to be set before we execute the bulk load script:

 

JAVA_HOME: path till jdk

eg: export JAVA_HOME=/home/oracle/jdk1.7.0_25

ORACLE_HOME: path till db_home 

eg: /home/oracle/app/oracle/product/11.2.0/dbhome_1

 

Step 5: Stop Oracle Identity Manager server.

 

Step 6: Execute bulkload script

 

Go to /oimbulkload/scripts directory and run below command :

              ./oim_blkld.sh

 

It will prompt to ask which script to run.

Select option 5. Load Role Membership.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Press enter if you have set ORACLE_HOME , otherwise give the path till DB_HOME.

 

 

 

Enter db details:

//HostIPAddress:Port/ServiceName

 

 

Enter the OIM schema user name.

 

 

Enter the OIM schema password.

 

 

Enter the OIM schema password again.

 

 

 

 

 

 

 

 

 

 

 

 

 

Select the type of input which will be used to get data. In this case, we are taking data from a csv file, so enter 2. 

 

 

 

 

 

 

 

 

 

 

Enter the file which contains the list of csv files to be used as input. In this case, enter “master.txt”.

 

Enter the name of the tablespace to be used for creating custom objects. In this case, we are using the default tablespace (R2PS2_OIM) 

 

It also gives us an option whether we want to insert log messages or not. Enter Y or N, as needed.

 

Role Memberships are created successfully in OIM.

 

 

 Happy Learning!!!