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 ...

DataPatch: patch 23177536: The database must be in upgrade mode <- are you serious!?

29. September 2016 Uncategorized 2
Today I applied the latest patchset 12.1.0.2.160719  (July 2016) and afterwards I executed datapatch tool, but got a really stupid error: [oracle/ACME1@acme01 OPatch]$ sqlplus / as sysdba SQL> select  PATCH_ID, PATCH_UID, VERSION, STATUS, DESCRIPTION      from DBA_REGISTRY_SQLPATCH      order by BUNDLE_SERIES;       no rows selected [oracle/ACME1@acme01 OPatch]$ ./datapatch -verbose SQL Patching tool version 12.1.0.2.0 ...

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 ...

Unified Auditing: some gotchas to be aware of!

Database should be offline when you are enabling pure Unified Auditing or you will get this error: ORA-00600: internal error code, arguments: [krsh_fsga_sgaq.ds_not_found], [], [], [], [], [], [], [], [], [], [], [] By default, in 12c version the auditing runs in mixed-mode, which means you can combine traditional auditing with unified auditing. There ...

“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 ...

Short list of some bugs to be aware of before upgrading to 12c

03. December 2015 Uncategorized 1
In the last couple of months I was doing a lot of upgrades to the version 12c. I followed the guidelines and the documentation I found on the Oracle homepage, MOS & many blogs, but unfortunately, not every upgrade went smoothly. As always, every new database version brings a couple of new bugs and it ...

Color your SQL*Plus scripts!

06. October 2015 Uncategorized 0
You’re in a hurry and want to quick identify some hot spot in the output you got from your SQL*Plus script? Color your SQL*Plus scripts! Here is one dummy example of it: create or replace package colors is function color(p_text in varchar2, p_fg_color in varchar2 default \'m\', p_bg_color in varchar2 default \'40m\') return varchar2; procedure ...