Skip to content

Expert Oracle Posts

UPGRADE 11.1.0.7 DATABASE TO 11.2.0.3 DATABASE WITH R12.1.3

Published October 13, 2012 By Brijesh Gogia

11.2.0.3 is the latest release (at the time of writing this post) for the Oracle database. The intent of this guide is to upgrade the current database version from 11.1.0.7 to 11.2.0.3.

The installation procedure for the new Oracle Database 11g Release 2 (11.2) installs the Oracle software into a new Oracle home. This is referred to as an out-of-place upgrade and is different from patch set releases for earlier releases of Oracle Database, where the patch set was always installed in place. Oracle strongly recommends that you follow the steps in this procedure to ensure minimal downtime for the upgrade process and integrity of the new binaries and software libraries.

Continue ReadingUPGRADE 11.1.0.7 DATABASE TO 11.2.0.3 DATABASE WITH R12.1.3
Leave a Comment

Adding new user in Oracle Apps (EBS) from back end

Published September 13, 2012 By Brijesh Gogia

Application users in Oracle Apps (EBS) can be created from the front end as well as back end. The back end method for user creation can be used when you don’t have sysadmin access to the applciation or also it can be used to speed up the process when there are many userids to be created.

You will require apps access to connect to database  to run the package fnd_user_pkg.

Continue ReadingAdding new user in Oracle Apps (EBS) from back end
5 Comments