Oracle Application Testing Suite (OATS): Few Tips & Tricks

OATS is a suite of applications that can be used for performance and scalability testing, functional and regression testing. It is a thin client application that runs within a web browser - so, it is easy to use the tool from anywhere as long as the web server running on the host node is accessible. Hopefully the following tips and tricks will benefit some of the users of the Oracle Application Testing Suite.

Few technical details first - OATS is a 32-bit Java application that runs in a WebLogic container (WLS) with Oracle XE database being the backend store for test session data.

[Trick] Issue : OATS software fails to install on 64-bit Windows systems

Download and install 64-bit .NET framework manually before installing the OATS software. Look for .NET framework on Microsoft's downloads website.

[Trick] Issue : OATS software fails to install on systems with large number of [virtual] CPUs

On systems with many cores/vCPUs, Oracle database in general requires large amounts of memory to be configured for SGA - so, one solution would be to allocate as much memory as required. However Oracle XE limits the memory utilization within the database to 1 GB. Besides, XE uses only one CPU even if there are multiple CPUs available on a system. Hence one workaround is to limit the number of vCPUs that the system exposes during the installation of OATS software. The steps are shown below.

  • Start button -> Run -> type "msconfig"
  • Click on Boot tab -> Advanced Options
  • Check "Number of processors" and set appropriate value (I believe we can go up to 16)
  • Reboot Windows
  • Uninstall failed OATS installation and try installing again
  • Undo the above made changes after the successful installation of OATS
  • Reboot Windows one final time

Thanks to my colleague Bao Doan for providing this workaround.

[Trick] Issue : During runtime, OATS drive the load and executes the test as expected but fails to collect runtime statistics

This is another limitation of Oracle XE database. Until 10g, XE limits the maximum amount of user data in the database to 4 GB. This limit was raised to 11 GB in release Oracle 11g XE. OATS 9.x releases bundle Oracle 10g XE. To take advantage of the larger limit for data, install Oracle 11g XE manually before installing OATS software. OATS installer gives the option to use an existing installation of Oracle XE. Besides, it is not possible to have multiple Oracle XE installations on a single box anyway (that's another XE limitation).

For existing installations, one workaround is to remove old and unwanted sessions to make room for new sessions in the database. Listed below are the steps.

  • Connect to the Oracle Load Testing (OLT) tool
  • Click on "Manage" top-level menu (upper right corner) -> Sessions
  • Click on any unwanted session and press "Delete" button (I recommend deleting one session at a time)

[Trick] Issue : Under load, there are many network timeouts with ton of sockets in TIME_WAIT state on OATS agent systems including the OATS Controller node

Tune TCP/IP parameters on Windows as shown below.

  • Launch Windows registry
  • Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TcpIP\parameters
  • Configure the following two parameters. If not found, create those parameters by selecting Edit -> New -> DWORD Value from the menu bar. Select "Decimal" under Base.
      TcpTimedWaitDelay : 30 [seconds]
      MaxUserPort : 65534
  • Reboot Windows

Thanks to my colleagues Dino and Vishnu for sharing this workaround.

[Trick] Issue : OATS Controller does not show any graphs or analysis reports

Install Adobe Flash Plugin and try again.

[Trick] Issue : Under load, OATS Controller stops collecting runtime statistics at some random point

Check Oracle database alert log for some clue(s). If there is an error message such as "ORA-12516: TNS:listener could not find available handler with matching protocol stack", connect to the database, query v$resource_limit view and compare the values reported under CURRENT_UTILIZATION and MAX_UTILIZATION for the resource "processes". If the current utilization is pretty close to the configured maximum value, raise the value for processes parameter in [S]PFILE.

[Tip] Balancing the load among multiple OATS agent systems

One simple way is to create a VU Agent System Group based on the available agent systems. Steps listed below.

  • Connect to the Oracle Load Testing (OLT) tool
  • Click on "Manage" top-level menu (upper right corner) -> Systems
  • Click on "VU Agent System Group" in the left hand side
  • On the right hand side, click on "New" option
  • Select all the agent systems that you want to be part of the "VU Agent System Group"
  • Finally name the newly created system group and save

Note that it is not possible to attach weights to the agent systems - so, it is suggested to have agent systems with similar hardware configurations in the VU Agent System Group.

[Tip] Balancing the load among multiple web servers using OATS Controller

If there are multiple web server instances running in a enterprise application deployment; and OATS software is being used to test the performance and scalability of the application, parameterizing the web server hostname and port number in OATS test script will take care of the web server load balancing problem. Of course there are many alternatives to this approach such as using a hardware load balancer, using web server Reverse Proxy etc.,

[Added on 01/19/2012]

[Tip] How-To check the available space in USERS tablespace?

Run the following on OATS Controller node:

Start -> All Programs -> Oracle Database XX Express Edition -> Run SQL Command Line

SQL> connect / as sysdba

SQL> SELECT /* + RULE */  df.tablespace_name "Tablespace",
       df.bytes / (1024 * 1024) "Size (MB)",
       SUM(fs.bytes) / (1024 * 1024) "Free (MB)",
       Nvl(Round(SUM(fs.bytes) * 100 / df.bytes),1) "% Free",
       Round((df.bytes - SUM(fs.bytes)) * 100 / df.bytes) "% Used"
  FROM dba_free_space fs,
       (SELECT tablespace_name,SUM(bytes) bytes
          FROM dba_data_files
         GROUP BY tablespace_name) df
 WHERE fs.tablespace_name (+)  = df.tablespace_name
 GROUP BY df.tablespace_name,df.bytes
SELECT /* + RULE */ df.tablespace_name tspace,
       fs.bytes / (1024 * 1024),
       SUM(df.bytes_free) / (1024 * 1024),
       Nvl(Round((SUM(fs.bytes) - df.bytes_used) * 100 / fs.bytes), 1),
       Round((SUM(fs.bytes) - df.bytes_free) * 100 / fs.bytes)
  FROM dba_temp_files fs,
       (SELECT tablespace_name,bytes_free,bytes_used
          FROM v$temp_space_header
         GROUP BY tablespace_name,bytes_free,bytes_used) df
 WHERE fs.tablespace_name (+)  = df.tablespace_name
 GROUP BY df.tablespace_name,fs.bytes,df.bytes_free,df.bytes_used

Copy/paste the above SQL code in a text file with sql extension and execute that SQL statement by calling the SQL script from SQL> command prompt. eg., assuming the above code was saved in a plain text file called chktblspcusg.sql under C:\ drive, execute the SQL script as shown below:

SQL> @C:\chktblspcusg.sql

[Added on 06/27/2012]

[Trick] Issue : An attempt to open a test script in OpenScript fails with error

'Failed to open script' has encountered a problem.
Failed to open <script_name>. See error log for details.

Clicking on "Details" button provides the following clue.

The project description file (.project) for '<script_name>' is missing"

In addition the title bar shows "Relocating Eclipse Projects: The project description file (.project) for XXX is missing".

Navigate to C:\Documents and Settings\Administrator\osworkspace\.metadata\.plugins\org.eclipse.core.resources\.projects\

Look for the directory by name "<failing_script_name>" and remove it

[Added on 08/03/2012]

[Trick] Issue: Unexpected Agent exit. Code = 51 in the middle of an OLT load test

When running a load scenario in Oracle Load Testing (OLT) that uses a databank, the scenario runs fine for some time and then all of a sudden fails with the following error: Unexpected Agent exit. Code = 51.


The following settings may alleviate the issue.

  • - toggle/experiment with the settings for "Clear cache between iterations" and "Clear cache before playing back"
    • those settings can be found under the test script preferences -> Playback -> Web Functional -> Miscellaneous
  • - experiment with different values for "Maximum users per process" setting
    • this setting is under OLT -> Configure all parameters -> Advanced
  • - increase the Java heap size (both min & max) in file <OATS_HOME>\agentmanager\bin\AgentManagerService.conf
    • default values: min heap size: 16 MB; max heap size: 64 MB

Contributors: John Snyder, Richard Barry

[Added 02/25/13]

Another colleague Dave Suri has an alternate tip to resolve the Agent 51 issue.

Edit <OATS_HOME>\agentmanager\processDescriptors\

Change the following lines:



process.debug.custom=-verbose:gc -XX:+HeapDumpOnOutOfMemoryError -Xms512M 
-Xmx1536M -jrockit -Xrs -XgcPrio:deterministic -XpauseTarget=50ms 
-XX:+UseCallProfiling -XX:+UseAdaptiveFatSpin -XX:+ExitOnOutOfMemoryError 
-XXnoSystemGC -XX:+UseFastTime

I'm no OATS expert - merely documented what we found along with solutions and workarounds. Feel free to post your question(s) in the comments section. Hopefully someone will respond.

See Also:


I am able to test the connection to the Agent through the controller, but while running OLT I get an error in communication to the agent. Following is from the agentmanager.log on the agent machine, Remote host closed connection during handshake
at sun.nio.cs.StreamDecoder.readBytes(
at sun.nio.cs.StreamDecoder.implRead(
at oracle.oats.empstart.PortListener.readFromSocket(
Caused by: SSL peer shut down incorrectly
The agent is on a compute node in exalogic and controller is on my desktop.
Please help. Thanks.

Posted by guest on January 16, 2012 at 02:20 PM PST #

Can you confirm if you are running the agent service with system administrator privileges. Also ensure that the firewall is not blocking secure connections.

If the playback script connects to a secure site, you may also have to play with OLT options for SSL. Otherwise try disabling SSL for OLT from WebLogic Console.

Posted by Giri Mandalika on January 17, 2012 at 07:41 PM PST #

"can not get a connection from the browser helper after 15 seconds." error message has occurred when i am trying to start the record button in oracle application testing suite

Posted by kalyan on June 01, 2012 at 02:12 AM PDT #

OATS - Mail configuration:

I'm trying to test the mail configuration, but I can't arrive to configure a good one. Should I change the default port 25, but where? This is the descriptive message.

Status: javax.mail.MessagingException: Could not connect to SMTP host:, port: 25; nested exception is: Permission denied: connect

Posted by guest on August 09, 2012 at 12:25 PM PDT #

I am receiving the following error when trying to open a script in Oracle open script
'Failed to open script' has encountered a problem.
Failed to open <script_name>. See error log for details.

I have tried you solution but there is no "<failing_script_name>" folder in specified path. How can i resolve this issue ?

Posted by guest on August 27, 2012 at 11:21 AM PDT #


I am trying to trigger the execution of the scripts stored in my local machine repository to another host (Just as how OTM does that on selecting the target machine). Could you provide me any info about the commands which can be used to achieve the same.


Posted by Kalidas on December 13, 2012 at 10:42 PM PST #

Hi ,
How can I make the Functions and stored into Library in OATS?, so that I can use modular approach. and let me some other tutorial links or ppt for OATS testing tool.

Posted by guest on February 12, 2013 at 04:08 AM PST #

Here is something that can help too....for agent=51.

You need to edit the C:\OracleATS\agentmanager\processDescriptors\

Change this:

#process.debug.custom=<custom keys here>

To this:

process.debug.custom=-verbose:gc -XX:+HeapDumpOnOutOfMemoryError -Xms512M -Xmx1536M -jrockit -Xrs -XgcPrio:deterministic -XpauseTarget=50ms -XX:+UseCallProfiling -XX:+UseAdaptiveFatSpin -XX:+ExitOnOutOfMemoryError -XXnoSystemGC -XX:+UseFastTime

Posted by dave s on February 22, 2013 at 11:31 AM PST #

Hi - I am using databanks and my question is, is there a way I can get records during run time?

Posted by guest on March 05, 2013 at 09:18 AM PST #

How to get URL value from current open browser?

Posted by Shilpa on May 14, 2013 at 12:03 AM PDT #

Hi- I'm using OATS on Windows Server 2008. I tried to record Oracle forms using OATS, but encountered the following problem:

After the browser is launched, application is unable to record any of the objects on the web page, but the application is successfully recording Oracle "forms" objects.

Can anyone suggest to solve this problem??

Posted by guest on May 16, 2013 at 04:57 AM PDT #

Can I use OATS libraries without it's IDE? I.e. I would like to use it's functionality to operate with Oracle Forms in testing project that uses different tehnologies, has our standart structure and developed with more suitable IDE. So I need to port OATS-libraries and run OATS-tests in any way.


Posted by Dmitry on May 28, 2013 at 06:49 AM PDT #

Hello Every one,

I am Rizwan Saheb working as a Performance Tester.

It will be great help if you explain how exactly the OATS tool maintain Header Parsing?.

Thanks in-advance.
Rizwan Saheb

Posted by guest on June 28, 2013 at 03:24 AM PDT #

I can not run IE8 by openscript version oats-full- & also uninstall & delete cache & restart PC and then again install but not working. My PC is 32 bit operating system.

Posted by guest on July 13, 2013 at 11:02 PM PDT #

My client's instance is running on java7 and while opening the ebs form its asking to install java7.

Now if I am using java7 then Oats recording is not working (means browser is not launching). I checked and found oats recording and playback works only if jre6 is installed.

Can we use jre7 for recording in oats.

Posted by Pawan on November 12, 2013 at 03:57 AM PST #

I am having issue while recording the new test using open-script. I am using already existent object library (attaching it from assets before recording) which contains almost all objects on that UI where i am doing recording for new test. Here am having confusion that when i am doing new recording i expect the scrip should be intelligent enough to use already existent object from object library but sometimes i can see "object name_1, object name_2" is being created in the scrip.

Please confirm how to make sure that while creating new scrip, it uses object from object library attached to assets and any new object which is getting added should able to identify.

Posted by Saurabh Thawali on November 21, 2013 at 11:19 PM PST #

Hi When we try to connect to Siebel Many time OATS through Error Failed to Connect to Siebel Server,and if the same code if run in Bits a& Pieces it works fine.Can any one help me in this

Posted by guest on February 10, 2014 at 02:31 PM PST #

How can i input a file into a load project.

When i recorded the test, after i press "load a file">select the file from the disk i stop the recording.

After i load the project after i press" load a file" the test can't select the file on the disk.

Posted by Sterescu Gabriel on April 11, 2014 at 08:19 AM PDT #

Hi When iam runninf Script from OLT i am getting error as Unexpected Agent exit. Code = 69 and Status as Orphaned Agent
Can anyone please help me out
Thank You in Advance

Posted by guest on April 28, 2014 at 01:47 AM PDT #

Hi All,

When i am Runuing the scripts in Oracle Load agent getting faield "js_afrLoop_2". It is working in Open Scripts.

Question : How to correlate Parameters in URL.

Anyone please help on this .It is vey urgent.

http.solve("js_afrLoop_2", "\"_afrLoop\", \"(.+?)\"", "",
false, Source.Html, 0, EncodeOptions.None);

53, "{{js_afrLoop_2,2774501436787073}}&_afrWindowMode=0&_afrWindowId={{newWindowId,17hf8u1kjp_6}}", null, null, true, "UTF8", "UTF8")

Posted by Surender on May 27, 2014 at 11:05 PM PDT #

Hi All,

I have executed on test with Oracle Load Testing sucessfully. But we are getting N/A vaules in the report (Session) instead of values

Name Min Max Avg Pass Warning Fail Std Dev 90th %
Param N/A N/A N/A N/A 0

Plz help on this

Posted by surender on May 30, 2014 at 04:19 AM PDT #

Regarding N/A values: one possibility is that USERS tablespace reached the maximum limit. In that case, removing unwanted sessions may help.

Posted by Giri Mandalika on May 30, 2014 at 11:37 AM PDT #


I am new to OATS. I am trying to record web/http script for load testing. But its not recording any url's and objects. How to record web/script like functional script with all page details.


Posted by guest on June 04, 2014 at 03:32 AM PDT #


I am trying record web/http script but its not recording page content.
Just recording first url address. how can i record web/http script like functional script with all page details.


Posted by Anush on June 04, 2014 at 03:34 AM PDT #

Hi All,

How to delete uploaded scripts in Oracle Load testing. I want to delete uploaded scripts in Oracle Load Testing

Can you please help on this

Thanks in advance

Posted by surender on June 09, 2014 at 03:49 AM PDT #

Surender, please try this:

1) Launch OpenScript
2) Tools (top-level menu) -> Manage Scripts

Select the script that you want to remove, and click on "Delete" button.

Posted by Giri Mandalika on June 09, 2014 at 03:55 PM PDT #


I want to delete uploaded scripts in Oracle Load testing (Agent/ COntroller).


Posted by Surender on June 09, 2014 at 11:46 PM PDT #

Issue: OATS 12.3 or 12.4 software fails to install Oracle XE.

Resolution: OATS 12.3 or 12.4 installer always stops while trying to install on Windows 7. I followed the recommended steps as mentioned in this 'Tips n Tricks' section but installation stopped for XE setup.

I found the workaround that install Oracle XE first from the OATS installer as it was failing to install. Later, uninstalled the OATS setup, and re-installed OATS. Installation completed successfully and did not complain about Oracle XE.

Posted by Jaish Mishra on June 18, 2014 at 11:35 PM PDT #

Hi All,

I want to automate flex UI witout recompiling it (Dont have code level access). Is it possible with OATS.

Thanks in advance

Posted by Saif on July 03, 2014 at 08:06 PM PDT #

Hi All,

How do Performance Analysis for Test.

Could you please share the details .

Thanks in advance


Posted by minttu on July 16, 2014 at 12:01 AM PDT #

Hi All,

I am facing some performance issue while running open script(Web functional) in OATS.
I have 5 line of in-line function(With in the same script) which will be called more then 50 times in whole 350 line script.
I am observing a drastic change execution time of that function, first time it took 5 sec next time 8 Sec then 14 sec 20, 24, on.

Can some one emplane me why this is happening and how to rectify that.

Posted by guest on July 24, 2014 at 10:26 PM PDT #

Hi All,

How to add monitoring counters to Test in Oracle Load testing.

I am trying to add , but we are getting Error .

WE have useing 12.4 version of OATS


Posted by guest on July 25, 2014 at 02:23 AM PDT #

do we really need to install Oracle db First before the installation of OATS on Redhat Enterprise Linux x64 ?
and can any one plz provide me some kind of step by step guide to install OATS
thanks !

Posted by Agha Azeem on August 12, 2014 at 06:49 AM PDT #

HI All,

I have installed oracle 11g then I installed Oracle Application Testing Suite.
After installation of testing suite I am unable to connect database and getting below error. could you someone help on this.

An error was encountered performing the requested operation:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
01034. 00000 - "ORACLE not available"
*Cause: Oracle was not started up. Possible causes include the following
- The SGA requires more space than was allocated for it.
- The operating-system variable pointing to the instance is
improperly defined.
*Action: Refer to accompanying messages for possible causes and correct
the problem mentioned in the other messages.
If Oracle has been initialized, then on some operating systems,
verify that Oracle was linked correctly. See the platform
specific Oracle documentation.
Vendor code 1034


Posted by guest on September 24, 2014 at 05:33 AM PDT #


can any one please share the step by step OATS Load testing Tool ( for performance testing) like how to
1. record the script to do the paramaterisation to do the correlation
4.How to desigh scenario for multiple users to publish results

Posted by ranjith on February 26, 2015 at 04:41 AM PST #


I am unable to upload an excel file in oats. Please help me how to do that

Posted by Nikita on March 31, 2015 at 11:06 PM PDT #


Can OATS& Flow builder run against OL6?

Flow Builder Release Notes states "Prerequisites: Oracle Linux 5 (64 bit)".
Oracle Application Testing Suite Installation Guide states that: "Oracle Application Testing Suite components have been tested with Oracle Enterprise Linux 5.1 64 bit, 5.2 64 bit, 4u8 64 bit".

Has anyone tried?

Best Regards,

Posted by guest on April 01, 2015 at 12:05 AM PDT #


I am getting the out of memory error has occurred. Consult the Running Eclipse section and asking me if I want to exit the workbench in Open Script.

Any work around solution ? OATS 12.5 version I am using

Posted by Vishal Kumar on April 02, 2015 at 10:47 PM PDT #

Hi Team,

I am unable to install OATS 9.2.0 Software in windows 7 64bit

Posted by guest on April 06, 2015 at 11:57 PM PDT #

Hi, when i am running load test with multiple scripts in a scenario through OLT i start getting "Thin Browser exception occurred" after some time. All Vusers start failing with this error code irrespective of there current step. I believe if my OLT Agent's memory is low then i should get Out of memory error. I am not able to debug this. Could you please let me know if you have encountered similar issue

Posted by kiranh on April 13, 2015 at 12:35 AM PDT #

"can not get a connection from the browser helper after 15 seconds." error message has occurred when i am trying to start the record button in oracle application testing suite

Posted by guest on April 13, 2015 at 11:17 PM PDT #

Go to internet option, manage addons options there check if oracle ATS* ADDONS are enabled. If not enable them , close browser and try again with oats.

Posted by guest on April 14, 2015 at 07:56 PM PDT #


Is there any training video available for OATS?

Thanks in advance

Posted by guest on April 17, 2015 at 12:36 AM PDT #


Posted by guest on May 06, 2015 at 10:27 PM PDT #


While recording, Oracle Forms application responds very slow. Please provide me suitable resolution for the same. I use the recommended JRE and IE version.

Thanks in advance

Posted by Pratik on July 30, 2015 at 01:33 AM PDT #

Hi,I am getting OpenScript ASReplay Build ( requires plug-in "oracle.oats.asreplay.lib". while installing plug-in in anyone have idea??

Posted by guest on August 05, 2015 at 07:56 AM PDT #

Hi ,

I am new to FT OATS.
I want ot know how to downlaod whole open test script result(playback result) in FT OATS.

e.g suppose, I want only specific screenshots of the test script and download those test results in PDF format.

If it's doable then please reply's urgent

Posted by guest on September 03, 2015 at 12:25 AM PDT #

I am trying to execute a siebel script.
I have recorded all the steps performed in siebel application. All steps are recorded fine.
When I playback, the script timesout at a confirm dailog box. (Waiting for object timeout).
It is a browser pop up. Oracle Support says that all popus are considered as errors, but then again it is recorded properly.
I have increased the duration of timeout, but face the same issue. I have also analyzed the path with Inspect Path and added it in library as well.

Please let me know if anyone else has faced this issue.

Posted by guest on November 17, 2015 at 08:58 PM PST #

Post a Comment:
  • HTML Syntax: NOT allowed

Benchmark announcements, HOW-TOs, Tips and Troubleshooting


« February 2016