Latest Technology Blog

Issue: After installing 11gR2, i faced issue of ORA-01102 cannot mount database in EXCLUSIVE mode when i tried to start the database. SQL> startup ORACLE instance started. Total System Global Area 1653518336 bytes Fixed Size                  2213896 bytes Variable Size             956303352 bytes Database Buffers          687865856 bytes Redo Buffers                7135232 bytes ORA-01102: cannot mount database in EXCLUSIVE mode Solution: Step 1. Shutdown the database. Step 2. Kill all the process running related to Oracle Database  ---------------------------------- [oracle@testing shm]$ ps -ef | grep ora_ | grep $ORACLE_SID oracle     843     1  0 02:20 ?        00:00:00 ora_w000_TEST oracle   23844     1  0 01:48 ?        00:00:00 ...

Issue: We were facing issue in our R12 (12.1.3) E-business suite environment, where all of sudden users were not able to get the login page but existing users were able to use forms/navigate between forms, but not able to use JSP pages. After investigation, we came to know the root cause of the issue. Log File Location:  $INST_TOP/logs/ora/10.1.3/opmn/oacore_default_group_1/ oacorestd.err 14/08/12 12:21:51 java.lang.OutOfMemoryError: Java heap space 14/08/12 12:23:05 java.lang.OutOfMemoryError: GC overhead limit exceeded Solution: Reset the Java Heap Size in your R12 application server. Step 1: Identify the maximum Heap Size you can set in your server. applprod@server:~$ java -mx4096m -version Invalid maximum heap size: -Xmx4096m The specified size exceeds the maximum representable size. Could not create the Java virtual machine. applprod@server:~$ java -mx3048m -version java version "1.6.0_10" Java(TM) SE Runtime Environment (build 1.6.0_1...