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 Challenge #3 – Solution

This is the solution for Oracle Challenge #3. If you haven’t read the challenge, go and check it before you read the solution here. So, the challenge was to write different SQL statements to return the list of employees that earn the most in their department. As I said, there are 2 assumptions here, we … Continue reading Oracle Challenge #3 – Solution

Oracle Database 18c “Hands-Off” Data Guard Build Using VirtualBox and Vagrant

I wanted to try something with Oracle 18c Data Guard, so I thought I might as well create a hands-off build of it using VirtualBox and Vagrant, much as I did with my recent hands-off RAC build.

I did the 18c build and figured I might as well do 12cR2 and 12cR1 builds too, as they were pretty similar. I could have done them as a single build with a few tweaks to sort out (more...)

MySQL 8: New Features

After installing mysql 8 on my ubuntu i did a lookaround for the new features. Oracle itself stated:

This is really cool, but how to test this?
A first look inside the standard data directory /var/lib/mysql shows:
/var/lib/mysql# ls -l
insgesamt 168012
-rw-r----- 1 mysql mysql       56 Aug 17 20:53 auto.cnf
-rw-r----- 1 mysql mysql      498 Aug 17 20:53 binlog.000001
-rw-r----- 1 mysql mysql      554 Aug 17 21:07 binlog.000002
-rw-r----- 1 (more...)

mysql 8: installation on ubuntu

Today i tried to install mysql 8 on my ubuntu:
First i visited the site https://dev.mysql.com/downloads/repo/apt/ which says:
So i downloaded this file (https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb) and here we go:

# dpkg -i mysql-apt-config_0.8.10-1_all.deb 

Vormals nicht ausgewähltes Paket mysql-apt-config wird gewählt.

(Lese Datenbank ... 414911 Dateien und Verzeichnisse sind derzeit installiert.)

Vorbereitung zum Entpacken von mysql-apt-config_0.8.10-1_all.deb ...

Entpacken von mysql-apt-config (0.8.10-1) ...

(more...)

ORA-31626, (Database-pump)-job does not exist

A short post about the ORA-31626 error. Found out a scheduled export- and import- job was broken in an Oracle Database. Error:  ORA-31626: job does not exist. After checking the scheduled jobs I realized that it’s not the scheduled job, but the datapump-job (should have read the error more carefully – it states ‘database pump job does not exists…. ).

And it seems all related to being cost-effective in the cloud….

The full error:

Error at (more...)

Hot Backup with RMAN in Oracle

We are going to have look on the backup of Oracle, Which is common in DBA’s life. HOT Backup is the most common way to have a backup.

Let’s have look on the steps of Oracle’s HOT Backup.
Check the archive status

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     7
Next log sequence to archive   9
Current log sequence           9

Create a test table

 (more...)

June 23 2019, date of the SCN-bug

The what? I read about the SCN bug a few years ago (a wildly increasing value of the SCN till a certain limit has been reached ) , and took this for granted – most of it. Until recently a customer asked for help with a 9.2 database which had to last for another year. And another customer is in a large project of upgrading a 10.2 database to a 12 version, and (more...)

Using DBCA in Silent Mode

One of my customers is a software company and they use Oracle database for their product. One of the things we need to do when they certify an Oracle version is to create silent installation scripts. These scripts are for Windows and used for demo and testing environments. I did that for 11.2 and for … Continue reading Using DBCA in Silent Mode

Getting started with Enterprise Modules’ ora_profile to install Oracle 18c

A couple of moths ago, Enterprise Modules announced the easy to start way of making use their Oracle modules, ora_profile. Recently their modules have been updated to support the on-premise release of Oracle 18c (18.3). In this post I’ll explain how to get started using Vagrant, VirtualBox and a little bit of Git.18c_klaar

Preparation

To get started you should make sure both Vagrant an VirtualBox are available. On Windows hosts I discovered that having (more...)

Bug When Patching Production

I had a bad night last Thursday. After patching two test RAC databases and one production RAC with PSU 180417 Bundle Patch (and some one-offs), I got to the point where it was time to update the most critical RAC system. We were really looking forward to this as we had hit a few bugs … Continue reading Bug When Patching Production

Where to find the oracle-database-ee-18c-1.0-1.x86_64.rpm package?

After writing about the release of Oracle database 18c i wanted to download
oracle-database-ee-18c-1.0-1.x86_64.rpm
to try the rpm-based installation.
But this rpm is not included in
LINUX.X64_180000_db_home.zip
The oracle documentation shows:
 But on OTN and Delivery Cloud only the zipfile without the rpm can be downloaded...

So let's see, when the download pages are updated...

Oracle 18c database is released for Linux (on premise)

After my posting nearly a week ago about the published 18c documentation on monday the binaries for Oracle 18c database were released:


and

 Here the link to the download page: oracle.com

In one of the next postings i will try a rpm installation...

Session using a database link hangs on “SQL*Net more data from dblink”

I have a client who recently move a database server from on-premise to a Cloud provider.  A database on this database server had a database link to their E-business database in the Oracle Cloud.  Since the move, any sessions in the database that use the database link to the E-business database would hang if the query was to return large dataset.

Below is selecting from dual over the database link that worked:

SQL>  (more...)

Index Monitoring in Oracle Database

Applies to ONLY Oracle Database 10gR1 through to 12cR1.
In Oracle Database 12cR2, this feature is replaced.  A new blog post of this feature will be posted in due course.

Since Oracle 10g, you can monitor indexes to see if they are being used or not.  Which is very useful as indexes, consume unnecessary CPU and I/O on DML activity if not used.  Therefore, it’s recommended to monitor indexes and any unused (more...)

“Regulatorics: Offside is when the referee whistles” – I’m a speaker at #DOAG2018

Today my presentation is confirmed: “Regulatorics: Offside is when the referee whistles”. Maybe the German title will be  better understood: “Regulatorik: Abseits ist, wenn der Schiedsrichter pfeift”

The regulatory system has more and more influence on our software development.

Regulatory authorities, exteranl and internal Auditors are increasingly examining our IT and not longer only our business processes and balance sheets.
Some of them have better trained IT experts as we can find on the free market.

General standards such (more...)

Oracle Database 18c: Documentation released!

Today i surfed to docs.oracle.com and there i found the documentation for oracle database 18c:


In march 2018 i wrote about the new installation procedure of oracle database 18c via rpm, which was announced inside the "new features".

The installation guide for Linux contains now the commands for installing the database via rpm. Here a screencopy of chapter 11:
 rpm -ivh oracle-ee-db-18.1.0.0.0-1.x86_64.rpm
This command creates the (more...)

One-off Patch Frustration

Lately I started patching a client’s database (12.1.0.2) to the latest PSU (180417). This is a RAC environment with streams and all kind of other features, so over the time we hit quite a lot of different bugs. When we planned this PSU (we installed the bundle patch version), we added about 7 one-off patches … Continue reading One-off Patch Frustration