Saturday, March 22, 2008

Docs for Migrating data between Oracle EBS and OracleID

http://download.oracle.com/docs/cd/B40089_05/current/acrobat/120sasg.pdf
section "Migrating Data between Oracle E-Business Suite Release 12 and Oracle Internet Directory"


Note 261914.1 - Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On
Download PDF document by clicking on the link "Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On".

Docs will help in migrating users from EBS to OID and OID to EBS.

Friday, March 21, 2008

Tuesday, March 11, 2008

OEM Configuration in 10g using response file

create password file using orapwd

Create a response file (ex: resp)with below parameters:

ORACLE_HOME =
PORT =
SID =
HOST =
DBSNMP_PWD =
SYSMAN_PWD =
SYS_PWD =
DBCONTROL_HTTP_PORT =

emca -config dbcontrol db -repos (create/recreate) -silent -respFile resp


Note:If emca is failing with dbsnmp user/password invalid enter password in "" (eg: "welcome")

With out response file create repository.

emca -config dbcontrol db -repos create -SID DEV -PORT 1521 -ORACLE_HOME /u01/oracle/DEV/db/tech_st/10.2.0 -DBCONTROL_HTTP_PORT 1156

Friday, March 7, 2008

Oracle Portal Upgrade from 10.1.2.2 to 10.1.4

Doc: B19135-01 Portal Upgrade from 10.1.2.2 to 10.1.4

Latest: http://www.oracle.com/technology/products/ias/portal/index.html (Download Portal 10.1.4)

Patch 4960210 to Upgrade from 10.1.4 10.1.4.1

Displaying a URL Redirection Screen

You can choose whether to display a URL redirection screen or not. The URLredirection screen displays both the new and old URLs to assist in correctingbookmarks.When you access an old URL, the URL redirection screen is displayed by default. Toalter the default behavior, you can use the pobredir.sql script.

pobredir.sql script is located in portal/admin/plsql/wws directory in the upgrade CD-ROM.
The script takes 1 parameter.

Run the script as portal schema owner.

You need to download script from metalink 392703.1:showpassword to get the PORTAL password.

"Please check Caution in the Note:392703.1 "

Query to find the portal version from database.

Login to portal schema and run below query.

select version from wwc_version$