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