foalabs

Javacache.log Flooded With Java.lang.OutOfMemoryError Error Messages In EBS 12.1.3 environment, a file Javacache.log growing rapidly around 100GB and consuming most  space on mount. The log file was filled with "Java.lang.OutOfMemoryError Error Messages" . The issue is caused by JVM debug log level was not be set. Workaround: ============== The processes when verified was used by the OPP manager process.  Command:  fuser javacache.log  To fix the issue--> Restart the OPP Output Post Processor manager  Other Solution ============== 1) Take backup of oc4j.properties 2) Add below parameter in below files. IASCACHELOGLEVEL=0   >> Value is Zero. $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/oc4j.properties [applmgr@appsenv config]$ diff oc4j.properties_1303470_bkp oc4j.properties 129a130,131 > #Parameter for JavaCachelog_TKT_1303470 > IASCACHELOGLEVEL=0 If autoconfig runs, it overwrite the file and value will be diminish. Hence we changed in t...

Enabling Debugging Mode in SSH to Troubleshoot Connectivity Issues: Understanding the Verbosity Levels (-v, -vv, -vvv) Secure Shell (SSH) is a widely used protocol for establishing secure communication channels over an unsecured network. Connectivity issues can occasionally arise, hindering successful connections to remote servers. Enabling debugging mode in SSH provides a detailed view of the connection process, aiding in the identification and resolution of potential problems. This article will explore the steps to enable debugging mode and delve into the differences between the verbosity levels (-v, -vv, -vvv) to help users effectively troubleshoot SSH connectivity issues. Why Enable Debugging Mode? Debugging mode in SSH serves as a diagnostic tool by producing verbose output that reveals the intricacies of the connection process. By increasing the verbosity level, users can obtain more detailed information about authentication, key exchange, and potential errors, facilitating the t...

Active Session History (ASH) Performed An Emergency Flush Messages In The Alert Log Active Session History (ASH) performed an emergency flush. This may mean that ASH is undersized. If emergency flushes are a recurring issue, you may consider increasing ASH size by setting the value of _ASH_SIZE to a sufficiently large value. Currently, ASH size is 19922944 bytes. Both ASH size and the total number of emergency flushes since instance startup can be monitored by running the following query: select total_size,awr_flush_emergency_count from v$ash_info;  So actually this is not an alert. it warn us that ASH size is filled. ASH are is used for session info for historical views. some db’s are creates more ASH info, because they have more session and transactions.  We can increase ASH area. sqlplus / as sysdba alter system set "_ash_size"=25165824; You can verify the change using the following select: select total_size from v$ash_info; NOTE: The max setting for "_ash_size" ...

Running Gather stats in Oracle Apps Error on FND_STATS_HIST Error: When running Gather stats in Oracle apps it fails with below ERROR: While GATHER_TABLE_STATS: object_name=APPS.RA_INTERFACE_LINES_ALL_07APR2023**ORA-12899: value too large for column "APPLSYS"."FND_STATS_HIST"."OBJECT_NAME" (actual: 32, maximum: 30)** Solution: Modify the Column length alter table applsys.fnd_stats_hist modify object_name varchar2(128); If you like please follow and comment

Script to Set newname in  RMAN Restore on new Server or Database If you are restoring the database on another server with a different directory structure, you can leverage the RMAN SET NEWNAME command to map the old file names to the new file locations.  Steps: 1. Check datafile location on the production environment SQL> select name from v$datafile; NAME ------------------------------------------------------------------ /u01/app/oracle/oradata/system01.dbf /u01/app/oracle/oradata/sysaux01.dbf /u01/app/oracle/oradata/undotbs01.dbf /u01/app/oracle/oradata/users01.dbf /u01/app/oracle/oradata/und01.dbf 2. Generate set newname command for each data file individually The set newname command will be used to restore the database in a different location (/u02/datafile/). set linesize 300 col file_name format a120 select 'set newname for datafile ' ||FILE#|| ' to '||'''/u02/datafile/'|| substr(name,instr(name,'/',-1)+1, instr(substr(name,instr(name,...

Restore database from a RMAN backup taken on the OCI Object Storage to new host Earlier I shared on how can we take RMAN backup on a cloud object storage in OCI.  Refer how to take RMAN Backup on OCI Object Storage by clicking here In this post I am going to share on how can we restore that backup on a new host. The OCI bucket act as a TAPE backup.  Pre-requisites We must know the following: DBID of the source database Password used to encrypt the backup if password-based encryption was used TDE encryption wallet from the source database if TDE encryption was used OCI backup: Steps: 1) Install the Oracle Database Cloud Backup Module for OCI . I have already shared in below link. Refer how to take RMAN Backup on OCI Object Storage by clicking here 2)  Get the DB id from source. In OCI bucket a folder will be present with same DBID SQL> select dbid from v$database;       DBID ---------- 2716435786 3)  Take pfile from source and create a target pfile. ...

Encountering error ORA-19836 when taking and moving Oracle RMAN backup to the Oracle Cloud (OCI) Error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on c1 channel at 10/11/2018 10:06:22 ORA-19836: cannot use passphrase encryption for this backup Bug 21315524 : ORA-19836: CANNOT USE PASSPHRASE ENCRYPTION FOR THIS BACK Solution Workaround is instead of using set encryption on identified by only; use set encryption on ; in backup script. SET ENCRYPTION IDENTIFIED BY "foadbbackup23" ONLY; Replace with  SET ENCRYPTION ON; If you like please follow and comment

RMAN-06091 no channel allocated for maintenance (of an appropriate type) When backing up archive logs, RMAN script ended with below errors. actually backup finished successfully. but when delete backed up archive logs, RMAN ended with error because of obsolete backups. This error is related with the reported in Bug 28391990, which has been superseded by the fix of unpublished Bug 28432129: Bug 28432129: RMAN-06091: no channel allocated for maintenance (of an appropriate type) after installing July 2018 (DBPSU/BP/RU) (Note 28432129.8) Fixed Version : 19.1  Error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of delete command at 01/06/2024 08:27:46 RMAN-06091: no channel allocated for maintenance (of an appropriate type)  Solution: We should delete the obsolete backups as follows. ...

Change Sysadmin Password in Oracle Apps from sqlplus I am sharing the below on how to change SYSADMIN password and Application User Login passwords using fnd_user_pkg from backend.  fnd_user_pkg tool : This package maintains oracle application user accounts Script: Connect as apps user to sqlplus sqlplus apps/apps declare var_l boolean; begin var_l=fnd_user_pkg.change_password('sysadmin','sysadmin_new_pwd'); end; / You can verify from backend that password has changed successfully or not without login to the application. select fnd_web_sec.validate_login('sysadmin','sysadminpwd') from dual; It should returns 'Y'. If you like please follow and comment

Xlib: No protocol specified ERROR : While Running the report  and the output is in pdf format the following error is encountered. Error in the log file: Xlib: connection to "fundb:0.0" refused by server Xlib: No protocol specified Xlib: connection to "fundb:0.0" refused by server Xlib: No protocol specified REP-3000: Internal error starting Oracle Toolkit. REP-3000: Internal error starting Oracle Toolkit Solution: Enter in to the Node where the Report is Running and can also done in all the nodes Steps: 1 : Login as user root. 2 : export DISPLAY=localhost:0.0 3 : xhost + 4 : To Check the Display put the following : echo $DISPLAY 5 : We can also check by entering in as any other user ex:oracle or applmgr user and give xclock. So that it will display clock. Note :Before setting the DISPLAY check the XML file in APPL_TOP/ADMIN and inside the xml file see the parameter DISPLAY = "hostname:0.0"  . this should be same as when we give echo $DISPLAY 6 : Now bounce...

How to Enable and Disable Firewall in Solaris server To Enable the Firewall: svcadm enable svc:/network/ipfilter:default To Disable the Firewall: svcadm disable svc:/network/ipfilter:default To check the status of the Firewall: ipfstat -io I f you like please follow and comment

How to find password of a User in Oracle Apps Create Package and run query --Package Specification CREATE OR REPLACE PACKAGE get_pwd AS    FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)       RETURN VARCHAR2; END get_pwd; / --Package Body CREATE OR REPLACE PACKAGE BODY get_pwd AS    FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)       RETURN VARCHAR2    AS       LANGUAGE JAVA       NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String'; END get_pwd; / --Query to execute SELECT usr.user_name,        get_pwd.decrypt           ((SELECT (SELECT get_pwd.decrypt                               (fnd_web_sec.get_guest_username_pwd,                       ...