Category Archive: RAC

Aug 07

RMAN-20036: invalid record order

Trying to register a database with my rman catalog I was getting the following error $ rman target sys/xxx@DB01 catalog=RMAN_DB01/xxx@rmancat Recovery Manager: Release – Production on Mon Aug 7 11:42:37 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: DB01 (DBID=114156133) connected to recovery catalog database RMAN> …

Continue reading »

Jan 06

ohasd permissions

I was working kind of late last night, trying to get a new install working. I ran into a bug where the permissions on the ohasd were incorrect after patching GI. I went out to a working server to see what the permissions should be, build my chown and chmod statements and pasted them into my …

Continue reading »

Nov 17

Where Are My Nodes?

I should mention the current setup is a 4 node RAC database with a dataguard managed standby comprised of a 3 node RAC database cluster. The current database version is While writing a shell script today, I needed to know from connecting to a database in a cluster what all the related nodes were. This …

Continue reading »

Jun 11

ORA-00904: “UTL_RAW”.”CAST_FROM_NUMBER”: invalid identifier

I have been migrating single instance databases to RAC databases and had several databases that filled up the diag directory spewing out alerts. There is a bug that can cause some of these, but in my case it was much simpler. Simple configuration mistakes The first error was due to the existance of a spfile …

Continue reading »