I recently came across this blog post about changing the SYS password in RAC databases: http://marioalcaide.wordpress.com/2011/05/24/changing-sys-password-in-rac-databases/ The author of this blog post makes the claim that the “SYS password is instance specific in RAC databases”. This claim is incorrect. I posted a comment to prove this falseness of this statement and offered the real culprit …
Category: Oracle
Dec 19
Extend EM Grid Control to New Nodes
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. …
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 …
Oracle DBA Mentor
Oracle RAC Performance Tuning
Latest Tweets
-
@sacrophyte That was an old recommendation which is probably out of date now. When I look at the 19c doc for that p… https://t.co/h0VwGJECvH
-
Also in that note is "We decided to not promote our Database 20c Preview version to General Availability. Instead,… https://t.co/bvUcRKQ9gt
