UnixBook_For OracleERP

Basic Unix Commands   (Post1)

  • ls — lists your files 
    ls -l — lists your files in ‘long format’, which contains lots of useful information, e.g. the exact size of the file, who owns the file and who has the right to look at it, and when it was last modified. 
    ls -a — lists all files, including the ones whose filenames begin in a dot, which you do not always want to see. 
    There are many more options, for example to list files by size, by date, recursively etc
  • cp filename1 filename2 — copies a file
  • rm filename — removes a file. It is wise to use the option rm -i, which will ask you for confirmation before actually deleting anything. 
  • diff filename1 filename2 — compares files, and shows where they differ
  • wc filename — tells you how many lines, words, and characters there are in a file
  • chmod options filename — lets you change the read, write, and execute permissions on your files. The default is that only you can look at them and change them, but you may sometimes want to change these permissions.
  • grep string filename(s) — looks for the string in the files. 

File Compression

  • gzip filename — compresses files, so that they take up much less space. Usually text files compress to about half their original size, but it depends very much on the size of the file and the nature of the contents. There are other tools for this purpose, too (e.g. compress), but gzip usually gives the highest compression rate. Gzip produces files with the ending ‘.gz’ appended to the original filename.
  • gunzip filename — uncompresses files compressed by gzip.


Directories, like folders on a Macintosh, are used to group files together in a hierarchical structure.

  • mkdir dirname — make a new directory
  • cd dirname — change directory. 

grep string filename(s) — looks for the string in the files. 


POST 2 Starts—————————————————-

Unix Commands Specific for E-Business Suite Oracle E-Business Suite follows a three tier architecture  (Post2)

  • Front End
  • Middle-Tier
  • Back End (Database)

Most of the clients deploy Oracle E-Business on Unix Servers.

Single Physical Machine (Server) can hold multiple Oracle E-Business Instances, when developers working on multiple instances, it finds difficult to find the exact path of their instance in the Unix Box.

Following screenshots will help you in finding the right location in Unix Box.

Click on : About This Page link (On E-Business Login Page) (Make Sure : FND_DIAGNOSTICS profile is set to Yes)

In the above screenshot it displays list of directories under the Unix Path :  “/”

DB Instance is under    : /oraDB

Application Server (Middle Tier) is Under :    /oraAS

Oracle E-Business Suite :  File System Details

How to find how many modules are installed in Oracle E-Business and their location ?

SELECT FA.application_id,





  fnd_application_tl fat

WHERE 1               =1

AND fa.application_id = fat.application_id


Above query shows the list of modules installed and their path : BASEPATH refers to the location (path) of module in Unix Box.

*In most environments there will be .env  files, which need to be executed before exeucting any oracle ERP specific commands like  : FNDLOAD, FND_TOP , frmcmp etc. So please make sure to execute the below two .env files .

Lets trace the path for : FND_TOP(Application Object Library Module)

Lets trace the path for : GL_TOP (General Ledger Module)

How to see the list of reports in GL Module

  –> Directory location of GL Module : /oraAS/oracle/VIS/apps/apps_st/appl/gl/12.0.0

In Oracle E-Business Projects —- Where does Unix shell programming is used ?

  • For Migrating Objects
  • For Concurrent Programs based on Unix Shell  — mostly for purpose of : copying files dynamically
  • Finding files or executing scripts during Product Support  (In realtime –whenever any Oracle Support Request (SR) is raised, there is a need to execute few shell scripts, so developer need to execute them and provide the output to : Oracle SR team)

APPL_TOP (Displays the folders for each module)

Leave a Reply

Your email address will not be published.