Oracle Database as our consultants live it every day: installation and patching, upgrades, RMAN backup and recovery, Data Guard, RAC, performance tuning, multitenant, licensing, and engineered systems such as ODA and Exadata.
By Mouhamadou Diaw In an oracle environment with Transparent Data Encryption (TDE) the transfer of PDB may require additional steps. In this blog we will see some steps which may be required when doing Unplug and Plug of pluggable database We plan to unplug the pluggable database PDB1 from PROD01 and plug it into CLNE02. Both container have TDE configured…
Quering database’s by using SQL in shell scripts can make the whole script unreadable. Very oftent the query is unredable too, due to the variable usage. This situation make the script debugging a pain.
Templating simplify the script by taking out from the soufce code file the SQL code. J2 is ideally built for that.
As you might know Dbvisit StandbyMP is a great Disaster Recovery solution for Oracle SE databases. Dbvisit recently communicated, providing now, a Test Drive system for customer to easily try the product and for partner to easily have a Demo environment. In less than 2 minutes, an environment with a Control Center host and multiple database server hosts with either…
By Mouhamadou Diaw In the first part of this blog, we activate TDE in the database, in this part we will see how we can encrypt data. I am using Oracle 19c for the tests As specified before TDE will allow encryption at 2 levels -Tablespace level -Table column level TDE will encrypt your data in rest at filesystem level.…
By Mouhamadou Diaw Oracle gives us some tools to secure our data in transit and in rest. Oracle Transparent Data Encryption will allow us to encrypt data in rest. Oracle TDE need The Oracle Advanced Security License Oracle TDE allow to do encryption at 2 levels -Tablespace Level -Table column level In this first part of this blog, we will…
As you might know, Oracle doesn’t offer any disaster recovery solution for their Oracle Standard Edition databases. Oracle Data Guard ensures high availability, data protection and disaster recovery for Oracle Enterprise Edition database only. Dbvisit is a great disaster recovery solution for Oracle Standard Edition database, and you might be aware that you can now, as well, create snapshot databases…
By Mouhamadou Diaw RU, MRP should be applied to database home as soon as possible. Usually we often nstall the base version and after install the RU on top on the base version For example we want to have the version21.8 We usually -Install the LINUX.X64_213000_db_home.zip- – And then apply the RU 21.8 34527084 But another method is to apply…
By Mouhamadou Diaw In a previous blog, I talked about the new feature in Oracle 21c, which allows an old and new password to be valid during a period of time. This feature, Gradual Database Password Rollover, is possible using new parameter PASSWORD_ROLLOVER_TIME. The question that comes may be: Can the DBA track if old passwords are still being used?…
I recently wrote an article about how to combine Oracle SEHA database running on ODA 2-HA and dbvisit StandbyMP solution. See my article here : https://www.dbi-services.com/blog/combine-oracle-seha-on-oda-with-dbvisit-standbymp/. But are really all those high availability and disaster recovering solutions working together? Do Oracle SEHA relocate and failover functionalities work in conjunction with dbvisit StandbyMP switchover? Let’s see and try it! Test environment…
By Mouhamadou Diaw Dealing these last days to database migration with a customer, I write this blog to describe the main tasks The context is to migrate databases to a new infrastructure. Below the configuration Source : Linux Suse in a non-multitenant architecture Target : Oracle Enterprise Linux 8 with multitenant The database version is Oracle 19c Installing Oracle Binaries…
Oracle offers a number of methods to migrate Oracle databases to the Oracle Cloud Infrastructure (OCI). From Data Pump through RMAN, Data Guard and even Golden Gate there should be a solution for just about everyone. However, most of these managed migration services require that the source system is running Linux. So what do you do when you’re running Windows?…
