Category: DBA

With the launch of DB 12c in 2013, Oracle introduced a new architectural concept, called “multitenant databases”, where you have one super database (=container; CDB) and one or more sub databases (= pluggable DBs; PDB). Before running the installer on an Oracle Linux 6 environment, a library can be installed through yum to meet all […]

In this post I will put 5 other new 12c features in the spotlight (in addition to the features of a previous post), that really makes the 12c an improvement against the previous versions of the Oracle database. To get this result I listed up all the major new features and wanted to know my […]

There’s a new Oracle source available:  All Things Oracle. The aim of All Things Oracle is to provide a gateway to the wealth of information and material available for Oracle developers and DBAs. The site brings articles and other resources of Oracle experts. Just to name a few: Alex Nuijten -Database Development – Oracle Ace […]

What should you do if you have an anydata column in a queue table and you don’t have any tool to read from it(sqldeveloper doesn’t support it natively)? I have written some code to extract all the information from such a column and print it, whatever the content would be. You can find out more

For a client of us we had to call a webservice from a database, and the received information that we received from this call was needed in another procedure. It was the first time for me that I had to do this and I believe that not so many people now of this functionality in […]

This morning I opened Enterprise Manager and instead of the regular “login”-screen, I found following screen:   Everything is up and running but Enterprise Manager is not able to connect to the database instance. Sounds like a connection problem, not? These are the steps I followed to solve this issue and to reset the “sysman”-account: […]