Errors/Workarounds-Applications

August 1, 2017 Using OA framework, it errors With Error 404–Not Found

APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

When clearing all cache in Functional Administrator or Using OA framework, it errors With Error 404–Not Found : EBS 12.2.3
(more…)

August 1, 2017 adoafmctl.sh: exiting with status 152

APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

Starting OPMN managed OAFM OC4J instance …

adoafmctl.sh: exiting with status 152
(more…)

August 1, 2017 ORA-16038: log cannot be archived ORA-19809: limit exceeded forrecovery files

APPS DBAErrors/Workarounds-ApplicationsErrors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle APPS DBAOracle Database Material

ERROR

ARC3: Error 19809 Creating archive log file to ‘+DISKS’

Errors in file /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc1_6598.trc:

ORA-19815: WARNING: db_recovery_file_dest_size of 42687547752 bytes is 100.00% used,

and has 0 remaining bytes available.

SOLUTION

This problem normally occurs when our flash recovery area is full , we have two option to solve this problem:

1. Add size to flash_recovery_area if we have free disk space.

SQL> alter system set db_recovery_file_dest_size=5G;

2. Delete some archivelogs to free flash_recovery_area.

RMAN> crosscheck archivelog all;

RMAN> delete expired archivelog all;

RMAN> delete obsolete;

August 1, 2017 Unable to get passwords from Vault

APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

Completed database cleanup for previous session.

Error: Unable to execute statement <
Begin
ad_jar.get_jripasswords(:l_storepass, :l_keypass);
End;
> len = 63

AD Administration error:
ORA-01031: insufficient privileges
ORA-06512: at “SYS.DBMS_SESSION”, line 101
ORA-06512: at “APPS.AD_JAR”, line 17
ORA-06512: at line 3

AD Administration error:

Unable to get passwords from Vault

You should check the file
/u01/apps/apps_st/appl/admin/FMSGST/log/adadmin.log

for errors.

SOLUTION

$ sqlplus sys “/as sysdba”

SQL>@adgrants.sql APPS