Installing Oracle Applications R12 On Windows 7

Oracle Applications R12 is not certified for installation on Windows 7. The reason seems to be that Apps wants to be on a server that can do lots with domains. This is problematic or not possible with Windows 7, but easily accomplished with Windows Server 2003 or 2008.

But a few years ago, I managed to install Apps on Windows XP, even though XP is not certified either. So, why not Windows 7?

Overcoming the Oracle Apps R12 Error APP-FND-01542 on 64 bit Redhat 5.5

Ever try to login to Oracle Apps R12, and get the error APP-FND-01542 on 64 bit Redhat 5.5?

APP-FND-01542: The applications servers is not authorized to access this database.

Here is how to solve it.

Oracle Apps R12 – Let Me Count the XML Files

Just how many XML files does Oracle Apps R12 use?

Oracle Apps R12 Install on Redhat 64 – The Big Picture

Ever notice how installing almost any Oracle product has not dozens, but hundreds of pages of detailed documentation? The installation guide for R12, Oracle Applications Installation Guide: Using Rapid Install, 120oaig.pdf, is 150 pages long!

Unfortunately, most of the time, Oracle docs do not give the big picture. In a few hundred words or less, what’s involved? What’s the procedure? What’s the order of operations?

Blogs and forums I find to be much better written, and much more useful.

Recently at home, I installed Oracle Apps R12 on a single Redhat Linux 5.5 64 bit server. Here is what I would describe as the big picture, or the high level. Refer to other docs, blogs and forums for the remainder of the very many gory details.

Oracle Applications R12 – Let Me Count The TOPs!

If you work with Oracle Applications R12, you know that there are a few TOPs. Some well known ones are: APPL_TOP, COMMON_TOP, FND_TOP, INST_TOP, JAVA_TOP. But I have been able to detail over 200 TOPs!

Oracle Apps R12: DBA Analysis Of TableSpaces, Log, And Control Files

Oracle Apps R12: More DBA Analysis Of TableSpaces, Log, And Control Files

Lots of tablespaces! 

select TABLESPACE_NAME
from dba_tablespaces
order by TABLESPACE_NAME

TABLESPACE_NAME
------------------------------
APPS_CALCLIP
APPS_OMO
APPS_TS_ARCHIVE
 

Oracle Apps – Analysis of the Files and Filesystems

Continuing my analysis of Oracle Apps R12.  This time, the actual files on the server.  There are over 1/2 million files in APPL_TOP and COMMON_TOP!  Wow!

—————-

On my installation of Apps R12, there is:

APPL_TOP
/oapps/applmgr/VIS/apps/apps_st/appl

COMMON_TOP
/oapps/applmgr/VIS/apps/apps_st/comn/

ORACLE_HOME
/oapps/oracle/VIS/db/tech_st/11.1.0

—————-

The top parts of the directory structure:

find /oapps  -maxdepth 5 -type d

Oracle Applications R12: More Schema Analysis

Oracle Applications R12: More Schema Analysis

Some more analysis of the schemas and objects in Oracle Applications R12 sample database, VIS.

Lots of objects, triggers, and packages.

And over 57 million lines of source code in the APPS schema alone!

Oracle Applications R12 Schema Analysis

Oracle Apps R12 Schema Analysis

Continuing on my series on analysis, here is some of the initial analysis I did after installing Oracle applications R12.  Much of the analysis involves queries to the Oracle data dictionary under the covers.  This analysis is on the sample “database”, VIS, which is actually composed of many schemas.

I also did a fair bit of analysis from a DBA standpoint: tablespaces, logs, processes, DBMS_JOBS, etc.  And other analysis on the unix and middle tier side.  Tuning.  I’ll try to keep it all organized in different posts.

When I’ve started a new position, these are the types of queries I might run on the schemas to get a feel for the systems.  Just how was it made? Does it use PK, triggers, or external code to enforce data integrity?  What are the most important tables?  What are potential performance issues? Any issues?  And so on.

Many of these queries you won’t find the GUIs like SQL Developer, or Toad.  You have to write them yourself.  It pays big dividends to know the data dictionary!

(Sorry for the odd font. WordPress has not made changing the font for select sets of text easy or obvious. If anyone knows the secret, on how to change fonts in WordPress A LA Wordpad, please let me know. )

------------------------------------------------
------------------------------------------------

How many tables are there?