Author Archives: Paras Shah

About Paras Shah

PARAS D. SHAH Email: parasshah04@gmail.com I’ve been working as Oracle DBA for more then 7+ years of experience. Known version: 7, 8i, 9i, 10g, 11, 12C Worked on: RAC, DATAGUARD, GOLDEN GATE,EBS suit, Backups and Restoration, Shell Scripts. Performance Tuning and analyzing database bottlenecks. Oracle Audit Vault and Database Firewall. Certifications:-  Oracle Database 11g Administrator Certified Associate. (OCA 11g)  Oracle Database 11g Administrator Certified Professional. (OCP 11g)  ITIL® Foundation Certificate in IT Service Management.

Querying MySql from ORACLE database

Posted on February 29, 2020 by Paras Shah

In most of the enterprise application setups there will be many application communicating with each other, and some of them might be in the different databases as well. There will be a requirement to have the data being pulled to … Continue reading →

Posted in Oracle DB | Leave a comment

OVM – Stuck Server Status Starting

Posted on October 3, 2018 by Paras Shah

(Oracle Virtual Machine) OVM – 3.4.4 Here when logged into the OVM Manager console , we see that the status of the server in the Server pool shows as “Starting” and not as STARTED , this is happened after usually … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

DB Vault: Datapump error ORA-39127 ORA-01031

Posted on April 4, 2018 by Paras Shah

This is just the small post regarding the error while running the Datapump export/import in the database environment where the DB Vault option is enabled. DB Version: 11.2.0.4 The Expdp commnad used to export the dump of a table expdp … Continue reading →

Posted in Oracle DB | Leave a comment

Spectre and Meltdown impact on Oracle DB performance

Posted on February 7, 2018 by Paras Shah

The effect of applying the fix for Specter and Meltdown patch on the Database server. The Oracle Database server kernel was patched in order to mitigate the Specter and Meltdown issue. Post the kernel patch was applied the performance of … Continue reading →

Posted in Oracle DB | Tagged , , | Leave a comment

AVDF: Add DB as Secured Target

Posted on January 4, 2018 by Paras Shah

This post demonstrates how to add Oracle DB as secured target in AVDF 12.2 Continue reading →

Posted in Oracle DB | Tagged , | 6 Comments

OPATCHAUTO Failed on RAC OUI-67200

Posted on December 12, 2017 by Paras Shah

OPatch auto Failed on one of the two Node RAC due to Re-link fails on target “ioracle”. With possible corruption of libserver12.a file Continue reading →

Posted in Oracle DB | Tagged , , | Leave a comment

AVDF: Configure Second NIC card

Posted on September 21, 2017 by Paras Shah

AVDF: Configure Second NIC card Continue reading →

Posted in Oracle DB | Tagged | Leave a comment

AVDF: Blank Entitlement Changes Report

Posted on September 6, 2017 by Paras Shah

Entitlement Changes report comes Blank Continue reading →

Posted in Oracle DB | Tagged | Leave a comment

AVDF : Add DB server to audit vault 12.2

Posted on August 29, 2017 by Paras Shah

Database Server add to configuration on your Audit Vault to have the audit trail to be collected on the centralized location which is Audit Vault. Continue reading →

Posted in Oracle DB | Tagged , | 15 Comments

AVDF: Unlock and reset AVSYS password

Posted on August 29, 2017 by Paras Shah

This is Small post in which one can learn how to unlock and reset the AVSYS account password in Oracle Audit Vault 12.2.0.5 (AVDF). The AVSYS account is kept locked in the Audit Vault database after the installation is done. The Audit Vault database has the Database Vault option also enabled. Continue reading →

Posted in Oracle DB | Tagged , | 34 Comments