ODA (Oracle Data Appliance) – Simulator – Part 1

ODA (Oracle Data Appliance) is a engineered machine designed for small and medium organization to host their databases. This engineered machine enables to host databases with HA feature (RAC).   Make sure to  not to mix this up with Exadata , Exadata is more powerful engineered machine designed for large work loads eg:  DSS (Decision support […]

Continue

DataGuard switchover in OCI/Oracle Cloud

Acronym –  DR – Disaster recovery   Organizations are investing colossal sum of money on DR (Disaster Recovery solutions) because it’s has direct impact on business continuity. Many companies implement the DR solution and not testing the DR functionality frequently. It’s business and IT infrastructure team’s responsibility to test DR functionality at least twice a year. […]

Continue

OCI – Data Safe – Part 1

Data is the new currency. It is one of the most valuable organizational assets, however, if that data is not well protected, it can quickly become a liability. At an alarming rate we are seeing more and more data breaches that impact an organization’s brand, their ability to continue to delivery services and do business […]

Continue

Oracle Audit Vault – 20.4 – Part 4 – Enable Auditing

  As security is a major concern is current data era , Many organization invest colossal sum of money to be on top the compliance scores. AVDF is a greater tool to provide out-of-the-box compliance reports. These reports can be schedulable, customized reporting for regulations such as GDPR, PCI, GLBA, HIPAA, IRS 1075, SOX, and […]

Continue

19c PDB remote clone and relocation using dbca

Database world consolidation and managing resources plays a key role. To ease the administration of databases  and efficiently use the hardware resources dbas use concept of database consolidation . To make this process easier oracle introduced cool feature of relocating pluggable database from one cdb to another.  12.2 database this is happening via db link […]

Continue

Oracle cloud Infrastructure (OCI) – Part 2 : OCI -VM Standby database creation

  Intro acronym –  DG –  dataguard OCI – Oracle Cloud Infrastructure   Most important part of the IT Infrastructure is to have a proper disaster recovery plan . Organization are spending colossal sum of money to have proper DR infrastructure. Best practice is to create your DR site on different city or different geographical location.  […]

Continue

Oracle Cloud Infrastructure (OCI) – Part 1 : RAC using OCI VM Servers

  Intro Most of the companies do not want to maintain data centers because it’s too costly for the organization. Cloud platforms like Oracle , Azure ,AWS and Google Cloud enables companies to host their server farms on cloud. This is major game changer of the current era, Cloud hosting enables many features to optimize […]

Continue

OEM 13c BI (Business Intelligence) reporting

  13c cloud control has enable reporting feature to represent data in graphical manner. We can use oem repo database to extract required information to perform proactive dba administration. Representing data using graphs , pie charts etc.. help dba’s to get the complete picture of the environment in short period of time. These health check […]

Continue

Oracle Wallet Manager – External Password Store

  Configuring catalog user to Use the External Password Store This era of security is a major concern , organization use various password management to meet the safety compliance requirements. Protecting database schema and password is very important for any organization. In this article I’m going to focus on securing the RMAN catalog user password […]

Continue