Oracle MVA

Tales from a Jack of all trades

Archive for November 2009

64-bit JRockit and the 11R1 SOA install

leave a comment »

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

Read the rest of this entry »

Written by Jacco H. Landlust

November 26, 2009 at 1:03 pm

cloning with 11R1

leave a comment »

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.

Written by Jacco H. Landlust

November 18, 2009 at 2:04 pm

Posted in Installing, Weblogic

EUS and asmcmd

leave a comment »

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:

Read the rest of this entry »

Written by Jacco H. Landlust

November 17, 2009 at 7:02 pm

64-bit J-Rockit

with 2 comments

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*

Written by Jacco H. Landlust

November 17, 2009 at 3:46 pm

Posted in JRockit

startup scripts

leave a comment »

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 😉

Written by Jacco H. Landlust

November 16, 2009 at 8:30 pm

Posted in Announcements, Linux, RDBMS

px-slaves and gv$session

with 2 comments

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 😉

Written by Jacco H. Landlust

November 11, 2009 at 8:31 pm

Posted in RAC