Davis Apps DBA

I need to use XML Publisher Administrator but the responsibility is not shown in the Navigator panel. While checking the responsibilities of SYSADMIN user, it is already assigned but still it is not shown. In such case follow this post to solve the issue. If still the issue remains the same, then proceed with the below steps. 1. First check the responsibility is end-dated or not. If it is end-dated, then remove end-date, clear the functional cache, logout, login and check. If it is not end-dated, then follow the below steps. Go to Responsibility -> Define form, query the specific responsibility, then change the value of "Available From"  to 'Oracle Applications' if it has any other options selected. Now save the changes made, clear the functional cache as below and re-login and check the status. This time the responsibility will be shown in the Navigator. Ref:  E-Business Suite : Responsibilities Are Not Visible...

In this post we'll see how to reclaim unused space from TEMP tablespace of Oracle database. My Environment: DB : Oracle 12c (12.1.0.2.0) First check the tablesapce usage of TEMP. Here the above SS shows free space is 0. This should not be the case. So we need to check the space used by TEMP segments from different views. SELECT   A.tablespace_name tablespace, D.mb_total,          SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,          D.mb_total - SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_free FROM     v$sort_segment A,          (          SELECT   B.name, C.block_size, SUM (C.bytes) / 1024 / 1024 mb_total          FROM     v$tablespace B, v$tempfile C          WHERE    B.ts#= C.ts#          GROUP BY B.name, C.bloc...

In this post we'll see about Roll forwarding a physical standby database using a compressed backupset in a detailed step by step process. Identifying the issue For some reasons logs are not getting applied in my standby site. So I follow the below steps to identify the issue. @Primary SQL> select name,database_role,open_mode,protection_mode from v$database; Now we should Identify which datafile of standby database is out of sync with Primary database by using the below query. SQL> col SUBSTR(HXFNM,1,40) for a40 SQL> set lines 200 pages 250 SQL> select HXFIL File_num,substr(HXFNM,1,40),fhscn from x$kcvfh; SQL> select current_scn from v$database; @Standby Stop the MRP process SQL> alter database recover managed standby database cancel; SQL> select name,database_role, open_mode, protection_mode from v$database; Run the same query we executed on Primary here at the standby for crosschecking purpose. ...