File System

File System

 1. What all directories will be there under any “product” top

Ans à

cd $AP_TOP (Example of product top AP) (Below are various directory under each product top – ad, ap, gl..)
admin  bin  forms  help  html  lib  log  mds  media  mesg  out  patch  reports  sql  xml

--- “forms” contains all .fmx (compiled version of forms)

---“mesg” contains language specific message files and error message for the product.

--- "bin” directory contains executable files like in $AP_TOP/bin you will see APPBCF  APTZGF  apxamex.ctl                apxboav.ctl  apxdiner.ctl  apxgecmc.ctl  apxusbv.ctl  APXXTR

patch direcotry contians pathc deliverables. 

--- "reports"- will have rdf ( datamodel) file. Its used with rtf file to generate outfile xml file.

5) Location of the .odf file

odf stands for Object Description Files used to create tables & other database objects.

$PO_TOP/patch/115/odf

This file also exists in $AP_TOP/admin

8) Location of .pls files

$AP_TOP/patch/115/sql

9) To find .lct file

$AP_TOP/patch/115/import

To find .rtf 

$AP_TOP/patch/115/publisher/templates/US

10) To find .lpc file

.lpc are generally part of .exe files eg. rvtbm.lpc. The relevant command is as follows:

[OSPT1]-->echo $AU_TOP
/OSPT1/shared/apps/apps_st/appl/au/12.0.0

cd $AU_TOP/resource

 -- custom.pll / .pll and plx files pls filse

cd $AU_TOP/forms/US

 -- .fmb files

[OTST1_BALANCE]-->echo $JTF_TOP

/OTST1/shared/apps/apps_st/appl/jtf/12.0.0

[applmgr@amxt05ap01a:/OTST1/shared/apps/apps_st/appl/ad/12.0.0/bin]

65: How to compile JSP in Oracle Apps ?

You can use ojspCompile.pl perl script shipped with Oracle apps to compile JSP files. This script is under $JTF_TOP/admin/scripts. Sample compilation method is

perl ojspCompile.pl --compile --quiet

[F12SPT]-->echo $XDO_TOP
/F12SPT/shared/apps/apps_st/appl/xdo/12.0.0

cd $AP_TOP/patch/115/publisher


Hi Where can we find the .rtf files in server loaded through XML Publisher Administrator-->Template?
You can go to the $XDO_TOP/patch/115/publisher/templates/US.

XDO- A type of XML file used to keep track of various resources.

Also what is temporary directory set for XML Publisher Administrator? 

SQL> select value from apps.XDO_CONFIG_VALUES WHERE property_code = 'SYSTEM_TEMP_DIR'; 

VALUE 
-------------------------------------------------------------------------------- 

/u01/app/tmp/OPRD 

*** If the file system grows****

Check to see if debug is turned on for XDO
cd $XDO_TOP
find . -name xdodebug.cfg
cd $AF_JRE_TOP
find . -name xdodebug.cfg
cd $OA_JRE_TOP
find -name xdodebug.cfg
in all three locations search for xdodebug.cfg if it exists stop cm, remove the file and restart cm and see if xdo_top/temp is growing
Also
And any file under $XDO_TOP/temp

2. Where are .fmb (Forms) stored

Ans àThey will be under $AU_TOP/forms/US

NOTE* .fmb and .fmx are different

6. How to compile apps schema and when to compile??
Ans àYou can use “adadmin” utility to compile apps schema (other methods like utlrp.sql exists). Usually you compile apps  after application of the patches, maintanance patch, upgrade, runtime error due to AD_DDL packages or scenarios where there are invalid objects in apps schema.

7. How many database connections are allowed during fresh installation of oracle application.
Ans à100. (Number has increased to 250 for Pluggable Databases in 12c)

"hi, we have a requirement that, we need to make a xml based report without rdf and output should be in Excel, actual we have four sql queries so the output should come in one excel sheet with four tab for four queries."


Hi,

Without .rdf, it is not possible to create a xml publisher report, you have to
have .rdf file, you can create report via discoverer but that is one of the tool
available outside the ERP.

As you require four tab for your four queries, I have no clue about it, but you
can include all the four queries in different data model in rdf and based on the
condition you can show them in rtf file, which gives you output in Excel.

[OTST1_BALANCE]-->echo $APPL_TOP                        -- top level application directory ( take snapshot of it)

/OTST1/shared/apps/apps_st/appl

[OTST1_BALANCE]-->echo $AD_TOP                                   - Admin utility binaries

/OTST1/shared/apps/apps_st/appl/ad/12.0.0

echo $AD_Top/bin

   Adworker,adpatch,admrgpch,adident,adrelink,adadmin,adctrl,adsplice,

 What is adsplice utility ?

   adsplice in oracle apps is utility to add a new product.

 How can you licence a product after installation ?

    You can use ad utility adlicmgr to licence product in Oracle Apps.

  Licence manager(adlicmgr) utility is used to licence/unlicence , enable new       languages,enbale country specific functionality.

 adident utility is used for what ?

 adident utility in oracle apps is used to find version of any file . AD Identification.

 or ex. "adident Header <filename>

 $ cd $ADMIN_SCRIPTS_HOME

 $ strings -a adstrtal.sh|grep '$Header'

How to compile Invalid Objects in database ?

 You can use adadmin utility to compile or you can use utlrp.sql script shipped with Oracle Database to compile Invalid Database Objects.

 What are various options available with adpatch ?

 Various options available with adpatch depending on your AD version are

  autoconfig, check_exclusive, checkfile, compiledb, compilejsp, copyportion, databaseprtion, generateportion, hotpatch, integrity, maintainmrc, parallel, prereq, validate

 How to compile an Oracle Reports file ?

  Utility adrepgen is used to compile Reports. Synatx is given below

adrepgen userid=apps\<psswd> source = $PRODUCT_TOP\srw\filename.rdf dest=$PRODUCT_TOP\srw\filename.rdf stype=rdffile dtype=rdffile logfile=x.log overwrite=yes batch=yes dunit=character

 What are the post installation task?

  Running adjkey –initialize and then runnning adadmin to regerate jar files.

 How you will start Discoverer in Oracle Apps 11i ?

 In order to start dicoverer you can use script addisctl.sh under $OAD_TOP/admin/scripts/$CONTEXT_NAME or startall.sh under $ORACLE_HOME/discwb4/util (under Middle/Application Tier)

 if we run autoconfig which files will get effected?

 cd $AD_TOP/bin

 ls -tlrh adchkcfg.sh ===>run this file it will ask for apps password ,you can use it in 11i/r12

 adchkcfg.sh ===> It will generate HTML report.

 This report will list all files and profile options going to change when you run autoconfig.

What is difference between adpatch & opatch ?

 adpatch is utility to apply oracle apps Patches whereas

 opatch is utility to apply database patches

Can you use both adpatch & opatch in Apps ?

 Yes you have to use both in apps , for apps patches you will use adpatch utility and for applying database patch in apps you will opatch utility.

 AD Utility Name: AD Controller

 Executable: adctrl

 Purpose: To know the status of Auto Upgrade, AD Administration, Auto Patch workers and control their actions.

  What is adrelink?

 adrelink will relink the executables with the libraries. Generally we will go for adrelink when some patch delivers some library files, or when executables were corrupted.

  What is adodfcmp utility?

  This utility is used to recreate/repair corrupted database objects from odf(object defination files) files.

How To Recreate the /appsutil/scripts/ directory

 a. On the Application Tier (as the APPLMGR user)

   Log in to the APPL_TOP environment (source the environment file) cd $AD_TOP/bin

   perl /bin/admkappsutil.pl

   This will create appsutil.zip in $APPL_TOP/admin/out .

 b. On the Database Tier (as the ORACLE user):

   Copy or FTP the appsutil.zip file to the RDBMS ORACLE_HOME

      cd RDBMS_ORACLE_HOME

      unzip -o appsutil.zip

  Generate your Database Context File follow the steps below:

       On UNIX cd . .env

       cd /appsutil/bin perl adbldxml.pl tier=db appsuser= appspasswd=

 c.  Run autoconfig

      On UNIX cd /appsutil/bin, run adconfig.sh contextfile= appspass=After running adconfig.sh contextfile= appspass= ,the scripts directory "/appsutil/scripts//" is created in appsutil directory.

 After running adconfig.sh contextfile= appspass= ,the scripts directory "/appsutil/scripts//" is created in appsutil directory

In how many phases autoconfig will run?

 Autoconfig will run in 3 phases.

1.INIT – Instantiate the drivers and templates

2.SETUP – Fill the templated with values from xml and create files

3.PROFILE – Update the profile values in database.

Is it possiable to restore a autoconfig run?

Partially. Adconfig will create a restore.sh script at $APPL_TOP/admin//out/. This restore.sh will copy the backed up files before autoconfig run to its original

locations. But the profile values updated in the database can’t be restored back.

How to run autoconfig in test mode?

 adchkcfg.sh script at AD_TOP/bin. This script will run autoconfig in test mode and create the difference file which tells us what is going to change , when u actually

run autoconfig.

Where all ADUTILITIES EXE'S LOCATED?

$AD_TOP/bin

For each utility three files are presented.

[applvision@apps bin]$ ls -ltrh adadmin adadminnew adadmin_wrapper

-rwxr-xr-x 1 applvision applmgr 9.2K Dec 31  2006 adadmin_wrapper

-rwxr-xr-x 1 applvision applmgr 9.2K Mar 27  2009 adadmin

-rwxr-xr-x 1 applvision applmgr 3.5M Mar 30  2009 adadminnew

[applvision@apps bin]$

First two files are wrapper files and both are same in size.

 ==>adadmin will internall call adadminnew

 ==>adadminnew is key executable which calls adadmin.

What happen if we lost adadminnew?

adadmin will not work.

Scenario:

[applvision@apps bin]$ mv adadminnew adadminnew_14sep2013

[applvision@apps bin]$ adadmin

sh: /apps/vision/apps/apps_st/appl/ad/12.0.0/bin/adadminnew: No such file or directory

[applvision@apps bin]$

What we had to do if we lost adadminnew?

If we lost adadminnew we can recreate it by using adrelink.sh.

[applvision@apps bin]$ mv adadminnew adadminnew_14sep2013

[applvision@apps bin]$ adadmin

sh: /apps/vision/apps/apps_st/appl/ad/12.0.0/bin/adadminnew: No such file or directory

[applvision@apps bin]$

Now fire the below command to recreate it.

 $AD_TOP/bin/adrelink.sh force=y "ad admin adadmin"

 NOTE: force=y indicates to check for all libraries.

if we lost adrelink.sh and adlicmgr.sh script.Is it possible to regenrate it?

Both are the shell scripts.Its not possible to regenerate it.

we need to copy it from other server.

 How can we generate env file?

 BY using adadmin

Choose Maintain Applications file menu.

Create application environment file

Above is applicable in 11i and in R12 i don't see this option.

(or)

Run autoconfig.

if we lost dbc,can we recreate it?

 Yes ,we can re create dbc file.

 To generate dbc file run autoconfig(OR) Execute adgendbc.sh script.

 Using adadmin is it possible to relink ad product?

 No,we cannot do it using adrelink.sh

 what is the configuration file of adutilities?

 adconfig.txt which is located at $APPL_TOP/admin.

 How oracle will know some adadmin session is running or not?

 It will know from restart file.

 cd $APPL_TOP/admin/$SID/restart

<name>.rf9

 Which adutlilty will not create table in the database?

 adident utility will not create table in the dataabase.

Echo $FND_TOP

/OTST1/shared/apps/apps_st/appl/fnd/12.0.0

15: What is .dbc file , where its stored , whats use of .dbc file ?

dbc as name says is database connect descriptor file which stores database connection information used by application tier to connect to database. This file is in directory $FND_TOP/secure also called as FND_SECURE

49: What is *.dbc file & whats is location of dbc file ?

dbc as name stands for is database connect descriptor file used to connect to database. This file by default located in $FND_TOP/secure directory also called as $FND_SECURE directory.

50: What is content of dbc file & why its important ?

DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses dbc file. Typical entry in dbc file is

GUEST_USER_PWD

APPS_JDBC_URL

DB_HOST

51: There are lot of dbc file under $FND_SECURE, How its determined that which dbc file to use from $FND_SECURE ?

This value is determined from profile option "Applications Database ID"

111: What is FNDSM ?

FNDSM is executable & core component in GSM ( Generic Service Management Framework discussed above). You start FNDSM services via APPS listener on all Nodes in Application Tier in E-Business Suite.

97: What are .ldt & .lct files which you see in apps patch or with FNDLOAD ?

.ldt & .lct stands for Loader datafile & Loader configuration files, used frequently in migrating customization, profile options, configuration data, etc.. across Instances.

95: If by mistake you/someone deleted FNDLIBR can this executable be restored if Yes, How& if no, what will you do ?

Yes, you can restore FNDLIBR executables

run adadmin on concurrent manager node

select option 2. Maintain Applications Files menu

then select 1. Relink Applications programs

when prompts for

Enter list of products to link ('all' for all products) [all]

select FND

when prompt for

Generate specific executables for each selected product [No] ? YES

select YES

& from list of executables select FNDLIBR

This will create new FNDLIBR executables.

87: What is 0 & Y in FNDCPASS, FNDLOAD or WFLOAD ?

0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where

0 is request id (request ID 0 is assigned to request ID's which are not submitted via Submit Concurrent Request Form.

'Y' indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.

80: How to retrieve SYSADMIN password ?

If forgot password link is enabled and sysadmin account is configured with mail id user forget password link else you can reset sysadmin password via FNDCPASS.

52: What is RRA/FNDFS ?

Report Review Agent(RRA) also referred by executable FNDFS is default text viewer in Oracle Applications 11i for viewing output files & log files. As most of apps dba's are not clear about Report Server & RRA, I'll discuss one on my blog and update link here .

[OTST1_BALANCE]-->echo $ORACLE_HOME

/OTST1/shared/apps/tech_st/10.1.2

[applmgr@amxt05ap01a:/OTST1/shared/apps/apps_st/appl/ad/12.0.0/bin]

[OTST1_BALANCE]-->echo $ORACLE_IAS_HOME

How to compile forms in oracle.
frmcmp_batch location -> $ORACLE_HOME/bin

Go to $AU_TOP/forms/US.
Execute the following command:
frmcmp_batch.sh userid=apps/apps module= $AU_TOP/forms/US/APXPAWKB.fmb output_file=$AP_TOP/forms/US/APXPAWKB.fmx
module_type=form batch=no compile_all=special

compile_all=special  in case we use costom pll/plx i.e customized ffiles.
*** Why would we get a TNS error when recompiling a form?

, we changed the TNS_ADMIN and ORACLE_HOME entries in frmcmp_batch.sh as below:

ORACLE_HOME=${ORACLE_HOME:-/OSPT1/shared/apps/tech_st/10.1.2}

TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}

[OTST1_BALANCE]-->echo $IAS_ORACLE_HOME

/OTST1/shared/apps/tech_st/10.1.3

[applmgr@amxt05ap01a:/OTST1/shared/apps/apps_st/appl/ad/12.0.0/bin]

[OTST1_BALANCE]-->

78: Where is plssql cache stored in Oracle Apps ?

Usually two type of cache session & plssql stored under $IAS_ORACLE_HOME/Apache/modplsql/cache

[OTST1_BALANCE]-->echo $COMMON_TOP

/OTST1/shared/apps/apps_st/comn

[applmgr@amxt05ap01a:/OTST1/shared/apps/apps_st/appl/ad/12.0.0/bin]

[OTST1_BALANCE]-->

77: Where is HTML Cache stored in Oracle Apps Server ?

Oracle HTML Cache is available at $COMMON_TOP/_pages for some previous versions you might find it in $OA_HTML/_pages

[OTST1_BALANCE]-->echo $OA_HTML

/OTST1/shared/apps/apps_st/comn/webapps/oacore/html

[OSPT1]-->echo $INST_TOP
/OSPT1/local/inst/apps/OSPT1_amxt05ap03
[applmgr@amxt05ap03:/OSPT1/local/inst/apps/OSPT1_amxt05ap03/appl/admin]

[OSPT1]-->ls

admin  logs     out   portal  soa   appl   certs   ora                      

[applmgr@amxt05ap03:/OSPT1/local/inst/apps/OSPT1_amxt05ap03]

6)what is the location of context file in 11i/r12?

Database side: $ORACLE_HOME/appsutit/<sid>.<hostname>.xml

11i *:  $APPL_TOP/admin/<sid>_<hostname>.xml
R12*: $INST_TOP/appl/admin



114)How can we generate dbc file?.
By running autoconfig.
cd $INST_TOP/admin/install
By executing a file adgendbc.sh file.
Its better to run adgendbc.sh file as it will take less than a minute to create dbc file where as autoconfig will take more than 5mins.
.


7)How to run autoconfig in 11i/R12?

The procdure is same in 11i and R12 but the location is different.
cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME

in the above location you will find adautocfg.sh file.just give filename and hit enter it will ask for apps password.

R12
===
cd $ADMIN_SCRIPTS_HOME (OR) cd $INST_TOP/admin/scripts
in the above location you will find adautocfg.sh file.just give filename and hit enter it will ask for apps password.
if you run adautocfg.sh file which in turn call adconfig.sh file which further call adconfig.pl.you should not worry about the later two script its only for information.