- Powered by
- WordPress
-
crsctl status resource – state details are really useful
A very short post about a cool new feature I noticed today. RAC 11.2 has moved a lot of commands previously having their own syntax into crsctl. One of the cool new things is the fact that crsctl status resource -t (“tabular”) reports state details. Here I could see that my lab environment had a…
-
Display scheduler class for a process in linux
The ps command in the ways I use it most (ps -ef and ps auxwww) doesn’t display the scheduling class for a process. Oracle have cunningly released a patchset to update Grid Infrastructure that changes the scheduling class from the VKTM and LMSn ASM processes to “Timeshare” instead of Realtime. So far so good, but…
-
orapki 11.2 bug when password complexity is too low
I am currently experimenting with SSL encryption for ONS, an 11.2 new feature. My system is OEL 5.5 64bit with PSU 11.2.0.1.1 installed on the stack. Apart from the poor documentation, the orapki tool that can be used to create self-signed certificates for testing has a bug in 11.2. There is also a documentation bug…
-
Incrementally gathering statistics in 10g
One of the cool new features of the Oracle 11g database is that you can copy statistics and incrementally gather global stats for rlt (really large tables). I wanted to do some testing around these features in 10.2.0.4 but ran into a number of problems. So this is the story…. I have decided to split…
-
RAC SIG June 2010
Good morning all! Just wanted to put up a quick note about the upcoming UKOUG RAC SIG in June. This is going to be a really good event showing some of the most prominent members of the Oracle community: Harald Van Breederode Joel Goodman Julian Dyke From an infrastructure point of view Simon Haslam is…
-
The difference between a direct grant and a role in PL/SQL
This is a quick post about beginning Oracle PL/SQL development. Long story short, there is a difference between invoker rights and definer rights in the way they respect role grants: definer rights PL/SQL blocks are the default, and none of the role grants you have are available code blocks defined with invoker rights however do…
-
Moving OCR and voting disks to block devices in CRS 10.2
Anyone to suggest a shorter title for this: you are welcome to comment! Initially I wanted to have this in the first of today’s posts, but got side tracked. So here’s the next step in the CRS 10.2.0.5 installation: moving off the deprecated raw devices to block devices. This is something you can do with…
-
Thousands of core dumps in $OMS_HOME
I have been asked to debug a problem with another office’s Grid Control 10.2.0.5 setup. In a nutshell users complained they could not log in, and those who were previously connected were kicked out. Hmm, so much for a briefing. When troubleshooting Grid Control it is important to remember that Oracle’s monitoring product is made…
