I am currently in Texas at the HOTSOS Symposium. I look forward to this conference every year. There are some brilliant people here, and it is a great place to learn new things. Kerry Osborn did a great live presentation yesterday, can’t wait to get home and try some of this stuff out. Also saw …
Category Archive: Databases
Feb 08
DBSNMP By Way Of EMCLI
Currently I am changing passwords in several hundred databases, not that uncommon of a task for any DBA. Unfortunately it is time to rotate the dbsnmp password. Usually I would log into OEM after changing the password and manually update the password in the monitoring configuration for each and every database. This is fine if …
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 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 …
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 …
Mar 03
HOTSOS 2015
I am currently at the HOTSOS Symposium. This is my favorite conference of the year. The people here are incredibly smart, the presentations are very technical, and it is just a good time. I look forward to this conference all year. I have learned some great new things that I am looking forward to trying …
Recent Comments