Oracle 10g dbstart errors

After correcting my dbhome not found problem, I now encounter a “VER10LIST=10 is not an identifier” error when executing the dbstart script. Found Metalink Note 466241.1 explaining the necessary modification to the $ORACLE_HOME/bin/dbstart script.

At or near line 87, you need to modify the code from this:

export VER10LIST =`$ORACLE_HOME_LISTNER/bin/…`

to this:

VER10LIST =`$ORACLE_HOME_LISTNER/bin/…`
export VER10LIST

The script is executing using the Bourne shell and the syntax for setting an environment variable is:

variable=value
export variable

After fixing the above problem, the next error encountered is “`COUNT=$’ unexpected” at or near line 259. This error is also resolved with a modification listed in Metalink Note 466241.1.

From this:

COUNT=$((COUNT+1))

to this:

COUNT=`expr $COUNT + 1`

MySQL: Lock wait timeout exceeded

Running MySQL version 4.1.20. Encountered this error 1205 when attempting to purge my PerfParse database. Recently modified the data retention from 90 days to 60 days.

One of many errors from the /usr/local/nagios/var/perfparse.log.20071212 log file.

INSERT perfdata_bin_summary_data (metric_id,
frequency, ctime, val_count, sum_val,
sum_square_val, max_val, min_val)
VALUES (21, 1, FROM_UNIXTIME(1197446400),
1, 2.85000000000000e+00,
8.12250000000000e+00,2.85000000000000e+00,
2.85000000000000e+00)

(Lock wait timeout exceeded; try restarting transaction)

The tables in PerfParse use the InnoDB storage engine. I believe the purge is holding a table lock longer due to the amount of data being purged by the “perfparse-db-purge” process and is causing normal PerfParse performance data transactions to fail.

To resolve this, I had to reduce the data retention gradually over time instead of trying to purge 30 days all at once.

References
MySQL DBA – “MySQL: Replication stopped: Lock wait timeout exceeded”

Mounting Oracle media on HP-UX

One annoying aspect of installing Oracle on HP-UX is the requirement to mount the CD or DVD device, unlike Solaris in which it auto-mounts. I guess what makes it annoying to me is trying to remember the commands. Since Oracle media for HP-UX is RockRidge-formatted, the usual mount command cannot be used. In my case, I am working with HP-UX 11i V1 (11.11).

Another annoyance is the Oracle documentation which appears to be incorrect and/or in my case doesn’t work in my environment.

# /usr/sbin/mount -F cdfs -o rr /dev/dsk/c0t0d0 /cdrom
mount: illegal file system specific option rr

However, I was able to find a solution in Metalink Note 219190.1 using “mount rockridge cd-rom hp” as the search criteria.

Using a Google search with “mount rockridge” as the criteria, I also found information at comp.sys.hp.hpux FAQ and HP-UX Tips & Tricks blog.

To mount the DVD, I used the steps below logged in as root. Assumes the pfs executables are located in /usr/sbin.

1) Create/Edit the /etc/pfs_fstab file.

/dev/dsk/c0t0d0 /cdrom pfs-rrip xlat=rrip 0 0

2) Execute commands below.

# nohup pfs_mountd &
# nohup pfsd &
# pfs_mount /cdrom

3) Unmount when finished.

# pfs_umount /cdrom