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.
