Installing Oracle Applications R12 On Windows 7

March 15, 2013

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?

Read the rest of this entry »


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

January 24, 2012

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.
Read the rest of this entry »


Oracle Apps R12 – Let Me Count the XML Files

January 24, 2012

Just how many XML files does Oracle Apps R12 use?
Read the rest of this entry »


Overcoming Oracle Apps R12 FRM-92101 Error On Redhat Linux 5.5

January 21, 2012

Have you ever got the error, FRM-92101 on with Oracle Applications R12 on 64 bit Redhat Linux 5.5? Here is how to overcome it.

Oracle Forms Runtime Error FRM92101

Oracle Forms Runtime Error FRM92101

Read the rest of this entry »


Firefox, Oracle Apps, Java plugins, on 64 Bit Redhat 5.5

January 20, 2012

When using Firefox on Linux, have you ever got the aggravating message concerning oaj2se.exe, or NPX_PLUGIN_PATH? Here is the solution.

From what I have read, on Linux, using the Firefox browser for Oracle Forms is not certified. At least it wasn’t in the past. Bizarre.

———–

Symptom:

On Redhat Linux, you try working with an app such as Oracle Apps, and navigate to where the software takes you. But you suddenly get the error message:

In order to access this application, you must install the J2SE Plugin version 1.6.0_07 on your client and NPX_PLUGIN_PATH environment variable is set before starting Netscape. To install this plugin, click here to download the oaj2se.exe executable. Once the download is complete, double-click the oaj2se.exe file to install the plugin. You will be prompted to restart your browser when the installation is complete.

———–

The problem is, oaj2se.exe is an executable that only works on Windows.
Read the rest of this entry »


Oracle Apps R12 Install on Redhat 64 – The Big Picture

December 9, 2011

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.

Read the rest of this entry »


Oracle Applications R12 – Let Me Count The TOPs!

December 8, 2011

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!

Read the rest of this entry »


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

April 19, 2011

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
 Read the rest of this entry »

Oracle Apps – Analysis of the Files and Filesystems

April 14, 2011

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

Read the rest of this entry »


Oracle Applications R12: More Schema Analysis

December 18, 2010

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!

Read the rest of this entry »


Oracle Applications R12 Schema Analysis

December 17, 2010

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?

Read the rest of this entry »


%d bloggers like this: