apps interview
Wednesday, January 15, 2014
Usage of FNDCPASS Utility
FNDCPASS / 0 Y /
Following are the FNDCPASS Utility options that could be used with different .
1. Change the APPS and APPLSYS schema password
The SYSTEM token is used when changing the APPLSYS password.
FNDCPASS 0 Y SYSTEM
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
2. Change an Oracle Applications schema password (other than APPS/APPLSYS)
The ORACLE token is used when changing a SINGLE Applications schema password.
FNDCPASS 0 Y ORACLE
FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
3. Change all ORACLE schema passwords
The ALLORACLE token is used when changing ALL Applications schema passwords.
FNDCPASS 0 Y ALLORACLE
FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME
4. Change an Oracle Applications user's password
The USER token is used when changing an Applications USER password.
FNDCPASS 0 Y USER
FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME
Important : Oracle Applications system should be shut down before changing any schema passwords. Also FND_USER and FND_ORACLE_USERID tables should be backed up before changing any passwords.
Refer My Oracle Support Document for more information.
ID 437260.1 - How to Change Applications Passwords using Applications Schema Password Change Utility (FNDCPASS or AFPASSWD)
Friday, November 19, 2010
Utility adrepgen is used to compile Reports. Synatx is given below adrepgen userid=apps\ 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
Report Review Agent(RRA) also referred by executable FNDFS is default text viewer in Oracle Applications 11i for viewing output files and log files. As most of apps dba's are not clear about Report Server and RRA
ps -ef | grep rwmts60
$JTF_TOP/admin/scripts. Sample compilation method is
perl ojspCompile.pl
Report Review Agent(RRA) also referred by executable FNDFS is default text viewer in Oracle Applications 11i for viewing output files and log files. As most of apps dba's are not clear about Report Server and RRA
ps -ef | grep rwmts60
$JTF_TOP/admin/scripts. Sample compilation method is
perl ojspCompile.pl
tuning from oracle apps view
$IAS_ORACLE_HOME/Apache/Apache/conf httpd.conf: all apache related parameters are stored here
$IAS_ORACLE_HOME/apache/jserv: all java related errors are written here
jserv.conf: all java related parameters , how many jvms are needed, debug level
jserv.properties: how much memory to be allocated to jvms
$ias_config_home- http.pid, http_pls.pid: these 2 pids are deleted when apache is down
$ias_oracle_home/logs : error_log, error_log_plsql: check here for common errors
If forms doesnt open after login page auth, then there is a prblm with plsql
$IAS_ORACLE_HOME/apache/jserv: all java related errors are written here
jserv.conf: all java related parameters , how many jvms are needed, debug level
jserv.properties: how much memory to be allocated to jvms
$ias_config_home- http.pid, http_pls.pid: these 2 pids are deleted when apache is down
$ias_oracle_home/logs : error_log, error_log_plsql: check here for common errors
If forms doesnt open after login page auth, then there is a prblm with plsql
orainventory
Global Inventory ?
Global Inventory holds information about Oracle Products on a Machine. These products can be various oracle components like database, oracle application server, collaboration suite, soa suite, forms & reports or discoverer server . This global Inventory location will be determined by file oraInst.loc in /etc (on Linux) or /var/opt/oracle (solaris). If you want to see list of oracle products on machine check for file inventory.xml under ContentsXML in oraInventory Please note if you have multiple global Inventory on machine check all oraInventory directories)
You will see entry like
HOME NAME=”ORA10g_HOME” LOC=”/u01/oracle/10.2.0/db” TYPE=”O” IDX=”1″/
…
…
Local Inventory
Inventory inside each Oracle Home is called as local Inventory or oracle_home Inventory. This Inventory holds information to that oracle_home only.
Can I have multiple Global Inventory on a machine ?
Quite common questions is that can you have multiple global Inventory and answer is YES you can have multiple global Inventory but if your upgrading or applying patch then change Inventory Pointer oraInst.loc to respective location. If you are following single global Inventory and if you wish to uninstall any software then remove it from Global Inventory as well.
What to do if my Global Inventory is corrupted ?
No need to worry if your global Inventory is corrupted, you can recreate global Inventory on machine using Universal Installer and attach already Installed oracle home by option
-attachHome
./runInstaller -silent -attachHome -invPtrLoc $location_to_oraInst.loc
ORACLE_HOME=”Oracle_Home_Location” ORACLE_HOME_NAME=”Oracle_Home_Name”
CLUSTER_NODES=”{}”
opatch apply ... -invPtrloc [orainst.lov location]:
Specifies the location of the oraInst.loc file. The invPtrLoc option is needed when this option is used during installation. Oracle recommends the use of the default Central Inventory for a platform.
Global Inventory holds information about Oracle Products on a Machine. These products can be various oracle components like database, oracle application server, collaboration suite, soa suite, forms & reports or discoverer server . This global Inventory location will be determined by file oraInst.loc in /etc (on Linux) or /var/opt/oracle (solaris). If you want to see list of oracle products on machine check for file inventory.xml under ContentsXML in oraInventory Please note if you have multiple global Inventory on machine check all oraInventory directories)
You will see entry like
HOME NAME=”ORA10g_HOME” LOC=”/u01/oracle/10.2.0/db” TYPE=”O” IDX=”1″/
…
…
Local Inventory
Inventory inside each Oracle Home is called as local Inventory or oracle_home Inventory. This Inventory holds information to that oracle_home only.
Can I have multiple Global Inventory on a machine ?
Quite common questions is that can you have multiple global Inventory and answer is YES you can have multiple global Inventory but if your upgrading or applying patch then change Inventory Pointer oraInst.loc to respective location. If you are following single global Inventory and if you wish to uninstall any software then remove it from Global Inventory as well.
What to do if my Global Inventory is corrupted ?
No need to worry if your global Inventory is corrupted, you can recreate global Inventory on machine using Universal Installer and attach already Installed oracle home by option
-attachHome
./runInstaller -silent -attachHome -invPtrLoc $location_to_oraInst.loc
ORACLE_HOME=”Oracle_Home_Location” ORACLE_HOME_NAME=”Oracle_Home_Name”
CLUSTER_NODES=”{}”
opatch apply ... -invPtrloc [orainst.lov location]:
Specifies the location of the oraInst.loc file. The invPtrLoc option is needed when this option is used during installation. Oracle recommends the use of the default Central Inventory for a platform.
Thursday, November 18, 2010
explain plan with sql id
dbms_xplan.display_cursor(
sql_id IN VARCHAR2 DEFAULT NULL,
cursor_child_no IN INTEGER DEFAULT 0,
format IN VARCHAR2 DEFAULT 'TYPICAL')
RETURN dbms_xplan_type_table PIPELINED;
Format and display the contents of the execution plan of a stored SQL statement in the AWR
dbms_xplan.display_awr(
sql_id IN VARCHAR2,
plan_hash_value IN INTEGER DEFAULT NULL,
db_id IN INTEGER DEFAULT NULL,
format IN VARCHAR2 DEFAULT 'TYPICAL')
RETURN dbms_xplan_type_table PIPELINED;
sql_id IN VARCHAR2 DEFAULT NULL,
cursor_child_no IN INTEGER DEFAULT 0,
format IN VARCHAR2 DEFAULT 'TYPICAL')
RETURN dbms_xplan_type_table PIPELINED;
Format and display the contents of the execution plan of a stored SQL statement in the AWR
dbms_xplan.display_awr(
sql_id IN VARCHAR2,
plan_hash_value IN INTEGER DEFAULT NULL,
db_id IN INTEGER DEFAULT NULL,
format IN VARCHAR2 DEFAULT 'TYPICAL')
RETURN dbms_xplan_type_table PIPELINED;
tkprof
tkprof ora_12345.trc output.txt explain=scott/tiger
The statements between brackets are optional. Their meaning is:
explain=username/password: show an executionplan.
table= schema.tabelnaam : use this table for explain plan
print=integer restrict the number of shown SQL-statements.
insert=bestandsnaam Show SQL-statements and data within SQL statements
sys = NO Don't show statements that are executed under the SYS-schema. Most of the times these are recursive SQL-statements that are less interesting.
Aggregate=NO Don't aggregate SQL-statments that are executed more than once.
sort= Sort the SQL-statements. The option is made up of 2 parts:
part1:
Prs Sorteer op parse-values
Exe Sorteer op executie-values
fch Sorteer op fetch-values
Part 2:
Cnt Sort on number of calls
Cpu Sort on CPU-usage
Ela Sort on elapsed time
Dsk Sort on disk-reads
Qry Sort on consistent reads
Cu Sort on current reads
Mis Sort on library cache misses
row Sort on number of processed rows
Example:
sort=(prsela,exeela,fchela) (VAX VMS) sort = ‘(prsela,exeela,fchela)’ (UNIX) Sort on elapsed parse time, elapsed executed time and elapsed fetch-time.
The statements between brackets are optional. Their meaning is:
explain=username/password: show an executionplan.
table= schema.tabelnaam : use this table for explain plan
print=integer restrict the number of shown SQL-statements.
insert=bestandsnaam Show SQL-statements and data within SQL statements
sys = NO Don't show statements that are executed under the SYS-schema. Most of the times these are recursive SQL-statements that are less interesting.
Aggregate=NO Don't aggregate SQL-statments that are executed more than once.
sort= Sort the SQL-statements. The option is made up of 2 parts:
part1:
Prs Sorteer op parse-values
Exe Sorteer op executie-values
fch Sorteer op fetch-values
Part 2:
Cnt Sort on number of calls
Cpu Sort on CPU-usage
Ela Sort on elapsed time
Dsk Sort on disk-reads
Qry Sort on consistent reads
Cu Sort on current reads
Mis Sort on library cache misses
row Sort on number of processed rows
Example:
sort=(prsela,exeela,fchela) (VAX VMS) sort = ‘(prsela,exeela,fchela)’ (UNIX) Sort on elapsed parse time, elapsed executed time and elapsed fetch-time.
oracle versions
11g:
11.2.0.1
11.1.0.7
11.1.0.6
10g:
10.2.0.4
10.2.0.3
10.2.0.2
10.2.0.1
10.1.0.5
10.1.0.4
grid control:
CRS:
$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.3.0]
11.2.0.1
11.1.0.7
11.1.0.6
10g:
10.2.0.4
10.2.0.3
10.2.0.2
10.2.0.1
10.1.0.5
10.1.0.4
grid control:
CRS:
$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.3.0]
Subscribe to:
Posts (Atom)