Archive for November 2009
64-bit JRockit and the 11R1 SOA install
Somehow I keep on running into trouble installing 64-bit Oracle Fusion Middleware SOA suite. The process seems quiet simple if you follow the installation guide. First of all I installed the 64-bit J-Rockit (see this post how to download it).
$ export JAVA_HOME=/u01/app/jrockit
$ export PATH=$JAVA_HOME/bin:$PATH
$ java -version
java version “1.6.0_03”
Java(TM) SE Runtime Environment (build 1.6.0_03-b05)
BEA JRockit(R) (build R27.5.0-110_o-99226-1.6.0_03-20080528-1505-linux-x86_64, compiled mode)
Next I started the generic installer and installed the weblogic server:
$ java -jar /u01/app/install/wls1032_generic.jar
Then it is time to set the environment and start the installer:
source /u01/app/oracle/middleware/wlserver_10.3/server/bin/setWLSEnv.sh
$ /u01/app/install/ofm_soa_11.1.1.2.0/Disk1/runInstaller -jreLoc /u01/app/jrockit
cloning with 11R1
Some time ago I posted about the cloningutillity for Oracle Fusion Middleware 11. Mind you, this is something different from Oracle Fusion Middleware 11R1: 11.1.1.1.0 verses 11.1.1.2.0 . Even though the version sounds like a minor patch, I noticed that the cloningclient.jar utillity somehow lost the option -excludePattern. The error messages for excludepattern are still documented, but if you try to call the utillity with the -excludePattern option this error is raised:
SEVERE : Nov 18, 2009 12:41:58 PM – ERROR – CLONE-20200 The clone option or argument is invalid.
SEVERE : Nov 18, 2009 12:41:58 PM – CAUSE – CLONE-20200 The option or argument “-excludePattern” was not supported by cloning.
SEVERE : Nov 18, 2009 12:41:58 PM – ACTION – CLONE-20200 Provide valid option or argument. Use the “-help” command to know more about cloning options and arguments.
Removing functionality with a bugfix sounds somewhat like unexpected behaviour.
EUS and asmcmd
I have been working a lot with EUS lately at a big customer. My personal account is able to login to databases (EUS) and also on to OEL (OAS4OS). This combined with some chown/chmod commands on OEL enables me to do my job with my personal account.
Since this customers also uses ASM, I figured I would like to use my personal account for asmcmd too. First I tested the process with a local account, baby steps usually works best for me. I created an account jhl
# useradd -g asmadmin -G dba jhl
Next i su’d to jhl and tested the procedure:
$ id
uid=10238(jhl) gid=4007(asmadmin) groups=4006(dba),4007(asmadmin)$ . oraenv
ORACLE_SID = [+ASM1] ? +ASM1
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.1.0/asm_200 is /u01/app/oracle$ asmcmd
ASMCMD> ls
This looks promising, all needed to be done next was repeating the steps only now with an account from the OID. First I had to add the group to the OID, here’s the ldif I used:
64-bit J-Rockit
I figured my English is good enough to understand directions given by Oracle, usually I manage quiet okay. Somehow it wasn’t all clear to me that the JRockit download page stated that you needed to go to edelivery.oracle.com, login and search for Oracle BEA & Linux x86-64, click on BEA WebLogic Media Pack for Linux x86-64 and then finally find a link to download JRockit R27.5.0 for Java SE 6 for Linux x86-64. Even more frustrating is to find out that the jrmc download included JRockit so no separate download was needed anyway.
*ARGH*
startup scripts
Every now and then there’s another discussion about how to create startup scripts for a database. Frits Hoogland just made an interesting post, somehow I get the feeling this information is new for most people. Being brought up with Linux instead of an old unix starts getting more and more useful 😉
px-slaves and gv$session
While troubleshooting some problem on a RAC database for a customer, I queried gv$session. I knew I was the only user logged in with my username, but somehow I found four rows in gv$session for my one session. Some further investigation told me this:
MY_USER@SOME_DB SQL> select inst_id, username
2 from gv$session
3 where username = ‘MY_USER’;INST_ID USERNAME
———- ——————–
1 MY_USER
1 MY_USER
2 MY_USER
3 MY_USER
Obviously I was annoyed by the fact that four results came back from gv$session, even though I was the only person logged in. Luckily my colleague Jeroen explained to me that I was completely overlooking the fact that querying gv$session actually invokes a parallel query over the complete RAC:
MY_USER@SOME_DB SQL> select inst_id, osuser, program
2 from gv$session
3 where username = ‘MY_USER’;INST_ID OSUSER PROGRAM
———- ——————– ————————————————–
1 LandlustJH sqlplus@some_server.nl (TNS V1-V3)
1 LandlustJH oracle@some_server.nl (PZ99)
2 LandlustJH oracle@some_server.nl (PZ99)
3 LandlustJH oracle@some_server.nl (PZ99)
Somehow I could have know this…. Somehow this also might explain why sometimes EM gives four audit alerts after one login. Anyway, this post is to share this with the world: remember that sometimes results from Oracle seem wrong, but in fact they’re not.
P.S.: and call Jeroen if you need a real pro on the job 😉