Upgrading Oracle TimesTen In-memory Database and Oracle Analytics Server

Oracle TimesTen offers faster response times and high throughput, while Oracle Analytics Server modernizes analytics with AI-powered insights and a user-friendly experience. This technical article focuses on how to upgrade Oracle TimesTen In Memory Database and Oracle Analytics Server and the benefits you can expect.
oracle 23c Reinstate Oracle Database Oracle TimesTen In Memory Database 19c Waived-Fee Extended Support Oracle Partner Oracle Sustaining Support
Picture of Written by Sharan Bidnoorkar

Written by Sharan Bidnoorkar

Oracle Application Database Administrator at Blue Crystal Solutions

Upgrading Oracle TimesTen In Memory Database and Oracle Analytics Server

This technical article focuses on upgrading Oracle TimesTen In Memory Database and Oracle Analytics Server. The existing system faces challenges such as database invalidation issues, crashes, and version incompatibility. To overcome these issues and take advantage of the latest features, upgrading to TimesTen version 22.1.x and Oracle Analytics Server version 6.4.0 is recommended. The upgrade involves essential steps such as software download, installation, configuration updates, and post-checks. Maintenance activities, including backup, recovery, administration, and patching, are also highlighted. Oracle TimesTen offers faster response times and high throughput, while Oracle Analytics Server modernizes analytics with AI-powered insights and a user-friendly experience. BCS demonstrated the benefits of this upgrade with successful implementation for a government client in the health space. 

Why upgrade?  

  • Production TimesTen continues to have database invalidation issues and crashes. 
  • The end of error correction for Oracle Analytics Server 5.5.0 version was March 2022, and Oracle Analytics Server 5.5.0 is incompatible with the latest version of TimesTen 22.1.x 

A solution to TimesTen Database invalidation and crashes is to upgrade TimesTen to latest version 22.1.x, as well as upgrade Oracle Analytics Server from 5.5.0 to 6.4.0 in order to support latest TimesTen version 22.1.x and ensure premier support and to take advantage of the latest features. 

How to complete the upgrade: 

Oracle TimesTen In-Memory Database

  1. Download and stage TimesTen software. 
  2. Graceful shutdown of TimesTen 11g 
  3. Prepare server for Oracle TimesTen installation. 
  4. Install TimesTen 22.1.x software. 
  5. Create Oracle TimesTen Instance tt221 and Create Oracle Database  
  6. Update config files. 
  7. Start TimesTen Full Data Load  
  8. Perform post checks.
  9. Run ETL refresh and Incremental loads. 
  10. Perform Post Refresh Test 

Oracle Analytics Server 

  1. Download and stage OAS software and prepare server for OAS upgrade. 
  2. Install the FMW Infrastructure ( and Oracle Analytics 6.4.0 
  3. Run Upgrade Assistant in Readiness Mode and Review Readiness Report 
  4. Shutdown Oracle Analytics Server 5.5 and take a backup of domain. 
  5. Upgrade Product Schemas and Reconfigure Domain configuration. 
  6. Upgrade Domain components 
  7. Start the Oracle Analytics 6.4.0 Services 
  8. Perform post checks. 
Maintenance activities: 
  • TimesTen Install, Upgrade, migrate. 
  • TimesTen backup and recovery 
  • TimesTen Administration and patching 
  • Oracle Analytics & its components Lifecyle management (start/stop/status) using scripts and consoles. 
  • Oracle Analytics and underlying Fusion middleware, Database administration, maintenance, and patching 
  • Oracle Analytics snapshots, backups, and recovery 
  • Quarterly CPU patch review, plan and deploy. 
  • Oracle Analytics Install, Upgrade, migrate and integrate. 
Benefits of Oracle TimesTen In Memory Database: 
  • Oracle TimesTen In Memory Database is a memory-optimized relational database that provides applications with extremely fast response time and very high throughput. 
  • TimesTen databases reside entirely in physical memory with persistence to disk storage for recoverability. 
  • Oracle TimesTen databases durability is achieved through a combination of transaction logging and database checkpointing to disk. 
  • Applications access TimesTen databases using standard SQL and PL/SQL via JDBC, ODBC
Benefits of Oracle Analytics Server: 
  • Oracle Analytics Server enables customers to modernize their analytics while having the flexibility to move to the cloud at their own pace. 
  • Leverage AI-powered augmented analytics for machine learning assisted data enrichment and analysis. 
  • Experience self-service data visualization and a modern analytics user experience.
  • Drive innovation; explore and discover new insights by combining structured and unstructured data. 
  • Get faster time to insights with Explain, an AI engine that uses machine learning to show correlations, distributions, and segmentation in data.
Success Story: 

BCS has assisted the customer in upgrading TimesTen and Oracle Analytics Server to the latest version, it was an exciting and challenging experience, as well as a valuable learning experience. With proper planning and testing in the lower environments DEV and TEST, we discovered and resolved a wide variety of issues, which enabled us to transition smoothly into production for TimesTen 22.1.x and Oracle Analytics Server 6.4.0. 

Discover more about what we can do with Oracle.


Learn More.

When our Logistics client required a comprehensive health check and ongoing support for their two critical Oracle databases which supported the JD Edwards Logistics package essential for their distribution function, Blue Crystal Solutions were able to step in and remove the risks of instability, lack of future support, performance issues, non-scalable custom code and more.

Before digital archives, the nation's scientific data was stored in hard copies, susceptible to destruction. Yet, even with modern cloud storage like AWS, consistent updates and security measures are crucial to safeguard information. Blue Crystal Solutions (Blue Crystal) aided our Australian Federal Government client to securely upgrade and migrate biodiversity data.

We are continuing to grow and are looking for an Application Support and enhancement team member to join our Adelaide based team.

Blue Crystal Solutions: your trusted & innovative IT partner.

Australian owned and operated since 2004, we provide information technology services locally, nationally and beyond.

We are a specialised supplier of Cloud, Application, Database & Infrastructure, Operating System Management, Modernisation and Transformation services. With security at the forefront of everything we do, we can also work with your cyber teams to significantly improve your security posture whilst ensuring all your services with us are fortified by our integrated outage protection and 24×7 monitoring tool, BlueDiamond

Scroll to Top