Support ID : How to enable and retrieve FND debug log messages

If you want to know about FND Debug log configuration in R12, this below document id is useful for you

How to enable and retrieve FND debug log messages (Doc ID 433199.1)


PERWSDOR form compile in r12

export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US

cd $ORACLE_HOME/bin

[appltrng@ebsdev bin]$   frmcmp_batch module=/u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/PERWSDOR.fmb userid=apps/Ace321b output_file=/u02/backup/appltrng/apps/apps_st/appl/per/12.0.0/forms/US/PERWSDOR.fmx module_type=form batch=no compile_all=yes

Compiling WHEN-BUTTON-PRESSED trigger on PREV_MONTH item in CALENDAR data block…
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEXT_MONTH item in CALENDAR data block…
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEXT_YEAR item in CALENDAR data block…
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on PREV_YEAR item in CALENDAR data block…
No compilation errors.
Created form file /u02/backup/appltrng/apps/apps_st/appl/per/12.0.0/forms/US/PERWSDOR.fmx


asm spfile

The below article useful to know about asm spfile and How asm instance started if spfile in diskgroup without mount.

http://asmsupportguy.blogspot.in/2014/03/asm-spfile-in-disk-group.html

This article he explained for  normal redundancy . If you want to find the spfile on external redundancy level, you can use below command

[oracle@asmoracle ~]$ asmcmd lsdsk -G DATA
Path
/dev/oracleasm/disks/DISK1
/dev/oracleasm/disks/DISK2


[oracle@asmoracle ~]$ kfed read /dev/oracleasm/disks/DISK1 | grep -E 'spf|ausize'
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.spfile: 1450 ;  (more...)

Force option in ASM

This below url is very useful to know about force option in asm

http://asmsupportguy.blogspot.com/2011/12/forcing-issue.html


Create diskgroup in ASM

Steps for creating diskgroup in ASM (Single Node)

 

Step 1: Add new HDD to server and done partition. Here I added two HDD

[root@asmoracle ~]# fdisk /dev/sde
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklab el
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.

Warning: invalid flag 0x0000 of  (more...)

Patch applied or not in R12

you can get the patch applied details in EBS R12 from below command

 

select AP.PATCH_NAME, AP.PATCH_TYPE, AD.DRIVER_FILE_NAME, AD.CREATION_DATE, AD.PLATFORM,AL.LANGUAGE
from AD_APPLIED_PATCHES AP, AD_PATCH_DRIVERS AD, AD_PATCH_DRIVER_LANGS AL
where AP.APPLIED_PATCH_ID = AD.APPLIED_PATCH_ID
and AD.PATCH_DRIVER_ID = AL.PATCH_DRIVER_ID and AP.PATCH_NAME='17627621'

Compile pll file in R12

If you like to compile pll file in R12, you can use frmcmp_batch command instead of using  f60gen

 

Example :

cd $AU_TOP/resource

frmcmp_batch module=/u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/resource/HRLOCAL.pll userid=apps/apps output_file=/u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/resource/HRLOCAL.plx module_type=library batch=yes compile_all=special


ASM ab_+ASM.dat hc_+ASM.dat

ab_+ASM.dat : This file generated when asm instance startup. this file  is used by the RDBMS instance to determine the appropriate enviornment information whenever the RDBMS instance connects to the asm instance. If this file is removed, RDBMS instance can not able to connect to ASM

For Example :

[oracle@asmoracle ~]$ cd /u01/app/oracle/11.2.0/grid/dbhome_1/dbs/
[oracle@asmoracle dbs]$ ls
ab_+ASM.dat hc_+ASM.dat initasm.ora init.ora orapw+ASM spfile+ASM.ora

Removed this file or rename (more...)

ASM Startup

The startup for ASM instance are similar to those for RDBMS instances

For Example Nomount option start  up an asm instance without mounting any diskgroups.

SQL> startup nomount
ASM instance started

Total System Global Area 283930624 bytes
Fixed Size 2212656 bytes
Variable Size 256552144 bytes
ASM Cache 25165824 bytes

SQL> select name,state from v$asm_diskgroup;

NAME STATE
—————————— ———–
DATA DISMOUNTED

Mount option is used to mount the all diskgroup specified in ASM_DISKGROUPS init.ora parameter.

(more...)

desc dba_views does not exist in database open stage

While you issued this dba_*  dictionary views on database mount

SQL> alter database mount;

Database altered.

SQL> desc dba_views;
ERROR:
ORA-04043: object dba_views does not exist

After database opened

SQL> alter database open;

Database altered.

SQL> desc dba_views;
ERROR:
ORA-04043: object dba_views does not exist

Don’t issue this command on database mount stage

Restart the database normal

or

SQL> alter system flush shared_pool;

System altered.

SQL> desc dba_views;
Name Null? Type
—————————————– ——– —————————-

OWNER (more...)