Enable FND Debug and get data from FND_LOG_MESSAGES table

Enable FND Debug and get log information from FND_LOG_MESSAGES table:

 

If the size of FND_LOG_MESSAGES table is too big? then

Considering running the concurrent request:  “Purge Debug Log and System Alerts”. 

 

 Enable Debug mode:-

=================

1)Log into system admin responsibility and set the following profile options

FND: Debug Log Enabled - Yes

FND: Debug Log Level - Statement  (Consider other options from the drop down if needed)

FND: Debug Log Module - %

 2)Capture the Max sequence number

 SELECT MAX(log_sequence)  b4seq# FROM fnd_log_messages;

 3)Try to reproduce the issue with above user for which FND profile options are set.

4)Capture the Max sequence number again:

SELECT MAX(log_sequence) afterseq# FROM fnd_log_messages;

5)Run following select to get the log messages

SELECT LOG_SEQUENCE, MESSAGE_TEXT, USER_ID FROM fnd_log_messages WHERE

log_sequence > b4seq# -1 and b4seq# 

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options ORA-27054 ORA-01580

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/08/2014 18:02:28
ORA-01580: error creating control backup file /export/u0/DBS/dbs/snapcf_DBSP1.f
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
Additional information: 1


The workaround recommended is to use the Event 10298.

sql> alter system set events '10298 trace name context forever, level 32';

 

 

11i/R12 query FND_NODES

    set lines 200
    col host_name for a11
    col node_name for a11
    col database for a10
    col concmgr for a9
    col forms for a7
    col webserver for a11
    col admin for a7
    select
    NODE_NAME,
    decode(STATUS,'Y','ACTIVE','INACTIVE') Status,
    decode(SUPPORT_CP,'Y', 'YES','NO') ConcMgr,
    decode(SUPPORT_FORMS,'Y','YES', 'NO') Forms,
    decode(SUPPORT_WEB,'Y','YES', 'NO') WebServer,
    decode(SUPPORT_ADMIN, 'Y','YES', 'NO') Admin,
    decode(SUPPORT_DB, 'Y','YES', 'NO') Database
    from fnd_nodes
    where node_name != 'AUTHENTICATION' order by NODE_NAME;

Kill all the O.S process of a particular user | kill -9

Want to kill all the O.S process that are running under particular user.

UNIX$ ps -aef  | grep -i shaik | awk '{print $2}' | sed 's/^/kill -9 /' > 1.txt
UNIX$./1.txt

Passed Exadata 1Z0-536

Got the result today and passed the 1Z0-536 Exadata implementation specialist certification.

Those who are planning to take the test.

Read the student guide-1 atleast 4-5 times and practice IORM as many times as possible. Most of the questions are scenario based and difficulty level was easy to moderate .

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=609&p_org_id=1001&lang=US&get_params=dc:D73668GC10,p_preview:N

From student guide-2 read the best practices and migrations, there was only one to two questions on monitoring so I wouldn't spend much time on guide-2 on the monitoring side.

Anyway it was easy and finally passed the test with 88% and now I am Oracle certified specialist..

Good luck everyone.