Bullet Points:- Oracle Applications DBA

1). Environment Variable APPLFENV gives the environment variables file(*env file) which is sourced in the node

2).To find the Character Set of the Database

Use,

SQL>select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET'

3)To find the free disk space in ASM

Use,

SQL.select sum(free_mb) from v$asm_disk;

4).To skip the particular job when running a patch/maintenance pack
use the hidden option '8' in 'adctrl' to skip and start the job.


5)To check whether the Applications running on RAC

SQL>select is_rac_db from fnd_databases;Output would be either Y/N

6)To check the location of Voting Disk
Use ,

$crsctl query css votedisk

O/P would be somewhat like,

0 0 /dev/votediskLocated 1 Vote disk