APEX - Tomcat error : java.lang.OutOfMemoryError: Java heap space solution

Have you experienced the following error when using APEX-ords in Tomcat?

• Environment : Tomcat 8 Windows 10
• Symptom : java.lang.OutOfMemoryError: Java heap space when submit grid edit or array g_f02..g_fn
• Solution : Change initial memory pool & maximum memory pool

After searching for solutions on the internet, many suggest arranging memory through catalina.bat or setenv.bat like Morten's suggestion. but Tomcat on windows cannot recognize the environment.

The solution you just need to run Tomcat8w.exe at %TOMCAT_HOME%bin, and configure the memory via the GUI and then restart Tomcat.

How to relocate datafile from one drive to other without shutdown db

1. Login to SQL*Plus
2. Connect as SYS DBA with CONNECT / AS SYSDBA command
3. Make offline the affected tablespace

ALTER TABLESPACE tablespace_name OFFLINE;

4. Modify the name or location of datafiles in Oracle data dictionary using following command syntax:

ALTER TABLESPACE tablespace_name
RENAME DATAFILE 'fully qualified path to original data file name' 
TO 'new or original fully qualified path to new or original data file name';

5. Bring the tablespace online again

ALTER TABLESPACE tablespace_name ONLINE;

6. If you experienced this error : ORA-01113, execute this syntax:

recover datafile 'new fully qualified path to original data file name'

source : otn

Can You Build Application and Go Live in Six Months?

The answer is Yes we can, if:

We have the Operations Team with the concept of mature business processes and understand the systems approach when transform a manual process into the IT system.

You are an experienced developer and willing to adopt the best standards.

You have the end-user militant to jointly perform data entry and testing of applications, and then use it in everyday transactions.

Full support of the company's management.

I post this to share how to build an aplication with the concept of RAD (Rapid Application Develoment) can be achieved. Four factors I described above should be synergized to get there, if you are in the position of the second factor (as developers) usually have a tendency of less expensive non-technical factors, can be guaranteed not to be. As well as any best software you have if no synergy of all four of these factors it is not unattainable.

Okay, to measure the success of an app I would narrow the parameters of what is called success :

• Applications have Go Live and in use in everyday transactions replace existing manual processes
• Maintaining business continuity between the actual processes and processes used in the IT application.

Process & Team

This is an example of a case when building an application "Tailor-Made" called IP-ICOFR CSA Online, I was fortunate enough to do so by a synergy of the four factors that I mentioned earlier.

I would normally ask for a team that includes: business analyst, I as a developer and other components depending on the needs will be called "Operation Team". This team will become one entity, no longer act as lonely developer, despite the fact that I am the only developer :D, but to the unity of IT application system will be talking about all the problems and decided by this team.

For myself, I do the following:

• Provide enough time to build the Blue-print business process applications, with interview and fairly intensive discussion, do not rush to the design phase of the application until the blue-print is obtained.
• To the business analyst I ask: "Do not let me do the assumptions of a process, give me certainty"
• Do not always accept an idea without giving an alternative that is better if there is one. Because the business user perspective they should also be viewed and considered how it goes in the IT system.
• Study the business processes in depth so that we will be able to predict how these applications will evolve in the future.
• Mutual open to understanding ideas and receive feedback about how the system they will be built.

From the Operation Team: Business Analyst side

• Giving a good presentation to the management about: the staging, the process, the planned schedule, and asked for support for every phase of which will be run.
• Understand that there are stages that will be achieved requires the process to be accommodated in a certain phase, it will not necessarily have to be adopted at that time.
• All demand/request for features will be through team and filter based on: the need, and readiness phase. I relayed: "I just listen to one side, namely through Operation Team".
• Always provide certainty of process, if still doubt be delayed until absolutely sure as to what it should be.

Finally, with hard work and synergies of these four factors we succeeded in realizing a Go Live application within 6 months, which has been implemented into the entire units of PT. Indonesia Power

• Kantor Pusat (Headquarters)
• Unit Jasa Pemeliharaan
• UJP Banten 1 Suralaya
• UJP Banten 2 Labuan
• UJP Banten 3 Lontar
• UJP Banten 4 Cilegon
• UJP Pelabuhan Ratu
• UJP Adipala
• UJP Pangkalan Susu
• UPJP Priok
• UP Suralaya
• UP Saguling
• UPJP Kamojang
• UP Mrica
• UP Semarang
• UP Perak Grati
• UPJP Bali

Rundown Phase

• 01 Nopember 2015 : Kick Off Project

27-29 Januari 2016 : Workshop/UAT (Operation Team Level) - Bandung

17-19 Februari 2016 : Workshop/UAT (User Admin Level) - Semarang

11-15 April 2016 : Workshop/UAT (End User Level) - Bali

21-23 April 2016 : Go Live (Indonesia Power's Annual Financial Forum 2016) – Jogjakarta

Technology

• Oracle Application Express (APEX) 5.0.3.00.03 with ORDS Listener 3.0.2.294.08.40
• Oracle Database Enterprise Edition Release 12.1.0.2.0 - 64bit (Linux Redhat)
• Oracle WebLogic Server 12.2.1.0.0
• Oracle BI Publisher 11.1.1.6.8

Features

• Flexible Setup : BPM & Hierachy Team
• Multiplatform browser
• Responsive Web Design
• Email notification & Subscription
• Interactive Reports
• Multi format Report
• Online Video tutorial

ICOFR- Control Self Assesment References

• Internal Control
• Sarbanes–Oxley Act