Re: Know whether oracle is installed in unix box

Girish wrote:
>
> Hi,
> How will I know whether oracle is installed in unix box? The unix box
> is used as the App server.
>
> Regards

Any specific component of the app server that you're trying to trace???? There's a lot of variant possible.

Since you don't mention any OS version, any possible Oracle version or App Server component, the following is very, very broad.

One of the challenges is Oracle's flexibility. There is no simple answer like 'look for user xyz'. All aspects like ownership, start directory for the software heirarchy, location for supporting files, location for database files (where relevant) can be moved.

Three parts:

1. Is it ON the machine?
2. Is it INSTALLED on the machine?
3. Is it RUNNING on the machine?

Typical signs to tell whether the software has been loaded on a box: virtually any Oracle product will include a file called TNSNAMES.ORA (or tnsnames.ora) in some directory, usually something like .../network/admin; Oracle database will have a directory that contains oracle and probably oracle0, or ORACLE.EXE for a windows machine; Oracle App server will have a directory strcuture like 'Apache/Apache/conf' and will have a file mod_oc4j.conf in that or a subdirectory.

Installed and/or running is a bit trickier. Newer versions, since the advent of the Oracle Universal Installer, will typically have an Oracle Inventory directory named oraInventory. That implies something has been installed. Find out what userid owns the software. Typically: Oracle database is owned by 'oracle'; Oracle App Server may be owned by something like 'oracle' or 'oraias'.

Finally, running: Oracle database creates a numnber of processes that can be seen using ps -f (full), that include SMON_xxxx, PMON_xxxx and a few others; App Server has a large number of config variants - you'll have to look at the doc for the process identifiers. Received on Fri Jan 09 2004 - 13:55:06 CST