By the time you are reading this, I would expect you don’t need this, and that you are already using your "Always Free Autonomous Database and Cloud Infrastructure"… if that is not the case, don’t worry, is never too late to start!! Just in case, lets have a look what you got for free, for... » read more
I have to recognise I’m a bit of old fashion guy when it comes to get updates about new things, I still use RSS and even though twitter can replace it in some cases, I still like to do things at my own pace… What I didn’t expect to receive a notification from Mike Dietrich’s... » read more
As with anything remotely related to upgrade or patching, is always good to visit Mike Dietrich blog and make sure we have few concepts clear before we start. The first one I needed to clarify, is this "new term" (that shows you the lack of Upgrade I face daily…) called "Release Update" Of course I... » read more
SQL Plus is nice and very handy as well as very integrated with Oracle Databases now days. If you do Database management, is impossible to think about any other simpler way to connect to the Database and make some changes or check on the system. However, unless you add some external "plugins" like rlwrap (https://oracle-base.com/articles/linux/rlwrap))... » read more
Lets make some quick tutorial about how to set TDE in a Multitenant 12.1c system We are using today the system in 12.1 called cdb121 (I guess that a good clue about the system configuration already…) DB_NAME INSTANCE_NAME CDB HOST_NAME STARTUP DATABASE_ROLE OPEN_MODE STATUS --------- -------------------- --- ------------------------------ ---------------------------------------- ---------------- -------------------- ------------ CDB121 cdb1211 YES... » read more
One of the great progress Oracle database made with 12C was the posibility of Recover a table using RMAN without the need of any knowledge of Point-In-Time Recovery and how it is really done. 12C really simplifies everything in a really nice way that allows you a quick recovery as long as you have backup... » read more
We finally started creating some Databases once we made sure Marvin stopped whining about why the automatic doors of the spaceship had to be so cheerful. You can read more about creating DBs on DBCA: Software + DB Creation, about Marvin and the automatic doors.. lets just leave there for now.. Sometimes however, what you... » read more
Hi Arthur, welcome to the guide "DBCA: Software + DB Creation" With this guide, you will be able to teach Marvin how to get Oracle Databases on your RAC cluster We are assuming you already have your Software downloaded and ready in node1 of your cluster. If that is not the case, please go to... » read more
Hi Arthur, before you start your journey, is important to have a good test environment where we can try any endeavour we please. As important as having an stable Test system is the possibility to recreate it on few simple steps. This chapter of our guide will show you how to make Marvin create a... » read more