Posts by Venkateshwaran Govindaraj

Failed to write core dump. Core dumps have been disabled. To enable core dumping, try “ulimit -c unlimited” before starting Java again

ERROR: Concurrent program error-ed out with below error, Failed to write core dump. Core dumps have been disabled. To enable core dumping, try “ulimit -c unlimited” before starting Java again…

Read More

How to setup password less ssh login in linux server

How to setup password less ssh login in linux server SSH is an open-source and most trusted network protocol that is use to login to remote server. It is use…

Read More

autoconfig failing – jtfictx.sh

ERROR: While running autoconfig i am getting below error, autoconfig failing – jtfictx.sh Solution: SQL> exec ctxsys.ctx_adm.set_parameter(‘file_access_role’, ‘public’) PL/SQL procedure successfully completed. After executing this run autoconfig.  

Read More

Perl lib version v5.8.3 doesn’t match executable version v5.10.0

Error: Perl lib version v5.8.3 doesn’t match executable version v5.10.0 Solution: export ORACLE_HOME=/u01/oracle_home/db/tech_st/12.1.0.2 export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0:$ORACLE_HOME/perl/site_perl/5.10.0:$ORACLE_HOME/appsutil/perl export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH check again perl version

Read More

Useful query to get user id, responsibility id and application id in EBS.

Useful query to get user id, responsibility id and application id in EBS. To know about User Id use below Query:- SQL> select user_id from fnd_user where user_name=’DOYEN’; To know…

Read More

How to enable or disable the event oracle.apps.icx.security.session.created

How to enable or disable the event oracle.apps.icx.security.session.created   1. Login to E-Business and navigate to Workflow Administrator Web Application > Business Event.Search for oracle.apps.icx.security.session.created 2. Then click on clock…

Read More

How to add legal entity to bank account

How to add legal entity to bank account Solution: 1. Using below navigation, please check if Workflow background engine is up and running: System Administrator -> Oracle application Manager ->…

Read More

How to change read write the Permissions on Concurrent Log and Output Files

How to change read write the Permissions on Concurrent Log and Output Files Solution Add umask 002 in .bash_profile(Linux). And then bounce the services.

Read More

Upgrade excel4wands apps from 5 to 21.1

Follow these steps to perform an upgrade. 1. Confirm that both the Excel4apps and Excel4apps Reports Wand applications have been registered on you system. a. Log on to the Oracle…

Read More

Kill inactive apex sessions in amazon RDS

set serveroutput on; begin for i in ( select sid, serial# from gv$session where status=’INACTIVE’ and type=’USER’ and program=’APEX Listener’ and last_call_et/60 > 5) loop dbms_output.put_line(‘begin’); dbms_output.put_line(‘rdsadmin.rdsadmin_util.kill(‘); dbms_output.put_line(‘sid =>’||i.sid||’,’); dbms_output.put_line(‘serial…

Read More