Datascape Podcast Episode 39 – February 2020 Cloud updates

In this episode, Warner Chaves, Stephane Frechette, Pierig LeSaux and I distill the most interesting, recent updates from Google, Amazon and Microsoft.

Read More >

Use RMAN KEEP Backup To Roll Back From an Upgrade

There is a requirement to back up a database before an application upgrade to be able to rollback. Guarantee Restore Point (GRP) was first considered by us; however, it looks like there is insufficient space from Flash Recovery Area (FRA)….

Read More >

PART 4: Implementing Oracle Database Single Sign-on Using Kerberos, Active Directory, and Oracle CMU

This is the fourth and final article in a four-part series related to testing Oracle Database 18c Centrally Managed Users (CMU) by leveraging the Oracle Cloud Infrastructure (OCI) for Oracle DBAs to create a lab or testbed. The third article…

Read More >

Improve your security posture by upgrading to Azure SQL Database

Every now and then I have a conversation with a client who is still reluctant to consider a cloud migration due to what they perceive as a decrease in their security posture. Once we start analyzing this position in detail…

Read More >

PART 3: Implementing Oracle Database Active Directory Password Synchronization using Oracle CMU

This is the third in a four-part article series related to testing Oracle Database 18c Centrally Managed Users (CMU) by leveraging the Oracle Cloud Infrastructure (OCI) for Oracle DBAs to create a lab or testbed. The second article covered Configuring…

Read More >

Let DataGuard Broker Do ALL The Work

What’s the reason for implementing DataGuard Broker? It does all the work. eg. Test system has been shutdown and upon startup, encountered error as shown. Shutdown database and startup mount. Check DataGuard status using dgmgrl. Note: standby recovery was automatically…

Read More >

How to Run DBSAT 2.2.0 on Oracle Cloud PDB using Wallet

The Oracle Database Security Assessment Tool (DBSAT) is a command-line tool focused on identifying how securely the database is configured and where sensitive data resides with the goal of promoting successful approaches to mitigating potential security risks. DBSAT requires no…

Read More >

Automatic Graceful Shutdown and Consistent Startup Method for Oracle DB on Linux

Having questions about automatic startup and shutdown is quite common when dealing with new environments or configurations. There is more than one way to implement this depending on the environment configuration, licensing and version. So, here is a summary: 1….

Read More >

Tracking data flow mechanics of IoT, or a piece of “Pi-oT”

A piece of pi(e): “In contrast to a piece of cake, means a task that looks easy but once you get into it is actually very difficult or time-consuming.”  – Urban dictionary In the early days of my career, I…

Read More >

How to Stop All Database Instances Running From ORACLE_HOME

At times, there may be a requirement to stop database instances, for example, to perform patching. When there is only one database instance running on the server, it is sufficient to stop the instance using srvctl stop instance -d db_unique_name…

Read More >
Page 1 of 35512345...10...Last Page »