If you’ve followed some of my recent posts, you know that I have been working on extending my existing RAC database cluster to new hardware. I now have my instances running on the new nodes. My applications are now connecting to the new instances. It’s now time to work on some of the behind-the-scenes items. …
Category: Oracle
Dec 18
Manually Add New RAC Instance
To start this post, I will say that if at all possible, you should use the DBCA to add a new instance to your RAC database. The DBCA will take care of all of the details for you. It’s a simple 6-page wizard and your new instance is up and running on your new node. …
Dec 03
ORA-01264 in Physical Standby
I am in the process of replacing hardware for an existing 3-node RAC cluster. This system is also a primary to a 2-node RAC standby database. To replace the hardware, my plan is to temporarily extend the cluster into a 6-node configuration, 3 old servers and 3 new servers. Once I have the instances running …
Aug 30
DB Control Nearing Its Death
On August 20th, Oracle published Note 1484775.1 Database Control To Be Desupported in DB Releases after 11.2. If you use Enterprise Manager to manage and monitor your Oracle databases, you have two options, DB Control and Grid/Cloud Control. DB Control is easy to set up but only interacts with one Oracle database. If you have …
Aug 22
Fun With Messages
Recently, I saw someone indicate that they had an Oracle tech on site some years ago. This tech had changed SQL*Plus so that its feedback said something like “about XX rows selected” instead of just “XX rows selected”. He wondered how the tech did that. I just had to dig into this and have some …
Aug 21
Relink Grid Infrastructure
I recently had to work with my SysAdmin on a minor OS upgrade on a two-node RAC cluster. I am running Oracle Grid Infrastructure 11.2.0.2 with Oracle RDBMS 11.2.0.2 and we were upgrading from Oracle Enterprise Linux 5.2 to 5.8. As most Oracle DBA’s know, it is a good idea to recompile the Oracle software …
Aug 16
SQL Developer Won’t Start
One of the things I like most about SQL Developer is that it runs everywhere. I have it installed on my Windows workstation. It is installed automatically on your database server, even Unix/Linux. And I have it installed on my MacBook Pro. The same product runs everywhere giving me a consistent tool no matter which …
Aug 14
Reconstruct Standby DB
After a recent power outage at our DR site, I discovered that a standby there had stopped applying logs. Apparently in the archived redo logs was a transaction which grew a datafile but the disk at the standby site did not have enough disk space to allow that transaction to complete. So the standby terminated …
Aug 03
User-defined Routine with DBMS_STATS, Part II
I had a previous post about user defined routines with DBMS_STATS. After some more digging, I determined how this works. I have some data in my database that is stored in a User Defined Type. If you have a user-defined type, you can associate your user-defined stats collection routine with the Oracle Data Cartridge Interface …
Jul 09
My 11g Optimizer Stats Job Quit On Me – Fixed
It turns out, the root cause of the problem in my previous post was at bad Thursday evening window in the scheduler. Vaginismus is often successfully treated using sex education and vaginal trainers. http://djpaulkom.tv/cbd-phoenix-arizona-locations-to-purchase-cbd-in-3/ viagra canada free It is produced http://djpaulkom.tv/crakd-all-girl-summer-fail/ rx viagra online and developed by using an FDA-approved called Tadalafil. These physiological factors …