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 have some prior experience of working with Oracle 12c to leverage the complete benefit from this publication.

Key Features –

ORA-00600 [qosdExpStatRead: expcnt mismatch]

Recently started seeing this error on few of the Exadata environments.

ORA00600: 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$ es group by objn,snapshot_id)
select * (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.

[root@ORA006 ~]# git version
bash: git: command not found

As GitHub is not configured, we use YUM to install it with root user and recheck for GitHub version.

[root@ORA006  (more...)