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

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 how much memory to be allocated to jvms
$ias_config_home-, 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


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

./runInstaller -silent -attachHome -invPtrLoc $location_to_oraInst.loc
ORACLE_HOME=”Oracle_Home_Location” ORACLE_HOME_NAME=”Oracle_Home_Name”

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

cursor_child_no IN INTEGER DEFAULT 0,
RETURN dbms_xplan_type_table PIPELINED;

Format and display the contents of the execution plan of a stored SQL statement in the AWR
sql_id IN VARCHAR2,
plan_hash_value IN INTEGER DEFAULT NULL,
RETURN dbms_xplan_type_table PIPELINED;


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:
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

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



grid control:


$ crsctl query crs activeversion
CRS active version on the cluster is []