Oracle Autonomous Health Framework is a collection of components that analyzes the diagnostic data collected, and proactively identifies issues before they affect the health of your clusters or your Oracle Real Application Clusters (Oracle RAC) databases. Oracle Autonomous Health Framework contains Oracle ORAchk, Oracle EXAchk, and Oracle Trace File Analyzer. Install Oracle Autonomous Health FrameworkRead more about Oracle Autonomous Health Framework (Former TFA)[…]
MySQL Overview and Storage Engines (article 1)
MySQL’s most important feature is its storage-engine architecture, whose design separates query processing, optimization etc.. from data storage and retrieval. This feature let users to choose data storage and performance features and other characteristics. Main functionality related to the processing of SQL, managing caches, Parsing and optimization lays in the third layer in the aboveRead more about MySQL Overview and Storage Engines (article 1)[…]
Tableau Desktop with MongoDB
MongoDB BI Connector is required for connecting Tableau Desktop to MongoDB database. Tableau uses MongoDB ODBC driver at client side to talk to MongoDB database. So we need to install MongoDB ODBC driver on the client side. A system DSN has to be created using ODBC administrator for Tableau Desktop to use during the connectionRead more about Tableau Desktop with MongoDB[…]
Installing and configuring MongoDB on Oracle Enterprise Linux.
In this article I am installing MongoDB on Oracle Enterprise Linux 7 (OEL 7). This is 64 bit OEL 7 Installation. Installing MongoDB community Edition is done using yum repository. First step is to create a /etc/yum.repos.d/mongodb-org-4.2.repo file so that you can install MongoDB directly using yum: [root@snode1 yum.repos.d]# cat mongodb-enterprise-4.2.repo[mongodb-enterprise-4.2]name=MongoDB Enterprise Repositorybaseurl=https://repo.mongodb.com/yum/redhat/$releasever/mongodb-enterprise/4.2/$basearch/gpgcheck=1enabled=1gpgkey=https://www.mongodb.org/static/pgp/server-4.2.asc Install the MongoDB package To installRead more about Installing and configuring MongoDB on Oracle Enterprise Linux.[…]
Oracle RAC Internals
Oracle Clusterware is the fundation of Oracle Real Application Cluster (Oracle RAC). Cluster Management Software that runs on top of Operating system maintains cluster coherence between the various nodes in the cluster and manages components, such as shard disk, node membership, instance membership etc. In erlier version os RAC, Oracle only supported nodes with directRead more about Oracle RAC Internals[…]
Oracle 19c RAC (Grid Infrastructure) Installation.
Oracle 19c has upgraded some of the minimum requirements such as the operating system distribution, packages, and other software requirements for Oracle Grid Infrastructure installation. A default Linux installation includes most of the required packages and helps you limit manual verification of package dependencies. Oracle does not support Leaf nodes in 19c. In Oracle Grid Infrastructure 19cRead more about Oracle 19c RAC (Grid Infrastructure) Installation.[…]
Rollback Segment Count settings in Oracle Database
One caveat of altering _rollback_segment_count to a higher value and reducing is that Oracle will never drop/remove newly created rollback segments. The segments will be OFFLINE after you restart the database. I just did some experiments with _rollback_segment_count in Primary/Standby environment. From Primary, we can see _rollback_segment_count is set to 0 and 11 rollback segmentsRead more about Rollback Segment Count settings in Oracle Database[…]
RAC node not joining cluster – Grid Interprocess Communication (GIPC)
GIPC is daemon used for inter-process communication between the nodes. This also support Redundant Interconnect Usage. GIPC Daemon (gipcd.bin)has an end point ‘gipcha://nodename:xxx’. You can see this in the below log entry. 2019-03-14 23:26:56.429 : GIPCGEN:718243584: gipcRequestSaveInfo: client took long time 2300 ms for consuming request 0x7fbc2407e530 [000000001b23a413] { gipcReceiveRequest : peerName ‘gipcha://stone:nm2_primcluster/ed1f-1959-1be4-9d99’, data 0x7fbc24092df8,Read more about RAC node not joining cluster – Grid Interprocess Communication (GIPC)[…]
Oracle Standby Redo Transport SYNC mode Tracing
Standby database is replica of Primary database synchronized using redo log (archived redo log). Redo log generated in Primary is send to standby depending upon transport settings in primary. It can be send using Log Write or Archiver process. There are 3 Dataguard protection modes. They are Maximum Availability, Maximum Performance and Maximum Protection. InRead more about Oracle Standby Redo Transport SYNC mode Tracing[…]
Rolling Upgrade Oracle 11.2.0.2 database to Oracle 12.1.0.2 using Standby with No Downtime
It is possible to use Standby database to upgrade a database with near no downtime. Application may experience a failover/switchover but no real downtime window that really interrupt the continued availability of application. This is using Oracle Logical standby feature as that allows application to connect to the database with read/write capability. This is no-RACRead more about Rolling Upgrade Oracle 11.2.0.2 database to Oracle 12.1.0.2 using Standby with No Downtime[…]