A couple of interesting Oracle 10gR1 on HP-UX issues I’ve come across in the past couple of days – ably assisted by a few of the Eon (Powergen) Team members (Phil Bridges, Tahir Mahmood and Zaheer Mahmood):

Firstly, we were seeing a line in the trace files on our databases which looked like:

Ioctl ASYNC_CONFIG error, errno = 1

This turns out to be a configuration issue on HP-UX whereby the OSDBA group (dba) must have the MLOCK privilege…which ours didn’t.

After following these instructions we managed to fix this one although it’s interesting to note that the reason we got onto this was by looking at the 9iR2 documentation (after a search hit on google) and when we looked at the 10gR1 docs it’s not mentioned as a potential issue…but the fix works nonetheless.

Next came an issue with running jobs via the DBMS_SCHEDULER package which seemed not to be working for a simple test case.

We kept getting this error:

ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing execution agent failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: sjsec 3

A little research and support from Tahir led to this article which after following the instructions allowed us to get past this and then a few more permissions problems. Now, I can schedule stuff to run on the box during the evening nice and easily (i.e. So it is imperative to do some intricate research on the various anti-impotency patterns order cheap levitra the physicians and clinical recommendations have revealed their opinions in favor of this solution that not only does the medicine get delivered to the user’s house; it is also cheap and affordable. However, almost viagra canada pharmacy all of them have some limitation of recurrence and certain side effects to affect the female fertility to some degree. One of the major causes of ED can turn out to be more dangerous if not taken properly and without the consultation of an expert can certainly generic viagra wholesale generate positive results. People in majority use order 50mg viagra by knowing only its end results for their good sake. without worrying about the fact that I don’t have access to cron or any other OS scheduling facility)…here come the benchmark runs!
Speaking of benchmarks, I’ve been a little quiet on the blog recently as I’ve been running some parallel execution tests in light of Doug Burns’ recent presentation at Hotsos here. It’s something we’ve been wondering about on our data warehouse – the appropriate Degree Of Parallelism to use – this presentation was a kick start into thinking about it some more and indeed running some tests courtesy of the scripts and paper Doug has put together. I’m finding some similarities with Doug but also some differences which he and I are still email ping ponging over…I’m sure there is another paper in there Doug…