How To Integrate Microsoft's Active Directory with Oracle Webcenter Cotnent -11g?

GOOD DAY,,,

In a production system, Oracle Enterprise Content Management Suite applications need to use an external Lightweight Directory Application Protocol (LDAP) authentication provider. You need to re-associate the identity store for your application with one of the following external LDAP authentication providers before you complete the configuration of a Managed Server, before you connect a Managed Server to a repository, and before the first user logs in to the application:

Unlike the previous versions, LDAP provider needs to be configured in Weblogic server NOT IN UCM.

Steps to integrate Microsoft's active directory is as follows:

1) Login to weblogic console of the domain and navigate to 'Domain Structure' 
    as given below

 2) On click of 'Security Realms, following page appears

 3) Click on 'myrealm'  and the following page appears

                            Click on 'Providers' link as marked above

4) Providers page appears

                            Select 'New' to create a new providers

5) Screen to enter their 'Name' and 'Type' for the new provider appears

For active directory the type should be : ActiveDirectoryAuthenticatorLDAP 

Authentication Provider                    Authenticator Type

Microsoft AD                                       ActiveDirectoryAuthenticator

                                                 Click 'Ok'

                                                   

6)  Settings for 'my realm' appears as given below.                                               The newly created  provider should be the first on in the list. To do that, we 

     need to reorder the listing of providers using ‘Reorder’.

     

     Reorder page appears as given below

     
     Using the arrow buttons, move the newly created provider to the top of the 
     list and click 'Ok'

On clicking 'Ok' , providers list will be updated as given below

7)   Click on the newly created provider name and ‘Settings for

      page gets displayed.

     

     Select 'Control Flag' as 'Sufficient' for the newly created provider and click 

     'Save'.

 8)  After changing the control flag and saving the settings click on ‘Provider 

      Specific’ tab in the same page.

      

    ‘Settings’ page for the new provider  gets displayed as given below

 9) To connect the specific provider, we need to provide the details Set Provider 

     Specific values in the following fields, and leave default values in the other 

     fields:

     Set connection Details

     . Host: The host name or IP address of the LDAP server.

    . Port: The Oracle Internet Directory Port, 389 by default.
    . Principal: The Distinguished Name (DN) of the LDAP user that Oracle 
      WebLogic Server should.

    . use to connect to the LDAP server; for example:
    . cn=orcladmin
    . Credential: The credential used to connect to the LDAP server (usually a 
      password).
    . Confirm Credential: The same value as for the Credential field.

      User Details

      . User Base DN: The base distinguished name (DN) of the tree in the LDAP 
       directory that contains users; for example: cn=users,dc=example,dc=co   
     . Note: Use an exact DN rather than a top-level DN. Using a top-level DN 
       would provide access to all the default users and groups under the DN, 
       giving access to more users than required by the application.

     . Use Retrieved User Name as Principal: Specifies whether or not the user   
       name retrieved from the LDAP server should be used as the Principal value.

       Group Details

      . Group Base DN: The base distinguished name (DN) of the tree in the LDAP 
        directory that contains groups; for example:

                 cn=groups,dc=example,dc=com

     After specifying connection, users and groups details. click on 'save' to save all the details.

10) Go back to the list of providers screen (my realm page) and click on the 

      default provider as give below

      ‘Settings’ page for the default provider opens as given below Change the control flag for the ‘default provider’ to ‘Sufficient’ and click ‘Save’

11) Restart the admin server using windows service

12) Re login to admin server

13) Navigate to ‘my realm’ page as given below and click on ‘Users and Groups’ 

      tab

                               

14)  Users and Groups gets displayed as given below 

                                                                         Groups 

  Verify whether the user names/groups  listed above are coming from the 

   newly configured provider by checking the ‘Provider’ column for each user as 

   given in the screen shot. 

15) The next step is to map the groups from AD to UCM/Oracle   
       Webcenter Groups 
         For that we need to create 'Roles' in Oracle Webcenter Content , 
      with the same name as that of Groups

             As given the screen shot above, we need to create Roles and assign rights to them.

16) The next steps is to map the groups to these roles using credential mapping

For that we need to create a credential mapping as given below

      Once the credential mapping is added as given above, an entry for the 

      mapping should be added into the providers For that  navigate to the 

      provider.hda file for jps provider located at   

      

"domain_name"ucm/cs/data/providers/jpsprovider

      There in add the following variable: 

      ProviderCredentialsMap="map name created above"

      Save the file and restart UCM server . 

17) Once the servers are restarted, login to Oracle Webcenter Content with the 

      AD users and verify the access rights. 

Enjoy,

Mohammad K. Faidi
  "Think Positive"

How to upgrade Oracle Webcenter Content from 11.1.1.5 to 11.1.1.8?

GOOD DAY,,,

To upgrade Oracle WebCenter Content from 11.1.1.5 to 11.1.1.8 there are some important steps to do so, please go inside these instructions,,,

Pre Upgrade Steps:

1. Download Oracle Webcenter Content 11.1.1.8 from my oracle support

    ofm_wcc_generic_11.1.1.8.0_disk1_1of2.zip

    ofm_wcc_generic_11.1.1.8.0_disk1_2of2.zip
2. Upgrade Oracle Weblogic to 10.3.6  
3. Backup Oracle ECM  home folder , Inventory directory and database.

4. Shutdown below services:

    Admin Server , All Manage server and Node Manager.

5. Unzip the patch. 
6. Now we can go through the upgrade steps.

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

Upgrade Oracle ECM Home:

1. Use the command prompt to run runinstaller setup.exe from 

    UCM11.1.18/Disk1 and don't forget to determine the location of the JDK 

    directory.

2. On Welcome Screen click Next.

3. Select radio button Skip Software Updates and click Next.

4.  Make sure it passes all per-requisites checks. Once done click Next.

5. In the Specify Installation Location screen make sure the Oracle Middleware 

    Home and Oracle HomeDirectory are correct for the WCC

    Oracle Home Directory=Oracle_ECM1(Default name)

    Oracle Middleware Home=$MW_HOME

6. Click Yes to confirm with Upgrade.

7. In the Application Server screen the Weblogic Server radio button should be 
    checked, click the Next button.

8.  In the Installation Summary screen click the Install button.
9.  When the Progress is 100% click the Next button.

10. Click the Finish button.

-----------------------------------------------------------------------------------
Upgrade Web Center Content Schema:

1. Execute ./psa from $MW_HOME/oracle_common/bin in GUI mode.

2. Click Next

3. In Select Component field select the schema that you wish to upgrade . In 
    our case we had only OCS schema and hence only that was selected and 
    click Next.

4. Make sure per-requisites are completed and click Next.

5. In Content Server Directory , browse domain location of content server.
    Eg:$MW_HOME/user_projects/domain/$DOMAIN_NAME.

6. Enter schema details for 'XXX_OCS' user
    Connect String: DBHostaName:DBPort/DBName
    DBA User Name: sys as sysdba
    DBA Password : Password for sysdba
    Schema User Name : Dropdown list and select 'XXX_OCS' user
    Schema Password : Password of 'XXX_OCS' user

7.  Click Next once succeeded.

8. Confirm everything and click Upgrade.
9. Check status and once 100% completed,click Done.

10. Login to database and confirm that 'XXX_OCS' schema has been upgraded 

      to 11.1.1.8 with below command: 

     "Select owner,version,status,upgraded from schema_version_registry"

      Expected Output:

      XXX_OCS                        11.1.1.8.0                     VALID       Y

Enjoy,

Mohammad K. Faidi
  "Think Positive"

How to export or migrate a specific folders from your folder structure in oracle webcenter content with or without contents?

GOOD DAY,,,

In Some cases, you need to export or migrating a specific folders from your folder structure with their contents or sometimes without their contents from one WebCenter Content instance to another. 

In this Post the folder architecture in this example is Folders_g. Although Framework Folders is the recommended folders component for WebCenter Content 11g. 

To prepare, you must first have the FoldersStructureArchive component enabled on both the source and target instances.  

In addition to enabling the component, there is a configuration flag to set.  By default, the config variable ArchiveFolderStructureOnly is set to false which means content will be exported along with the folders, so that can be left.

The config variable AllowArchiveNoneFolderItem is set to true by default which means it will export content both in the folder structure as well as those not selected...or even outside of folders.

Basically, it means you must use the Export Criteria in the archive to control the content to export either you want or you don't want to export any contents with the selected folders you can use Export query. 

In our use case, we only want the content within the folders we select, so the configuration should be set as AllowArchiveNoneFolderItem=false. Now only content that is in our selected folders will get exported into the archive. This can be set in the General Configuration in the Admin Server.

You will also need to make sure the custom metadata fields on both instances is identical. If they are mismatched, the folders will not import into the target instance correctly. You can use the Configuration Migration Utility to migrate those metadata fields. 

Once the component is enabled and configurations set we can begin our export or migrating process:
   1. go to Administration - Admin Applets - Archiver and select Edit - Add... 
       to create a new archive.  

   

2. Now that the archive is established, go back to the browser and login your webcenter 
        content then go to: 
        Administration - Folder Archiver Configuration.
        For the Collection Name, it will default to the local collection.  Change this if your 
        archive is in a different collection in our example it's ExportFoldersAndFiles.
        Select your Archive Name from the list.

   

   3. Expand the folder hierarchy and you can now select the specific folder(s) you want to 
         migrate.  

        Note: The thing to keep in mind are the parent folders to the ones you are selecting.  If 
                  the idea is you want to migrate a certain section of the folder hierarchy to the 
                  other server and you want it to be in the same place in the target instance, you 
                  want to make sure that the parent folder already exists in the target.  It is 
                  possible to migrate a folder and place it within a different parent folder in the 
                  target instance, but then you need to make sure you set the import maps 
                  correctly to specify the destination folder.

   

   4. Once they are selected, click the Add button to save the configuration.  This will add 

         the right criteria to the archive. 

   5.  Now go back to the Archiver applet.  Highlight the archive and select Actions - Export. 

        Be sure 'Export Tables' is selected.  

       Note: If you try using the Preview on either the contents or the Table data, both will 

                show everything and not just what you selected. This is normal. The filtering of 

                content and folders is not reflected in the Preview. Once completed, you can click 

                on the View Batch Files... button to verify the results. You should see an entry for 

                the Collections_arTables and one or more for the content items.  

   6. Once you have the archive exported, you need to transfer it from the source to the 

       target instance.

       Important Note: If you don't have the outgoing providers set up or your target server on 

                                 another server that you don't have any connection to do the transfer, 

                                 you can sometimes copy over the archive folder from 

                                 (cs instance dir)\archives\(archive name) directly over to the other 

                                 instance. Then manually modify the collection.hda file on the target to

                          let it know about the archive for more details about this step

                          please read my post "Export contents from oracle UCM instance 

                                 and import them into deferent UCM instance server without using 

                                 replication or transferring data "Click here to Read more". 

   7. Before import you need to edit value map - "Edit Value Maps", here you can add your 

      query map values into your target server. 

      Important Note: Be sure to add the value of the dCollectionID of the parent 

                                       folder from the source instance in the Input Value, For the Field, 

                                       you want to change this to be the dParentCollectionID. And for 

                                       the Output Value, you want this to be the dCollectionID of 

                                       the parent folder in the target instance.

    

   This will now map the folders into the correct location on target.

   8. The archive is now ready to be imported.  Click on Actions - Import and be sure the 

         'Import Tables' check-box is checked.  

         

                           

Enjoy,

Mohammad K. Faidi
  "Think Positive"