Oracle Database AutoUpgrade now for RAC!!
Oracle Database AutoUpgrade now for RAC!!

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

SQLcl, a nicer SQL*PLUS alternative
SQLcl, a nicer SQL*PLUS alternative

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

Initial Transparent Data Encryption (TDE) setup in 12c
Initial Transparent Data Encryption (TDE) setup in 12c

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

Recover a Table using RMAN Backup in 12c
Recover a Table using RMAN Backup in 12c

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

DBCA: Modify Templates and clone Database
DBCA: Modify Templates and clone Database

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

DBCA: Software + DB Creation
DBCA: Software + DB Creation

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