Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

AppsDBA CV Download CV Contact Me

APPS DBA

August 1, 2017 HOW to Verify and Change oc4jadmin password

APPS DBAInstallations/Configurations-ApplicationsOracle APPS DBA

HOW to Verify and Change oc4jadmin Password

Step 1. Run the below command as applmgr user to verify oc4jadmin Password:

$ java -jar $IAS_ORACLE_HOME/j2ee/home/jazn.jar -checkpasswd jazn.com oc4jadmin -pw *****
Successful verification of user/password pair.

***** = oc4jadmin password

If the message is not successful then password can be changed through system-jazn-data.xml file:

Step 2. Shutdown all opmn services :

cd $ADMIN_SCRIPTS_HOME
adstpall.sh / adopmnctl.sh stopall

Step 3. $cd $ORACLE_HOME/j2ee/home/config

Here ORACLE_HOME= Oracle Application server home, ie, 10.1.3 HOME
Take a backup of system-jazn-data.xml and edit the below content:

<user>
<name>oc4jadmin</name>
<display-name>OC4J Administrator</display-name>
<guid>93E5A2505D1511DEBF8E89BC12E10097</guid>
<description>OC4J Administrator</description>
<credentials>!newpassword</credentials>
</user>

Marked in bold is the New Password to be changed . Note an ! mark has to prefixed with the password.

Step 4. Start all opmn services.

Run autoconfig is after this , password changes to encrypted format.

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 Oracle financials interface tables

Accounts PayablesAccounts ReceivablesAPPS DBAConfigurations-APConfigurations-ARConfigurations-CMConfigurations-FAConfigurations-GLFixed AssetsGeneral LedgerInstallations/Configurations-ApplicationsOracle FunctionalScripts

General Ledger Interface Tables

GL_BUDGET_INTERFACE
GL_DAILY_RATES_INTERFACE
GL_DRM_HIERARCHY_INTERFACE
GL_DRM_SEGVALUES_INTERFACE
GL_IMP_COA_ERR_INTERFACE
GL_IMP_COA_NORM_HIER_INTERFACE
GL_IMP_COA_SEG_VAL_INTERFACE
GL_IEA_INTERFACE
GL_INTERFACE
GL_INTERFACE_CONTROL
GL_INTERFACE_HISTORY
GL_REPORT_INTERFACE
GL_XFR_INTERFACE

Account Payables (AP) Interface Tables

AP_INTERFACE_CONTROLS
AP_INTERFACE_REJECTIONS
AP_INVOICE_INTERFACE
AP_INVOICE_LINES_INTERFACE
OIE_POL_RATES_INTERFACE

Account Receivables (AR) Interface Tables

AR_PAYMENTS_INTERFACE_ALL
AR_TAX_INTERFACE
HZ_PARTY_INTERFACE
HZ_PARTY_INTERFACE_ERRORS
RA_CUSTOMERS_INTERFACE_ALL
RE_INTERFACE_DISTRIBUTION_ALL
RA_INTERFACE_ERRORS_ALL
RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALESCREDITS_ALL
AR_INTERFACE_CONTS_ALL
AR_PMTS_INTERFACE_HEADER_GT
AR_PMTS_INTERFACE_LINES_GT
AR_PMTS_INTERFACE_LINE_DETAILS
HZ_DQM_SH_SYNC_INTERFACE
HZ_DQM_SYNC_INTERFACE
RA_INTERFACE_REQID_GT

Fixed Assets (FA) Interface Tables

FA_BUDGET_INTERFACE
FA_INV_INTERFACE
FA_PRODUCTION_INTERFACE
FA_TAX_INTERFACE
FA_TRANSACTION_INTERFACE

Cash Management (CE) Interface Tables

CE_ARCH_INTERFACE_HEADERS
CE_ARCH_INTERFACE_HEADERS_ALL
CE_ARCH_INTERFACE_LINES
CE_HEADER_INTERFACE_ERRORS
CE_LINE_INTERFACE_ERRORS
CE_STATEMENT_LINES_INTERFACE
CE_UK_VALIDATIONS_INTERFACE

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