Oracle Cloud: How to create a database link?

25. November 2020 Uncategorized 1
On my journey to the Oracle Cloud, I got another task to complete – to create a database link between two databases running on the Oracle Cloud. I will cover the use case of creating a database link between databases in a separate regions (Switzerland > Frankfurt). Database link between databases in a separate region ...

Oracle Cloud: Some issues with the old IMP & EXP utilities

14. November 2020 Uncategorized 0
As I am still helping one customer to explore the Oracle Cloud, I am learning myself something new every time and I am also facing some issues on that way. The last one is related to the old IMP and EXP tools. One of the automated steps is to export some tables from one database ...

Oracle Cloud: ORA-00018 maximum number of sessions exceeded -> Use DRCP

08. November 2020 Uncategorized 2
One of my customers want to try out the Oracle Cloud, and they started with a small database using the “Always Free” option. So far, so good, except one issue – from time to time, they are getting the error message “ORA-00018: maximum number of sessions exceeded“. Every Oracle DBA would first check the database ...

Database Upgrade using autoupgrade tool

This time I had to upgrade a SE2 12.2 database running on Windows on Azure Cloud to the version 19.3. I do not have such setup in my lab, so I was a little bit sceptical about it, and it will turn out – with a reason. So, I read a ton of a articles ...

LMS0: terminating the instance due to error 481

15. December 2016 Uncategorized 1
One production RAC database has been upgraded to 12c and everything went fine for a couple of months, but suddenly after some time, one instance got terminated with the error messages: LMS2 (ospid: 17238): terminating the instance due to error 481 ORA-00481: LMON process terminated with error   The analysis was not so easy. We ...

Upgrade to 12c: ORA-38753: Cannot flashback if there is tablespace with FLASHBACK=NO !

Yesterday at customers site I had to upgrade one 11g database to 12c and stumbled upon a tricky issue. As I already upgraded a many dozens of databases, I think (or I thought at least), that I am pretty familiar with the whole process: planning, preparation, check list, pre-upgrade tasks and so on… But, yesterday ...

“Slow” system & ORA-00445: background process “DIAG” did not start after 120 seconds ?

Since I am currently checking all Oracle systems at the customers site, I thought at first sight, that almost all of them are overutilized or wrong configured, because everything seemed so sloooooow… Especially the new logins and creating of the new processes were a way too slow – more than 5 seconds! Sometimes I waited ...

RMAN Duplicate for standby command gets hung while restoring the control file or spfile? Set DISABLE_OOB=on

Today I stumbled upon some mysterious issue whilst trying to duplicate one database. I used the same process and same commands, which are worked fine on other systems. But, today the duplicate command gets hung while restoring spfile on one auxiliary instance. I killed the RMAN session and started it all over again, but without ...

ORA-07445 [mdcgcvxhl()+4677] using Spatial SDO_GEOM.sdo_convexhull = Bug 22886582

After upgrade of one database to 12c, the customer complained, that one application (which uses Spatial & Graph) isn’t working  properly. After analysing & tracing it, I found the root cause of it – SDO_GEOM.sdo_convexhull. In some cases, this function crashes the whole application raising ORA-03113: ORA-03113: end-of-file on communication channel Process ID: 22675 Session ...