Tuesday, September 27, 2011

How to apply patchset 11gR1PS4 to Oracle WebCenter 11gR1PS3 for Windows?

Patching Scope
This guide will cover the patching information of following products:-
- Oracle Weblogic Server 11gR1PS3 (PS#12395560)
- Oracle WebCenter 11gR1PS3 (PS#12395099)
- Oracle Universal Content Management 11gR1PS3 (PS#12395130)

Patching Pre-requisits
1. Must have a Oracle Support account that have downloading permission
2. Your existing Oracle WebCenter is up and running properly. 
3.  Download the Oracle WebLogic Server 11gR1PS4
4. Download the Oracle Fusion Middleware (WC & ECM) 11gR1PS4 from

Patching Instructions
1. Stop all the servers.
2. Take the backup of Oracle Homes, oracle_common and domain directories
Following diagram will explain the high level steps for this patching process:-

 2. Run the wls1035_upgrade_win32.exe file. Here you need to specify the Middleware home of your weblogic.
3. Run the Patch Set Assistant in order to patch the MDS Schemas using following command:-
ORACLE_HOME\bin\psa.bat -dbType Oracle -dbConnectString //localhost:1521/xe -dbaUserName sys -schemaUserName DEV_MDS
Note:- For WebCenter PS3, you only need to update MDS schema.
4. Merge downloaded directories (disk1 and disk2) of ECM patchset into one single directory and run the Oracle ECM installer (setup.exe) to patch your Oracle ECM software. Here you need to specify the updated middleware home directory.
5. Run the Oracle WebCenter installer (setup.exe) to patch your Oracle WebCenter software. Here you need to specify the updated middleware home directory.
6. Start all the servers.

Post Installation Task
There is no post intallation task from 11GR1PS3 to 11GR1PS4 for our

Monday, September 12, 2011

How to configure embedded (default) LDAP for WebCenter Collaboration Server (i.e. Discussion and Announcement Services)?

Applies to Oracle WebCenter 11G PS3 & PS4

If you want to revert back from external or custom LDAP to embedded LDAP, you will not get clearly written steps in WebCenter Administration and Security Guides. Following are the simple steps in order to use embedded LDAP again:-  
Step 1. Enable Embedded LDAP Access
When WebLogic Server is installed, the LDAP access credential is set as a randomized value and encrypted in the config.xml file To reset the access credential for the embedded LDAP:
1.      Log in to the WebLogic Server Administration Console.
2.      In the Domain Structure pane, click wc_domain.

3.      In the Settings pane for wc_domain, click the Security tab, and then click the Embedded LDAP tab.
The Settings Pane for wc_domain displays the embedded LDAP settings
4.      Enter a new password in the Credential field, and reenter it in the Confirm Credential field.
5.      Click Save to save your settings.
6.      Restart the WebLogic server.
After this, you are ready to access the embedded LDAP server with the following values:
·         the DN value for admin access is "cn=Admin"
·         the password is the value you entered in the Credential field
·         the port is the same as the admin port, which by default is 7001

Step 2. Enabling Discussions Setup
1. Stop WC_Collaboration managed server (MS)
2. Change <setup>true</setup> entry to false on
<WebCenter-Domain-Home>\ config\fmwconfig\servers\WC_Collaboration\owc_discussions\jive_startup.xml.
<!-- When setup is false, you can access the setup tool. -->
<!-- Database settings -->
3. Start WC_Collaboration MS

Step 3. Running Discussions Setup Screen
1. Log in to the Discussions Server Administration Console at:
2.  On the Installation Checklist page, click Continue.
3. On the Database Settings page, choose JNDI Datasource, and click Continue.

4. Enter jdbc/OWC_DiscussionsDS in the JNDI Datasource Name field and click Continue.

5. For User, Group and Authentication Systems, select LDAP and click Contrinue.

6. Enter the following values for the embedded LDAP system and click Continue.
LDAP Host : localhost
LDAP Port: 7001
Base DN: ou=people,ou=myrealm,dc=wc_domain
Admin DN: cn=Admin
Admin Password: <Password of embedded LDAP>

7. For Admin Account Setup, enter the user name (i.e. weblogic)of the user for the Discussions (Jive) administrator.

You can now log in to Oracle Discussions with any user available in the embedded LDAP server.
You can log in to the Oracle Discussions Admin Console at: http://localhost:8890/owc_discussions/admin (use weblogic/<password>)