LMS0: terminating the instance due to error 481

15. December 2016 Uncategorized 0
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 ...

[Upgrade with DBUA + REMOTE_LISTENER with unresolvable SCAN => Fail] & [crsctl “-unsupported” supports you!]

I played with some troubleshooting tasks during database upgrade and stumbled upon some – how can I describe it? – a new findings for me. I have following environment: 2-node RAC environment with Grid Infrastructure version 12.1.0.2 1 RAC database still running on 11GR2 (11.2.0.3) Note: the parameter REMOTE_LISTENER is empty Scenario: That database should ...

ORA-01548 & drop Undo tablespace

06. October 2015 Uncategorized 0
Recently I was cloning one RAC database to single instance database, and afterwards I wanted to remove one of the Undo tablespaces. Unfortunately, it didn’t go so smoothly as I expected… SQL> drop tablespace UNDOTBS2 including contents and datafiles; * ERROR at line 1: ORA-01548: active rollback segment \'_SYSSMU39_1583257383$\' found, terminate dropping tablespace Hmmm, ok ...

Start OMS failed with “javax.xml.stream.XMLStreamException: Premature end of file encountered”

20. February 2015 Uncategorized 1
There was one tricky problem at the customers site yesterday – Enteprise Manager was “dead”. I tried to open Enterprise Manager login page, but nothing happened… not even the famous 500 Internal server error displayed! Strange… Ok, I logged into that server via ssh and checked log file. This is the output I found: <Feb ...