Brian Peasland
Author's posts
Feb 12
Testbeds
I have often mentioned in my posts that testing/testing/testing is required for specific tasks. Testing lets you accomplish two tasks: 1) make sure your change works as intended and 2) make sure your change does not cause unforseen problems. Today, when reading some of the many blogs I visit, I came across this article from …
Jan 31
EM 12c Adjusting Threshold Values
On a test system, I’ve been getting frequent alerts from Enteprise Manager 12c Cloud Control that my host is running low on swap space. Since this is a test system, and since I know my swap space is just fine, I decided to increase the Warning threshold from 80 to 87%. In doing so, I …
Jan 24
Tasklist
I’m sure that someone reading this will ask, “how did you not know that?”. But sometimes the simplest things come to us late in the game while others knew it early on. I’ve been patching Oracle on Windows since the Windows NT days. Everyone who patches Oracle on Windows knows that OPatch will often balk …
Jan 22
Trailing Zero
I had a developer ask me an interesting question recently. He was working on a problem where numeric values were stored in a table but when he queried that table in PL/SQL Developer, it would show trailing zeroes after the last digit. He wondered if this was contributing to the problem he was trying to …
Jan 10
Changing SYS password in RAC
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 …
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 …
Oct 24
Agent Crashes
I have a problem that occurred recently where my Grid Control 11g agents keep crashing on a daily basis. To find out why the agent is crashing, I went to the database server and looked in $AGENT_HOME/hostname/sysman/log in the emagent.log file. At the time of the agent crash, I found this error in the log …
Oct 18
Security Patch Monkey Business
A few days ago, Oracle released their quarterly patches for currently supported Oracle versions. Now in the past, the DBA had the option of installing the Cumulative Patch Update (CPU) or the Patch Set Update (PSU). Basically, the CPU contains just security patches and the PSU contains security patches and other bug fixes. Beginning in …
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
