ERROR While starting database ORA-03113: end-of-file on communication channel Problem: On further diagnosis of ADRCI logs, I found disk space size assigned to Flash recovery area falling short Solution: Mount…
Read MoreERROR: JServer JAVA Virtual Machine Component Is in Removing state CAUSE: SQL> select comp_name, version, status from dba_registry; COMP_NAME VERSION STATUS —————————————- —————————— ———– Oracle Database Catalog Views 12.1.0.2.0 VALID…
Read MoreERROR: ORA-38760: This database instance failed to turn on flashback database CAUSE: When we are upgrading from 12c to 19c we faced below error, SQL> alter database open; alter database…
Read MoreError: Workflow notification mailer goes down frequently. While we checking at the workflow log file in $APPLCSF/log location(FNDCPGSC786733.txt), we can able to see below error Thread[outboundThreadGroup1,5,outboundThreadGroup]:1236469374:48520:1626634875670:61:UNEXPECTED:[SVC-GSM-WFMLRSVC-786733-10006 : oracle.apps.fnd.cp.gsc.Processor.run()]:java.lang.NumberFormatException: For input…
Read MoreERROR: 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 MoreHow 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 MoreERROR: 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 MoreError: 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 MoreUseful 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 MoreHow 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