On request from readers, I am posting step by step installation of Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.X on windows (you can use same steps to install OBIEE on Linux)
.
Things good to know about OBIEE Installation
i) Siebel Analytics from Siebel (acquired by Oracle) is now called as OBIEE (Oracle Business Intelligence Enterprise […]

Popularity: 2% [?]

Any guess for Oracle Apps Release 12.1 date ?
Release date for 12.1 version is not official yet but if you are looking for new features in Oracle Applications Release 12.1 for Apps DBA’s here is my list
.
Technical Components in 12.1

Database Version with Oracle Apps 12.1 is going to be 10.2.0.4
Forms & Reports version 10.1.2.2
Web Server […]

Popularity: 4% [?]

The steps I have followed :-
1. Login as oracle application user
2. Go to $FND_TOP/secure
3. java oracle.apps.fnd.security.AdminAppServer apps/ \AUTHENTICATION ON DBC=
Please check the below example :-
4. java oracle.apps.fnd.security.AdminAppServer apps/ffdev21 \AUTHENTICATION ON DBC=ffus.com_ffus.dbc
Output will be :-
AUTHENTICATION ON executed successfully - ffus.com_ffus.dbc
5. In the command prompt echo $FORMS60_TRACE_PATH
It will give you the trace […]

Popularity: 3% [?]

Q. If you have multiple nodes with multiple URL’s (intapps.com , extapps.com..) in apps (11i/R12), how many times you have to run OID/SSO Registration Process ?
Q. In which table (in Apps), Single Sign-On URL’s are stored ?
Q. In which table (in SSO), all partner applications (including apps stored) ?
Q. Where is OID, apps 11i/R12 details are stored […]

Popularity: 5% [?]

This post covers Oracle Business Intelligence (OBIEE) deployment for High Availability (cluster).
Lets first understand components of Oracle Business Intelligence Enterprise Edition
.
Components of BIEE

Oracle BI (Business Intelligence) consist of following components
i) BI Server- maintains logical data model in local proprietary file (.rpd).
ii) BI Presentation Service - provide framework and interface for presentation of BI data to […]

Popularity: 5% [?]

Find component Version in Apps 11i/R12/12i  
Q. How to find Apps Version (11i/R12/12i).
A.  Connect to database as user apps
SQL> select release_name from apps.fnd_product_groups;
Output like 12.0.4 or 11.5.10.2
Q. Web Server/Apache or Application Server in Apps 11i/R12
A. Log in as Application user, set environment variable and run below query $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
Output for 11i should be like
Server version: Oracle HTTP Server […]

Popularity: 6% [?]

I am delighted to inform you all that my book “Oracle Applications DBA covering 11i and R12″ publisher Mc Graw Hills now got released worldwide and now is available at amazon.
The book “Oracle Applications DBA” covers all the pertinent aspects of administrating Oracle Applications—from installation to day-to-day maintenance. It covers upgrading, cloning, patching, maintenance and troubleshooting […]

Popularity: 11% [?]