Howard Rogers has a series of blog entries about Oracle11g initialization parameters. I recommend it. Here is a link:
Archive for the 'Oracle Database 11g' Category
Oracle Database 11g Initialization Parameters. A Digest.
Published August 27, 2007 Oracle 11g , Oracle Database 11g , Oracle11g initialization parameters Leave a CommentImproved Linux Real Application Clusters Clusterware Installation with Oracle Database 11g
Published July 16, 2007 Oracle 11g Real Application Clusters , Oracle Database 11g , Oracle11g , Oracle11g RAC 7 CommentsJust a quick blog entry. I have installed 11g RAC quite a few times already and just wanted to share with you folks an observation.
Those of you who have installed 10gR2 Clusterware (CRS) know that towards the end of the CRS installation you have to go from node to node and execute $ORA_CRS_HOME/root.sh. When you run it on the last node the script will try to set up VIPs (this is why you have to run the CRS root.sh as root in an xterm because it is a window-less JAVA app). Oracle1gR2 has had an annoying bug in it that failed the VIP setup because it was very picky about the IP addresses you assigned to VIPs. The workaround for that was to ignore the problem and then invoke $ORA_CRS_HOME/bin/vipca and walk through the setup of VIPs (including GSD and so on). It was a minor problem that was easy to work around.
10g and 11g Clusterware Co-Existence
I have not seen that problem with 11g. In fact, the reason I’m blogging this is because I just walked through an install of 10gR2 Clusterware on my cluster running x86 RHEL4 attached to NAS (NFS). I need a setup where I have both 10g and 11g clusterware installed and I need to be able to “hide” and “expose” either with a few simple commands to test one or the other. After the successful install of 10gR2 CRS, I “hid it” (to include all the residue in /etc) and proceeded to install 11g CRS. Since I just did both 10gR2 CRS and 11g CRS installs back to back I was reminded that 10gR2 CRS has that pesky problem and I did have to hand-invoke vipca to get through it. I was pleasantly reminded, however, that 11g does not have that problem.
For those of you who are used to seeing the complaint about VIPs at the conclusion of the last root.sh execution, see the following screen shot from 11g and breathe a sigh of relief.
And a picture speaks a thousand words so here is a shot of my little 11g NAS RAC clusterware setup:
Note to self: Investigate whether 11g CRS works with 10gR2 RAC instances and make a blog entry. It should, so I will.
Oracle11g: Where’s My Alert Log?
Published July 12, 2007 Oracle 11g , Oracle Database 11g , Oracle11g 9 CommentsJust a short blog entry about Oracle 11g. One of the first things that caught me by surprise with 11g, when I first started in the beta program, was that the default location for the alert log has moved. It is still placed under the traditional OFA structure, but not /u01/app/oracle/admin. There is a new directory called diag that resides in /u01/app/oracle as seen on one of my systems:
$ pwd
/u01/app/oracle/diag/rdbms/bench/bench1
$ ls -l
total 144
drwxr-xr-x 2 oracle dba 4096 Jul 9 21:32 alert
drwxr-xr-x 3 oracle dba 4096 Jul 8 11:11 cdump
drwxr-xr-x 2 oracle dba 4096 Jul 9 04:02 hm
drwxr-xr-x 9 oracle dba 4096 Jul 8 11:11 incident
drwxr-xr-x 2 oracle dba 4096 Jul 9 04:02 incpkg
drwxr-xr-x 2 oracle dba 4096 Jun 29 22:00 ir
drwxr-xr-x 2 oracle dba 4096 Jul 10 08:59 lck
drwxr-xr-x 2 oracle dba 4096 Jul 10 08:59 metadata
drwxr-xr-x 2 oracle dba 4096 Jul 8 11:11 stage
drwxr-xr-x 2 oracle dba 4096 Jul 8 11:11 sweep
drwxr-xr-x 3 oracle dba 57344 Jul 10 09:02 trace
$ cd trace
$ pwd
/u01/app/oracle/diag/rdbms/bench/bench1/trace
$ ls -l alert*
-rw-r----- 1 oracle dba 1098745 Jul 10 09:00 alert_bench1.log
In this case, my database is called bench and the first instance is bench1. To quickly locate alert logs associated with many different ORACLE_HOMEs simple execute the adrci command and then execute “show alert”
Kevin Closson's Blog: Platforms, Databases and Storage 
Recent Comments