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

ORA-600 [KDZA_CHECK_EQ NOT IN DICTIONARY]

Recently started seeing this error on few of the RAC environments. ORA–00600: internal error code, arguments:[KDZA_CHECK_EQ NOT IN DICTIONARY] As per metalink this is a known Bug 24818566 Patch 24818566: SQLLOAD FAILED WITH ORA-600 [KDZA_CHECK_EQ NOT IN DICTIONARY] I’ve seen this in 11204 ,12102,12.2 both. As per Oracle it’s fixed in version 18.1

Read More

Oracle Cloud Infrastructure (1Z0-932)

Hi Readers Finally, I’ve successfully passed 1Z0-932, Oracle Cloud Infrastructure 2018 Architect Associate. It was almost more than 8-10 months that I’ve been preparing for this. The Exam contains 70 questions related to OCI which includes storage, VCN, Terraform, Knife, DNS etc.. To earn this certification you need to get 68% marks. This was the result of […]

Read More

Accessing the Oracle 18c Database in Vagrant VM

In the previous post, we learned the installation of Vagrant and provisioning the Oracle 18c Database in Vagrant VM. Oracle Database 18c installation with Vagrant Now, in this post, we will show how to access Oracle 18c Database in Vagrant VM. First of all, we can check the status of VM.

Next step uses […]

Read More

Oracle Database 18c installation with Vagrant

A vagrant is a tool for building and managing virtual machine environments in a single workflow. With an easy-to-use workflow and focus on automation, Vagrant lowers development environment setup time, increases production parity, and makes the “works on my machine” excuse a relic of the past. It provides easy to configure, reproducible, and portable work […]

Read More

Finally, the wait is over!! Now Oracle 18c is Available for on-Premise

Oracle Database 18c was released for on-premise as well. Oracle Database 18c, the latest generation of the world’s most popular database, is now available in Oracle Cloud and on Oracle Exadata. It provides businesses of all sizes with access to the world’s fastest, most scalable and reliable database technology for secure and cost-effective deployment of […]

Read More