Category Archive: Databases

Mar 08

HOTSOS In Texas!

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 …

Continue reading »

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 …

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

Continue reading »

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 …

Continue reading »

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 …

Continue reading »

» Newer posts