Stormsail

Ran into a problem trying to upgrade my Oracle instance from 10.2.0.1 to 10.2.0.4:

“Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-07-14_10-28-22AM. Please wait …oracle@dbserver:/u04/database$ Exception in thread “main” java.lang.UnsatisfiedLinkError: /tmp/OraInstall2009-07-14_10-28-22AM/jre/1.4.2/lib i386/motif21/libmawt.so: ld.so.1: java: fatal: libXm.so.4: open failed: No such file or directory”

but looks like it’s been seen before from looking at this thread on OpenSolaris.org

The workaround is to use the Java version that comes with OpenSolaris:

./runInstaller -jreLoc /usr/java/jre -ignoreSysPrereqs

Once that was complete it was easy to complete the upgrade:

SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF

Some time later:

TIMESTAMP
——————————————————————————–
COMP_TIMESTAMP UPGRD_END 2009-07-14 11:19:21
.
Oracle Database 10.2 Upgrade Status Utility 07-14-2009 11:19:21
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:14:04
JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:02:48
Oracle XDK VALID 10.2.0.4.0 00:00:34
Oracle Database Java Packages VALID 10.2.0.4.0 00:00:30
Oracle Text VALID 10.2.0.4.0 00:00:51
Oracle XML Database VALID 10.2.0.4.0 00:02:28
Oracle Workspace Manager VALID 10.2.0.4.3 00:00:41
Oracle Data Mining VALID 10.2.0.4.0 00:00:24
OLAP Analytic Workspace VALID 10.2.0.4.0 00:00:27
OLAP Catalog VALID 10.2.0.4.0 00:01:04
Oracle OLAP API VALID 10.2.0.4.0 00:00:57
Oracle interMedia VALID 10.2.0.4.0 00:03:22
Spatial VALID 10.2.0.4.0 00:01:29
Oracle Expression Filter VALID 10.2.0.4.0 00:00:14
Oracle Enterprise Manager VALID 10.2.0.4.0 00:01:10
Oracle Rule Manager VALID 10.2.0.4.0 00:00:11
.
Total Upgrade Time: 00:31:22
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC> The above PL/SQL lists the SERVER components in the upgraded
DOC> database, along with their current version and status.
DOC>
DOC> Please review the status and version columns and look for
DOC> any errors in the spool log file. If there are errors in the spool
DOC> file, or any components are not VALID or not the current version,
DOC> consult the Oracle Database Upgrade Guide for troubleshooting
DOC> recommendations.
DOC>
DOC> Next shutdown immediate, restart for normal operation, and then
DOC> run utlrp.sql to recompile any invalid application objects.
DOC>
DOC>#######################################################################
DOC>#######################################################################

Next stop will be documenting using Swingbench to benchmark Oracle.

Just come back from a fun packed day/evening out for Andy’s stag do orgainised very well by KKev. We all met up via various forms of transport at a pub near Surrey Paintball for lunch before embarking on an afternoon of quad biking which was exellent fun. The only problem with it being fun is that everyone is now looking for quad bikes to purchase! Andy finished in spectacular style by attempting a doughnut but unfortunately his skill let him down and he came flying off into the instructors quad bike. Doh. Ed also had a close shave with some rather testosterone fueled lads in BMWs who didn’t quite like his gestures for being quiet. Still, we all managed to escape without anything escalating and made our way to Doking train station and the trip up to London. Once there we headed to our hotel to get cleaned up before our next destination……. Urban Golf (Indoor Golf Range). Now, I’ve never really played golf before and it really showed. It’s a very difficult game but….and I won’t shout this out, very enjoyable and I suspect with a little more practice I might continue to like it. Everyone had a good time with lots of meetings with Mr Grolsh and Mr Burger….. which obviously explains whilst we racked up a fairly large bill! lol After that we found a pub for a few more liquid refreshments before heading off to the midnight session at the Comedy Store which was very amusing. After that we headed back around 3am to a much needed sleep as most of us can’t handle staying up after midnight…..man, old age is starting to have an effect….. The next day some of us met for breakfast before heading back home to nurse our handovers. Next stop with be the wedding in September….

Yep, another year old and another year wiser? Probably not….but still turning 36 gave me an excuse to buy another Ibanez. The new guitar is an 2003 Ibanez S1625TKS which I had to pick up in Kilburn, London before heading back to the city office to work for the rest of the day. Still when I got to Pheeb’s place I did get a chance to play for the evening whilst Pheeb’s did some revision for her pending Acupuncture exam. However the new purchase just adds to the list I’ve already got:

Electric Guitars
—————-

Ibanez S470 OL – s/n F415041 – 1994
Ibanez S470 JB – s/n F405853 – 1994
Ibanez S1625TKS – s/n F0300343 – 2003
Hohner – 3GT – “80s” – Headless Guitar

The links of the guitars should take you to the Ibanez catalogue entry and for dating the guitar you’ll need to find and translate the serial number from the headstock using this information.

Acoustic Guitar
—————-

Ovation Celebrity CS157
Valencia CG160 – s/n 0516676
Yamaha APXT-1 – s/n 60415799

Bass Guitar
————

Hohner – “The Jack” – Headless Bass – 8856070

Mmmmm, can you ever have too many guitars?

These warning messages have been really annoying me with my OpenSolaris installation so I thought I’d see if I could do something about it. The data zpool is a mirrored 1Tb pool and even though I’ve got 50+Gb of storage free, time-slider insists on clearing my snapshots…..

Jul 6 02:50:55 monkey time-slider-cleanup: [ID 702911 daemon.emerg] data is over 95% capacity. All automatic snapshots were destroyed
Jul 6 02:50:55 monkey time-slider-cleanup: [ID 702911 daemon.notice] 6 automatic snapshots were destroyed

Let’s see what service properties we have for the time-slider:

hippy@monkey:~$ svcprop time-slider
general/enabled boolean true
general/action_authorization astring solaris.smf.manage.zfs-auto-snapshot
general/entity_stability astring Unstable
general/single_instance boolean true
general/value_authorization astring solaris.smf.manage.zfs-auto-snapshot
zfs/value_authorization astring solaris.smf.manage.zfs-auto-snapshot
zfs/custom-selection boolean true
zpool/critical-level integer 90
zpool/emergency-level integer 95
zpool/value_authorization astring solaris.smf.manage.zfs-auto-snapshot
zpool/warning-level integer 90
auto-snapshot-svcs/entities fmri svc:/system/filesystem/zfs/auto-snapshot:frequent svc:/system/filesystem/zfs/auto-snapshot:hourly svc:/system/filesystem/zfs/auto-snapshot:daily svc:/system/filesystem/zfs/auto-snapshot:weekly svc:/system/filesystem/zfs/auto-snapshot:monthly
auto-snapshot-svcs/grouping astring require_all
auto-snapshot-svcs/restart_on astring refresh
auto-snapshot-svcs/type astring service
startd/duration astring transient
start/exec astring /lib/svc/method/time-slider\ start
start/timeout_seconds count 60
start/type astring method
stop/exec astring /lib/svc/method/time-slider\ stop
stop/timeout_seconds count 60
stop/type astring method
tm_common_name/C ustring GNOME\ Desktop\ Snapshot\ Management\ Service
tm_man_zfs/manpath astring /usr/share/man
tm_man_zfs/section astring 1M
tm_man_zfs/title astring zfs
restarter/auxiliary_state astring none
restarter/logfile astring /var/svc/log/application-time-slider:default.log
restarter/start_pid count 1519
restarter/start_method_timestamp time 1246813450.942248000
restarter/start_method_waitstatus integer 0
restarter/transient_contract count
restarter/next_state astring none
restarter/state astring online
restarter/state_timestamp time 1246813450.947212000

So if we up the following then I shouldn’t worry about snapshots until we’re at 98/99% pool capacity:

hippy@monkey:~$ pfexec svccfg -s time-slider setprop zpool/emergency-level=99
hippy@monkey:~$ pfexec svccfg -s time-slider setprop zpool/critical-level=98
hippy@monkey:~$ pfexec svccfg -s time-slider setprop zpool/warning-level=98

hippy@monkey:~$ pfexec svcadm refresh time-slider

Pheebs and I finally managed to go for dinner at the Sun Inn in Bentworth to celebrate my pending birthday. The food and beer were very good and we both thoroughly enjoyed the atmosphere in the pub. I’d like to visit again but one thing to be aware of is you need to book in advance if you want to sit down and eat!