Oracle UCM Workflow Setup

Here is the nice article about how to setup workflow in UCM

http://www.packtpub.com/article/oracle-universal-content-management-set-up-change-workflows

Installing Oracle XE 11.2.0.0.5 , Weblogic 10.3.5 and SOA 11.1.1.5.0 in 64 bit CentOS 5.6

Make sure that you have downloaded all the required files for installation. I installed all the products in 64 bit CentOS 5.6 release.

Confirm your system type by following:

# uname -i
x86_64
# uname -a
Linux dhcpfbb8t-47.mdacc.tmc.edu 2.6.18-238.12.1.el5 #1 SMP Tue May 31 13:22:04 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
# cat /etc/*release*
cat: /etc/lsb-release.d: Is a directory
CentOS release 5.6 (Final)

JDK 1.6 - jdk-6u27-ea-bin-b01-linux-amd64-18_may_2011.bin

Install jdk as root user and set the JAVA_HOME in the ~/.bashrc file

export JAVA_HOME=/opt/jdk1.6.27

export PATH=$JAVA_HOME/bin:$PATH

JDeveloper - jdevstudio11115install.bin

Install jdeveloper as root user and set the JDEV_HOME in ~/.bashrc file.

export JDEV_HOME=/opt/jdk1.6.27

export PATH=$JAVA_HOME/bin:$JDEV_HOME/bin:$PATH

Oracle XE - oracle-xe-11.2.0-0.5.x86_64.rpm

Download the above file and install as root user

rpm -ivh oracle-xe-11.2.0-0.5.x86_64.rpm

Now edit the ~/.bashrc and make the below changes.

export ORACLE_HOME="/u01/app/oracle/product/11.2.0/xe"
export PATH=$ORACLE_HOME/bin:$JAVA_HOME/bin:$JDEV_HOME/jdev/bin:$PATH

After the installation, you need to change the processes and sessions values using sqlplus.

sqlplus sys/<password>@<sid> as sysdba;

SQL> ALTER SYSTEM SET PROCESSES=900 SCOPE=SPFILE;

System altered.

SQL> ALTER SYSTEM SET SESSIONS=900 SCOPE=SPFILE;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

Now start the database again by

/etc/init.d/oracle-xe start

Before proceeding further, you need to make sure that you have all the required os packages are installed.

yum install compat-libstdc++-296 binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaio openmotif21 libaio-devel-0.3.106 compat-libstdc++-33 unixODBC-2.2.11 unixODBC-devel-2.2.11 elfutils-libelf-devel

Also edit /etc/security/limits.conf and make the below changes

oracle          hard    nofile  4096
oracle          soft    nofile  4096

Create Schemas using RCU - ofm_rcu_linux_11.1.1.5.0_disk1_1of1.zip

Unzip and Run the command 'rcuHome/bin/rcu' an install schemas for SOA and webcenter.(Ignore warnings)

Oracle Weblogic 10.3.5 - wls1035_generic.jar

Now we are ready to install weblogic.

java -d64 -jar wls1035_generic.jar

Oracle SOA 11g
ofm_soa_generic_11.1.1.5.0_disk1_1of2.zip
ofm_soa_generic_11.1.1.5.0_disk1_2of2.zip

Download the above files and unzip to a directory. Now run the installater (./runInstaller) from Disk1.

Oracle UCM 11g
ofm_ecm_generic_11.1.1.5.0_disk1_1of2.zip
ofm_ecm_generic_11.1.1.5.0_disk1_2of2.zip

Oracle OSB 11g
ofm_osb_generic_11.1.1.5.0_disk1_1of1.zip

Oracle WebCenter 11g
ofm_wc_generic_11.1.1.5.0_disk1_1of1.zip

UCM Import/Export

It is always fun when you are involved in migration. Ok, here is there situation. We want to move the ucm content from one server to another server.So what I am supposed to take care?

Before jumping into action, you need to understand the state of source and target machines. In my case, my target ucm server has some content and I want to upgrade the targer with source content.

Now the question is, is it ok to upgrade just content? definitely NO. You need to make sure that source & target servers are synchronized with meta data, security (roles & accounts),workflow definitions etc. If not, you should do that first by using 'Content Migration Utility' or from admin console, you can use content migration section to do it.

The steps are,

1. Migrate meta data,security,workflow using content migration utility.

2. Migrate content using archiver using admin applets from admin console.

Let's see how to migrate using content migration utility:-

1. Go to administration console of source machine.

2. Create or Update configuration migration template. Go to Administration -> Config Migration Admin -> Configuration Templates

3. If there are any previously used template, then edit the template to see the configuration. 

4. Otherwise, ‘Create New Template’ from Action drop down.

5. We are going to edit existing template.

6. Click on ‘Content Server Sections’ to review the selected items. You can go to ‘Preview’ from Actions drop down to see complete picture. 

7. Now click on ‘Export’ to export the selected items to bundle. You will be redirected to ‘Latest Action’ page where you can see the progress. 

8. Wait until you see ‘Finished in the message. 

9. Now go to ‘Administration -> Config Migration Admin -> Configuration Bundles’. 

10. You will see the bundle created with recent date & time.

11. Click on ‘Download’ from the drop menu and save the zip file in local file system.

12. Now go to the target server. Go to Administration ->Config Migration Admin->Upload Bundle. 

13. Now upload the zip file which was downloaded previously and select the options as shown below. And click on ‘upload’.

14. In the Configuration Bundles page, click on the one which was just uploaded. 

15. Now select drop down to preview. 

16. Select ‘import’ from drop down.

17. You will be redirected to ‘Latest Action’ page and you can see the progress of import. 

We are done with meta data migration. Now we can migrate content using archiver. I assume that you have already defined outgoing providers from stage to production.

1. Go to ‘Administration ->Admin Applets’. Then click on ‘Archiver’. 

2. In the archiver, Go to ‘Options -> Open Archive Collection’. Then select the collection you want to use. You should be able to see production instance in the list and select the instance you want to use & click ‘Open’. 

3. Go to ‘Edit -> Add’ to add new or update existing archive. Click ‘OK’.

4. Now newly created archive will be highlighted and review ‘Export Data’ tab settings. Click on ‘Edit’ button and select ‘Custom Query Expression’.

5. Let’s use custom query to fetch content created after 07-Mar-2011. The query will be dInDate >  {ts '2011-03-07 00:00:00'}.   

6.6. Select ‘Export Revisions with Release Date later than most recent Export date’.