Create Oracle Database 18c on Windows – Advanced Configuration for the pros

If you are setting up a production system or similar, you will need to go through the advanced configuration. The best option is to choose "Set Up Software Only" in Oracle Universal Installer (OUI) to complete the Oracle software installation, then use Database Configuration Assistant (DBCA) to create a new database. OUI and DBCA have the advanced configuration. The OUI advanced configuration is not "advanced" enough, DBCA lets you customize the database configuration options - (more...)

Create Oracle Database 18c in 3 clicks!

After the Oracle Database 18c software install, the database creation is only 3 clicks using the Database Configuration Assistant! The Oracle defaults are OK!

Oracle18c Database on your Windows laptop in 6 clicks!

Oracle Database 18c (18.3) is available for download for windows platform since August 22, 2018. If you are new to Oracle or if you are a developer and need a database to play with, you can install an Oracle database quickly on your laptop with a few clicks.

Oracle Tidbits – August 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on  Facebook, Twitter, and Google+ during weekdays in August 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit When the value of UNIFORM_LOG_TIMESTAMP_FORMAT init parameter is FALSE, trace files include a mix of timestamps using different precisions, with some timestamps showing local time and other …

Oracle Tidbits – July 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on  Facebook, Twitter, and Google+ during weekdays in July 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c To change a regular user (password authenticated) to schema only account, the user should not have any administrative privileges (SYSDBA, SYSRAC, etc.). Query administrative privileges in …

Oracle Tidbits – June 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on  Facebook, Twitter, and Google+ during weekdays in June 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c A shared single client access name (Shared SCAN) enables the sharing of one set of SCAN virtual IPs (VIPs) and Listeners on one dedicated cluster in …

Oracle Tidbits – May 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in May 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c When cloning a non-CDB as a PDB or relocating a PDB, use the DBMS_PDB.EXPORTRMANBACKUP procedure to export RMAN backup metadata into the PDB dictionary, enabling backups …

Oracle Tidbits – April 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in April 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c #Dataguard Broker 18c VALIDATE DATABASE SPFILE performs a comparison of server parameter file (SPFILE) entries between the primary database and a specified …

Oracle Tidbits – March 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in March 2018. You will also see these tidbits on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c SQL*Plus Feature: The SET LINESIZE command has …