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

Month: August 2017

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 APP-AR-96983 : User Write-off limit does not exist
Accounts ReceivablesErrors/Workarounds-AROracle Functional

ERROR

APP-AR-96983 : User Write-off limit does not exist

(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 Not showing  Open Interface Tab in Cash Management Form
Cash ManagementErrors/Workarounds-CMOracle Functional

ERROR

Not showing  Open Interface Tab in Cash Management Form For Matching Open interface transactions for reconciliation. 

(more…)