Monday, April 16, 2012

oracle portal 11g upgrade

Below are the steps for upgrading oracle portal 10.1.4.2 to 11.1.1.2

Db upgrade - 10.2.0.1 to 10.2.0.4 via patch 6810189
  • runInstaller -ignoreSysPrereqs
  • select ORACLE_HOME that needs to be upgraded
  • run root.sh as root at the end
  • export ORACLE_HOME, ORACLE_SID and PATH
  • dbua
  • select DB that you want to upgrade and run through the wizard
Install 10.3.5 weblogic server as 11.1.1.6 requires this
Install base version 11.1.1.2 (install software - do not configure option)
Install patchset 11.1.1.6 against 11.1.1.2 binaries
Run config.sh to create  instance and domain
  • yum install openmotif
  • yum install openmotif22 (for reports server) 

upgrade middle tier instance (ua)
  • select middle tier ORACLE_HOME of 10g portal instance
  • select asinst_1 or whatever your new ORACLE_HOME of 11g weblogic instance that you created in step before this
Getting some errors here... I will update this post in case i resolve these issues.....
upgrade portal schema (ua)

Virtualbox permission denied error on mac host and linux guest

if you shared folder on the vm settings -> shared folders, can access this as root and are getting a permission denied problem as any other user, below is the list of steps for you :)

find uid (500) and gid (52000) of the user on the guest linux

login as root and run the following commands:

sudo mount -t vboxsf -o uid=500 Downloads /mnt/Downloads_win

or edit /etc/fstab and add the following at the end:

Downloads /mnt/Downloads_win vboxsf uid=500,gid=52000 0 0

Hope it works

Saturday, March 31, 2012

Oracle Virtual Box Host access to guest apps - port forwarding

Click settings -> Select Network on your appliance (ovf) import and set up access to ports (weblogic console/em, db etc) as needed. In the sample below i am including screenshots for Weblogic console access.


Friday, March 30, 2012

Oracle SOA Suite 11.1.1.6 Samples, Tutorials

I came across some issues while importing samples from oracle jdev soa tutorials site at oracle/sun site. I was doing this for debugging few issues that i came across while i was working on a project over a period of time. Anyways, I uploaded some of the samples that were re-factored (mostly xml namespaces as this is where i had some issues) here. Please use them as needed.

All new comers to Oracle SOA should go through simple concepts (assignments, arrays, xquery, bpel, mediation, spring beans etc) thoroughly before you embark on large scale projects. This exercise will help strengthen your XML skills if they are rough. Brief description of projects that are included in the file are:
ArrayActivities
AssignActivities
HelloWorld BPEL
CallingWebService
OrderProcessor - Demonstrated Correlation - I will blog more about this some time later
SpringHelloWorld - Spring framework

Most names are self explanatory, again, new comers must get familiarized with weblogic enterprise manager for testing these services. Oracle site i referred above has very good documentation for introducing features.

Tuesday, March 13, 2012

Oracle SOA 11.1.1.6 installation steps

SOA 11.1.1.6 was released recently. Steps below describe its installation process. OVerall steps did not change from 11.1.1.5. Downloads listing is also incidated below:


RCU Installation








Weblogic Installation





 Oracle SOA Installation

SOA Domain Installation and Configuration






















Oracle Virtualbox Add new hard disk procedure

All oracle developers these days must get familiar with oracle virtual box concepts.. there is base images available from oracle for download for you to play around with. After downloading these images, you can add software to it and save it as a copy for you to transfer to different machines... how cool is that!!!

However if you are a novice, you need to get familiar with how to add disk space, to the base VMs. Most oracle base VM images come with just enough space, so for adding a new software (either middleware or database management tools for example) these  instructions come handy.



Click Settings -> Select Storage
Select IDE Controller -> Click Add Hard Disk

Click Create New Disk

Select VDI (Virtual box image format) or vmdk format and continue through wizard and select or enter amount of space required.
Start VMDK
Login as root
Run “fdisk –l”
You’ll see a message such as /dev/hdc doesn’t contain a valid partition table
Run the command mkfs –t ext3 /dev/hdc
Mkdir /stagingDisk1
Edit /etc/fstab and add the following entry /dev/hdc /stagingDisk1  ext3 defaults 0 0
If this doesn’t work run  mount /dev/hdc /stagingDisk1



Saturday, March 3, 2012

Android Emulator Usability Topics

Below is a list of usability topics on the android emulator:

1. Keyboard popup is more annoying on the emulator than it is on the actual device. In order to turn if off, do the following:
 go to settings -> language and keyboard -> Uncheck android keyboard and other international language items
2. In order to add custom apk files on the emulator or the actual device, do the following:
go to settings -> applications -> Check unknown sources
3. In order to uninstall applications cleanly do the following:
go to settings -> applications -> manage applications -> select your application -> click uninstall (or clear data, clear cache etc) if this is what you want to do.