Find Oracle Applications Login URL from database

Find Oracle Applications Login URL from database

SQL> SELECT home_url FROM icx_parameters;

SQL> SELECT profile_option_value FROM fnd_profile_option_values WHERE profile_option_id= (SELECT profile_option_id FROM fnd_profile_options WHERE profile_option_name = 'APPS_FRAMEWORK_AGENT') AND level_value = 0;

Oracle R12 Forms Not Opening In Browser

Oracle R12 Forms Not Opening In Browser

Issue:

When trying to open forms in R12, following error is coming

 Solution:


1. Go to Start >  Control Panel


2. Click on Java Control Panel and select tab "security" and make Security Level "Medium"

 3. Also, add URL in the Exception Site List. For e.g http://xyz.erp.com:8000 and apply it

How to Find Sessions Generating Lots of Redo or Archive logs

How to Find Sessions Generating Lots of Redo or Archive logs (Doc ID 167492.1)

TO CHECK SESSIONS

SQL> SELECT s.sid, s.serial#, s.username, s.program,
i.block_changes
FROM v$session s, v$sess_io i
WHERE s.sid = i.sid
ORDER BY 5 desc, 1, 2, 3, 4;

TO CHECK TRANSACTIONS

SQL> SELECT s.sid, s.serial#, s.username, s.program,
t.used_ublk, t.used_urec
FROM v$session s, v$transaction t
WHERE s.taddr = t.addr
ORDER BY 5 desc, 6 desc, 1, 2, 3, 4

TO CHECK EXACT QUERY

SELECT address ,SUBSTR(sql_text,1,1000) Text, buffer_gets, executions,
buffer_gets/executions AVG
FROM v$sqlarea a, v$session s
WHERE sid = <SID>
AND s.sql_address = a.address
AND executions > 0
ORDER BY 5;


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

Empty the linux buffer cache

Empty the Linux buffer cache

sync && echo 3 > /proc/sys/vm/drop_caches

Change Oracle password temporarily

Change Oracle password temporarily

SQL> SELECT a.username, b.password FROM dba_users a, sys.user$ b WHERE a.username = 'AHMED' AND a.user_id = b.user#


USERNAME PASSWORD
-------- ----------------
AHMED 3KD55KGFST529KT5


SQL> alter user HRPAY identified by newpassword

After completing your work , now you can change the password back by using an undocumented feature called "by values"

SQL>alter user AHMED identified by values '3KD55KGFST529KT5';