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 11.2.0.4 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 …
Category Archive: Oracle
Sep 18
Formatting SQL in Oracle
I was looking for a way to format the output from EXPAND_SQL_TEXT and came across this post. I would really rather have something in the database that I could do this with. I would prefer not to spool anything out, but it works very well. Just another SQL beautifier
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 …
Recent Comments