RandyDBA | Database - Tips & Techniques

Oracle has developed an extensive certification program which includes six certification levels that span nine different categories with more than 200 individual credentials. Oracle certification exams are divided into two:- proctored and non-proctored. However, most of Oracle certification exams are proctored, cost $245, and contain a mix of scored and unscored multiple-choice questions. Candidates may take proctored exams at Pearson VUE , although some exams are offered at Oracle Testing Centers in certain locations. Non-proctored exams cost $125. Some exams such as Oracle Database 12c: SQL Fundamentals (1Z0-061) and Oracle Database 11g: SQL Fundamentals (1Z0-051), are also available non-proctored and may be taken online. Check the Oracle University Certification website  for details on specific exams. Oracle's six certification levels include:- Junior Associate Associate Professional Master Expert Specialist The certification program for Oracle is divided int...

This blog post describes the installation of Oracle Database 18c 64-bit on Oracle Linux 7 (OL7). An example of the Linux installation can be seen  HERE We will begin by downloading and installing the software required before we can create an Oracle database. This process involves several steps. Before we begin with the installation we need to verify and configure the required OS components: Memory and swap space System architecture(processor) Free disk space ( Oracle now takes almost 15GB of space to install) Operating system version and kernel Operating system software (required packages and patches) -- Check Physical RAM. # grep MemTotal /proc/meminfo    { We need at least 3192 MB of physical RAM. } -- Check Swap Space. # grep SwapTotal /proc/meminfo/* RAM up to 1024MB then swap = 2 times the size of RAM RAM between 2049MB and 8192MB then swap = equal to the size of RAM -- Check space available in /tmp # df -h /tmp/* We need to have at least ...

If you have been paying attention to Oracle database releases in the past few years, you will recognize the release numbering has changed. In the past, Oracle had release one and two but now they have changed to yearly release numbers and full releases each year. These changes started in 2018 that's why we have release 18c,  19c coming out this year and then next year will be release 20 afterwards 21 and so on. The good news here for us DBAs is that the is No "FIRST" and "SECOND" releases anymore! since it is a yearly and full release there is no patchset anymore to apply, which will definitely save us the headache about which release to go live on (first or second). Release Families The 18c and 19c releases are part of the Database 12.2 "Family" for Lifetime Support as if they were the 12.2.0.2 and 12.2.0.3 patch sets. Patching end date for Oracle Database 12.2.0.1 will be determined once Oracle 18c is available on premises. Sup...