Oracle Exadata Database Machine 19.1.0 Documentation

Exadata System Software Release 19.1.0.0.0 is now generally available. This release lays the foundation for the Autonomous Database and improves every aspect of Exadata with 20+ features and enhancements. All new features and enhancements are available on all supported Exadata generations, protecting customer investment across all Exadata deployment models: on-premises, Cloud Service, and Cloud @ […]

Read More

Oracle Database 19c Now Available

The latest generation of the world’s #1 database, Oracle Database 19c, is now available on LiveSQL.oracle.com. Oracle Database 19c is a long term support release, with premier support planned through March 2023 and extended support through March 2026. For the latest Oracle Database 19c availability on other platforms, check out Document ID 742060.1 on My Oracle Support […]

Read More

RestAPI for Oracle DBaaS Cookbook

Written by Oracle Certified Master Skant Gupta and Oracle Certified Professional HariPrasath Rajaram are diligently planned to direct the readers about the usage of RestAPI with DBaaS. This book covers the most important trends providing operational best practice knowledge required for executing different API methods and calls facilitating the administration and execution of DBaaS features with Rest. […]

Read More

Oracle Database 18c New Features Book

Written by Oracle Certified Master Skant Gupta and Oracle Certified Master & Oracle ACED Joel Pérez describes the myriad new and enhanced capabilities available in the latest Oracle Database release. This book is meticulously planned for the audience keen to learn all about the amazing new features being offered by Oracle Database 18c. You must […]

Read More

ORA-00600 [qosdExpStatRead: expcnt mismatch]

Recently started seeing this error on few of the Exadata environments. ORA–00600: internal error code, arguments:[qosdExpStatRead: expcnt mismatch] Cause  This is due to sys.exp_obj$. EXP_CNT mismatch rows of sys.exp_stat$ Following SQL is used to check issue data of some objects. if there are some rows return, that means data issue. With b as ( select count(*) cnt,objn,snapshot_id from sys.exp_stat$ […]

Read More

Installing Oracle Database 18c with GitHub Repos

In this post, we can use GitHub reposirotry to fetch the repos and then be installing the Oracle Database 18c.  GitHub must be installed for this feature prerequisite. In your VM or Bare Metal, check the status and version of GitHub if it is installed.

As GitHub is not configured, we use YUM to install it with […]

Read More

PreBuilt Oracle Database 18c with Docker

In this post, we can use Docker service to pull the prebuilt Oracle Database 18c. Docker must be installed and running for this feature prerequisite. In your VM or Bare Metal, check the status and version of Docker if it is installed.

To Install Docker on your machine, please go to https://docs.docker.com/install/. As Docker is […]

Read More

ORA-00600 [KUTYXTTE_TRANSFORM:FAILED]

Recently started seeing this error on few of the Exadata environments. ORA–00600: internal error code, arguments:[KUTYXTTE_TRANSFORM:FAILED] As per metalink this is a known Bug 28194173 Patch 28194173: SQL ON 12.2 QUARANTINED AND CELL THROWING ORA-00600 [KUTYXTTE_TRANSFORM:FAILED] I’ve seen this in 12.2.

Read More

ORA-04030:QERGH hash-agg,kllcqas:kllsltba

In Oracle 12.2, ORA-04030:QERGH hash-agg,kllcqas:kllsltba, then we need do the following [oracle@local03 run]$ grep CRS_LIMIT_OPENFILE /u01/app/12.2.0.1/grid/crs/install/s_crsconfig_local03_env.txt Old value CRS_LIMIT_OPENFILE=65536 We need to change the value and restart the CRS New value CRS_LIMIT_OPENFILE=400000

Read More

ORA-600[KCLANTILOCK_17]

Recently started seeing this error on few of the RAC environments. ORA–00600: internal error code, arguments:[ORA-600[KCLANTILOCK_17] After upgrade to 12.2, Due to this Instance got crashed. As per metalink this is a known Bug 27162390 Patch 27162390: LNX64-181-RAC: LMS HIT ORA-600[KCLANTILOCK_17], INST CRASH I’ve seen this in 12.2. As per Oracle it’s fixed in version 18.1

Read More