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