From errors we learn ...

udev and getting iscsi disks working from readynas - linux x86_64 oel6.1

2012-01-03T23:01:00.001+01:00

Iscsi is a great and cheap way to use shared storage. Now that readynas also supports can run as a iscsi target, I decided to ditch the open filer I have been using for ages. The open filer ran in a vm, the readynas is dedicated so there is some advantage here. For this setup I decided not to use asmlib, only udev.udev is needed to get consistent naming. Without it, it is a bit hard to foretell

11.2.0.3 grid installation issue: multicast communication with multicast group 230.0.1.0 fails

2012-01-03T21:51:00.001+01:00

While preparing a new set of vms to run RAC on I met this little issue.[oracle@vol01 grid]$ ./runcluvfy.sh stage -post hwos -n vol01Performing post-checks for hardware and operating system setupChecking multicast communication...Checking subnet "192.168.2.0" for multicast communication with multicast group "230.0.1.0"...PRVG-11134 : Interface "192.168.2.10" on node "vol01" is not able to

ORA-00001: unique constraint (SYS.WRI$_ADV_SQLT_PLANS_PK) violated

2011-12-18T18:27:00.001+01:00

Last week it was my honor to dive into some performance problems in a data warehouse. The database was running 10.2.0.4 and should have been upgraded a long time ago. While analyzing heavy resource consuming SQL I prefer to use dbms_sqltune to do the analyzing part. In this case, the most costly statement ran for hours and hours, was quite complex and needed some serious attention.This is the SQL

how to configure dbvisit to manage existing standby database running SE

2011-10-31T16:12:00.001+01:00

Standby database are around since a long time. Since Oracle integrated Data Guard, the maintenance of a standby database has become a lot easier than before, when you are running Enterprise Edition (EE). Those who are running Standard Edition (SE) are left in the cold...This is exactly where dbvisit jumps in with their product dbvisit standby. This replaces the need for all those fine user cooked

Cost reduction using Oracle SE and dbvisit standby

2011-10-25T21:42:00.001+02:00

Often we get to hear that Oracle is so expensive. First thing that popup into my mind is: are you using the Oracle in a smart way? Sure, Oracle EE licenses have a price and it is quickly more than I can afford. However, if you use it for a site that earns you a Million per day, it is cheap compared to the loss you make during an hour of downtime, planned or unplanned.One of the reasons people are

sshdfilter improvements

2011-10-25T10:57:00.002+02:00

Hackers are all over. When your system is connected to the internet it's not a question if your system will be honored by a visit but when and how this will be done. Many attacks will be done using brute force methods. One of the methods that can slow down a brute force attack is by setting up a delay in firewall rules. This only works if the attack is coming from one and the same

looping in scheduler job chains

2011-09-21T16:47:00.001+02:00

updated for 11.2.0.3A reader of my book asked if something was broken in 11gR2 regarding the example I gave on page 50 of my book. To check this I installed a 11.1.0.6 database and created a job chain in it. The idea is to have a chain step that is long running and an other chain step that does something while the long running step is executing.Code listed:grant execute on dbms_lock to &you;--/

how to secure your private network from brute force attacks?

2011-09-11T16:38:00.001+02:00

If you have your systems connected to the internet this might be of interest for you. Not if you do not expose any services to the open world. In my case, I have a few services running, amongst others ssh. Since ssh can give a hacker a wealth of options to manipulate your system, it is good to take some actions to at least slow down the attacker.I have not the illusion that the actions described

Packt's 50th Oracle book released -> reason for a nice discount!

2011-07-19T18:00:00.001+02:00

Many will already know about Packt. They recently released their 50th book on Oracle. For this reason they now offer great discounts on the Packt site. 20% off every Oracle book, 30% off from any Oracle eBook. This of course is also valid for mine, Mastering Oracle Scheduler in Oracle 11g Databases.A good reason for some serious book shopping!Don't wait to long, it's only valid in Julyhttp://

'long' object names

2011-06-29T14:31:00.000+02:00

Today it happened again. A developer made a database independent program and gave me the ddl to install it in a - in this case - Oracle database. Given the fact that the application is developed as database independent, this should give no problems. During the installation I got many ORA-00972 identifier too long error messages. This surprized me a little. Checking the code, it appeared that

result caches ..... what about heavily modified data -> In-Memory Database Cache Option

2011-04-14T15:45:00.001+02:00

In Oracle 11g a lot of nice features are introduced that help to speed applications. One of them is the Server Result Cache, that can also be located on a client. They have one weak point, about the same as for Materialized Views, if the data where the cache or the mview is based upon is modified, they get invalidated and have to be built up again.In situations where lots of updates are

adaptive cursor sharing and SQL Plan Baselines - ACS & SPM

2011-03-21T15:00:00.003+01:00

For years we all knew about the problems involved with cursor bind peeking. This was a mechanism introduced in 9i that gave the optimizer the option to peek the values of bind variables. This looked like a smart idea but in reality this was not so smart when skewed data was in place.A common heard problem at performance tuning sessions is:"When Jansen starts early, everything works well. As soon

PRO*C and Xcode 3.2, how to get it working

2010-11-10T22:01:00.001+01:00

This week I am in a Big Nerd Ranch iOS training. If you would like to learn something about iOS development in a very short time, I can recommend this to anyone. It is very intensive but it is worth every Euro. Training starts at 09:00 and it does end daily, some 12 (sometimes even more) hours later.It gave me the chance to fiddle a little more with Xcode and PROC*C projects. Not that PRO*C was

upgrade to 11.2.0.2 gives SQL plan baseline issues

2010-10-14T07:40:00.000+02:00

In this case, the database ran using 11.1.0.6, was upgraded to 11.1.0.7, 11.2.0.1 and finally to 11.2.0.2. After this last step the following errors occurred, a bit too often to my taste: ORA-38141: SQL plan baseline SQL_PLAN_697q92chf3r9rc3f66c3c does not exist SIGNATURE SQL_HANDLE SQL_TEXT PLAN_NAME CREATOR ORIGIN PARSING_SCHEMA_NAME DESCRIPTION VERSION CREATED LAST_MODIFIED LAST_EXECUTED

oracle 11.2.0.2 (patch?)

2010-09-16T07:24:00.001+02:00

parts from the readme: 1 Patch Set OverviewStarting with the 11.2.0.2 patch set, Oracle Database patch sets are full installations of the Oracle Database software. This means that you do not need to install Oracle Database 11g Release 2 (11.2.0.1) before installing Oracle Database 11g Release 2 (11.2.0.2). So this makes things easier. Why call it a patch if it is a full base installation? It

new books and publications

2010-08-20T13:33:00.001+02:00

a while ago I was asked for a podcast recording about my book, Mastering Oracle Scheduler It took a while but now it is available as one of the Oracle Author Podcasts in http://www.oracle.com/podcasts/index.html. Look for 'The Birth of Oracle Scheduler or follow the link.This was a nice opportunity to tell something more about the book, I hope you like it.Oracle Real Application Cluster Hand

rman incremental backup challenges

2010-08-04T21:25:00.001+02:00

Here a short message about rman that is not very documented. This is about a backup strategy with weekly incremental level 0 backups and a few times in the week a differential incremental level 1 backup, using block change tracking to speed this up. The rdbms version is 10.2.0.4, Enterprise Edition.The documentation is very clear, when no incremental level 0 backup is available, the incremental

dbfs is great

2010-06-08T14:23:00.008+02:00

While experimenting with 11gR2, more specific, with dbfs and dbfs_client on Linux I asked my self "what can we do with it?". The first thing that popped up to try was copy a few simple files in it and that works fine. I can edit the file using the blob editor in dbVisualizer, using vim on the host where the dbfs is mounted. So this works ...Now let's create a database in the dbfs filesystem.Guess

OCM, at last

2010-05-31T15:06:00.002+02:00

it took a while before I got the result. My spam filter silently removed a message on which I should have responded .... Now this is cleared and I got the long awaited result: succeeded.Taking the test is not a problem, the administration around it is the real challenge ;-) Taking the test was a lot of fun. It is like being thrown in a pit full of snakes and see how you get out of it. I did like

a new RAC book will be published soon

2010-04-25T10:30:00.001+02:00

After having written my own book about mastering the oracle scheduler, I was asked to be part of the reviewers team for Jaffars book, The Oracle 11g Real Application Clusters Handbook. Jaffar was one of the reviewers of my book, so I was quite happy to be given a chance to help Jaffar with his book. The book is a nice book, full of very usable tips and advices that are usable for many

ocm test 10g

2010-03-25T17:10:00.001+01:00

On april 8th and 9th there is the possibility to join for the Oracle OCM test for Oracle 10gR2. Who would like to join me in that test? Maybe we can prepare together? The test is taken in De Meern in The Netherlands. Anyone who has the prerequisites can participate. You can enter the registration process by contacting oracle education. It does help when you know your Oracle Learning ID. It is

how to reach exadata v2 oltp performance using a regular machine?

2010-03-18T21:22:00.001+01:00

Last year Oracle showed the exadata v2 machine that has incredible performance numbers stamped all over in it. There are a few limitations that can prevent one from using this nice toy. One for example is that the power is only unleashed when you can use Oracle 11gR2.If you are still stuck on an earlier version you are just out of luck. For those of us that are running on Solaris there might be a

CIBER Kennis Carrousel

2010-02-28T10:37:00.000+01:00

Binnenkort presenteert Ciber de derde CIBER Kennis Carrousel, een evenement waarbij kennisdeling over vooruitstrevende ontwikkelingen in ICT-land centraal staat. Voor meer informatie zie CIBER Kennis Carrousel11 maart 2010Spoorwegmuseum, UtrechtEr is een zeer gevarieerd aanbod van presentaties en demonstraties. Deelname is gratis, aanmelding kan via de website[Posted with iBlogger from my iPhone]

auto purging of logfiles

2010-02-25T17:25:00.004+01:00

Oracle has a great history of building log and trace files of all kinds and sorts. Maintaining them is a different story but they are seriously improving here. Since oracle 11gR1 they implemented the ADR - Advanced Diagnostics Repository - that replaces the old user_dump_dest, background_dump_dest and core_dump_dest.The default location for ADR is in $ORACLE_BASE, if set or $ORACLE_HOME if

manually configuring 11gR2 grid for ASM

2010-02-08T16:40:00.007+01:00

With the introduction of 11gR2 oracle made some subtle changes in the way ASM is implemented. The choice is not bad, it is now integrated in the Oracle Grid Infrastructure, and no longer in the Oracle rdbms software. The result is that we now have to install and configure a separate grid and a rdbms ORACLE_HOME. This is not a big deal an resembles a normal RAC installation where we were used to

dbms_stats block_sampling

2010-01-05T21:40:00.001+01:00

The challenge for maintaining stats is to do this only when needed and with a sample as small as possible to preserve cpu and io resources. The sampling of tables and indexes is quite an intensive task. Oracle included an auto sample job in 10g and up that does a lot of useful work for us, in many databases.Some databases are a bit more complex and a bit large to be able to follow the defaults.

oraenv oddities in 11gR2

2009-11-01T23:39:00.001+01:00

Recently I was installing a regular 11gR2 installation and tried to use it by an other user than the software owner or a member of the dba group. A - so called - regular user.When I ran oraenv to configure my environment for the ORACLE_SID I was going to use I was told that ORACLE_BASE environment variable is not being set since thisinformation is not available for the current user ID ciberYou

more deinstall headaches

2009-11-01T23:01:00.001+01:00

Today I needed to re-install an ORACLE_HOME. Why? I have my reasons so let me do it. In the old days we ran $ORACLE_HOME/oui/runInstaller and selected deinstall product to get rid of the software. Now, 11gR2 (11.2.0.1) the only reaction is a popup box telling me to run $ORACLE_HOME/deinstall/deinstall to deinstall the ORACLE_HOME.The specified ORACLE_HOME is used for a database, a database that I

Oracle Scheduler in 11gR2 - p2 schagent

2009-10-31T21:53:00.001+01:00

In the previous post about Oracle Scheduler in 11gR2 I already mentioned that the Scheduler Agent now is part of the client installation. Here we will see how to install it.The InstallationThe installation is straight forward, download the client installer, unzip it and navigate to the client directory, where you will find the runInstaller, as usual. Start the installer./runInstaller, select the

de-installation surprises

2009-10-24T22:56:00.001+02:00

There are lots of stories on the web about how to do an oracle installation. For de-installations there a not so many notes around. Until oracle 10g life was fairly simple, you could just run de oui from $ORACLE_HOME/oui/bin/runInstaller, select the ORACLE_HOME to de-install, wait for the process to complete and remove the ORACLE_HOME directory from the filesystem.10gR2Then came oracle 10gR2,

OOW 2009

2009-10-13T06:33:00.002+02:00

For me this is the first Oracle Open World I visited. It is great. The scale is enormous. There are lots of very interesting presentations and demos. I have been visiting a few, targeted to BI and rdbms in general. The exadata database machine is a very interesting piece of machinery.Between all the oracle celebrities I have been presenting at an unconference session and I was lucky to see that

job_queue_processes and dbms_scheduler

2009-09-25T10:55:00.008+02:00

This parameter has some history:from the reference manualv8.1.7:Parameter class: Dynamic. Scope = ALTER SYSTEM. Default value: 0 Range of values: 0 to 36 Oracle Parallel Server: Multiple instances can have different values. JOB_QUEUE_PROCESSES is relevant in replication environments. It specifies the number of SNPn job queue processes per instance (SNP0, ... SNP9,

OOW 2009 - Oracle Open World - unconference

2009-09-25T09:47:00.003+02:00

This year I will be visiting Oracle Open World, invited by Packt Publishing, fully supported by Ciber. My college Rob van Wijk will also be there and pointed me to the possibility to reserve a space for an unconference room. This I did and on Monday at 14:00 I got a room in Overlook II. It is my intention to show some Oracle Scheduler front end tools and with a little luck, share experiences with

Dzone and Packt Publishing have partnered

2009-09-24T16:42:00.002+02:00

Dzone and Packt Publishing have partnered to bring you this exclusivechapter from my book 'Mastering Oracle Scheduler in Oracle 11g Databases'.This chapter explains how to make good use of the Scheduler and apply jobseparation."Control the Scheduler"Oracle Scheduler does a lot of out of the box things, and if the demands arenot too high, Oracle Scheduler can cover most of the situations. When

quick creation of a valid EL5.4 linux installation in vmware[fusion]

2009-09-22T20:38:00.004+02:00

Start with downloading the latest Enterprise Linux Distribution from oracle Choose the Enterprise Linux Release 5 Update 4 for x86 (32 Bit) - DVD at the bottom of the page.unzip the file you downloaded try to remember where you left it.In vmware Create a New Virtual MachineContinue without diskIn the Installation Media select Create a custom virtual machine and continueIn Choose Operating System

Universal installer 11gR2

2009-09-09T21:21:00.001+02:00

One thing that immediately is visible after starting the graphical Universal Installer is that it now not only complains when it checks the prerequisites for the installation. Now it also generates a script that helps the poor dba that does not have the sysadmin skills to adjust the kernel settings by self.I think this is a great improvement that can help a lot of people.

Oracle Scheduler in 11gR2 - p1

2009-09-02T22:21:00.001+02:00

rdbms installationNow that oracle 11gR2 can be downloaded and the documentation is available it is time to dive into the new features of the Oracle Scheduler.A single day to play is not enough to see everything but the changes start immediately at the beginning, the installation, or even before that, the download. The 11.2.0.1.0 rdbms installation consists of 2 zip files of about 1GB each that

Oracle Scheduler front end tool - Scheduler FE

2009-08-07T23:41:00.001+02:00

In my book Mastering Oracle Scheduler I mentioned the lack of tools for the Oracle Scheduler. I recently got a mail from a reader that there does exist an other Oracle Scheduler front-end tool. You can find it here and it is called Scheduler FEThe package is written in Java and it runs perfectly well on my mac, as it should on any Java system. You can download it for free and the author is

rman duplicate database slow

2009-07-31T16:33:00.002+02:00

Recently I was given the honor to clone a large database. The source database was about 4T with 390 datafiles, version 10.2.0.4. A recent backup was available and could be used as source for the clone operation. The end time of the backup also had to be the end point for the recovery.I quickly created a simple script:connect target dba/secret@sourceconnect auxiliary /run {set until sequence 34016

ORA-27483: "string.string" has an invalid END_DATE

2009-07-23T13:32:00.004+02:00

ORA-27483: "string.string" has an invalid END_DATEIn oracle 11.1.0.7 this error can occur when using dbms_scheduler, even when the end_date is perfectly valid. Try to set the max_runs job atribute on a job that has a valid end_date specified. When you do so you suddenly get ORA-27483: "string.string" has an invalid END_DATE.For some reason oracle does not allow to have both the end_date and the

DbVisualizer 6.5.7 is released

2009-06-19T12:55:00.002+02:00

Today DbVisualizer 6.5.7 is released. This release has all the additions that are used in the book Mastering Oracle Scheduler. Next to that a little support for ASM and Resource Manager is included.

Mastering Oracle Scheduler in Oracle is available now !

2009-06-16T12:19:00.003+02:00

In what I see as a delayed birthday present, yesterday finally the book Mastering Oracle Scheduler in Oracle 11g Databases is published.Writing the book was real fun. Before writing this book I already had completed a few projects involving the migration from a third party scheduler to the Oracle Scheduler. This gave me an advantage that was very usable during the writing of this book. The book

Howto configure resource manager using DbVisualizer

2009-06-08T22:31:00.001+02:00

I already told about the fact that you can teach the DbVisualizer tool perform about every trick that you can come up with to do in a database. One thing I found that was lacking was Resource Manager. Together with Nathan Aaron I implemented some form of Resource Manager control in dbvis. Here is a short explanation about how to use it.first download my oracle.xml for DbVisualizer - see the links

contents of planboard presentation about scheduler

2009-05-27T09:54:00.001+02:00

During my presentation about the Oracle Scheduler I demonstrated a little script that generated a lot of jobs, first a series of jobs tied to a window and later the same series of jobs not tied to a schedule. This demonstrated that when the jobs were tied to a window, the order of the executions was mostly in the alphabetical order of the job class that were defined for the jobs. Not really what

tuning redo apply on zfs

2009-05-09T21:24:00.001+02:00

We are running large databases on zfs filesystems. The performance is not yet optimal but sufficient to be able to work. Tuning is an ongoing process. Recently we applied the latest zfs patches and introduced some new tunables on the standby site.Before these changes the redo apply rate was somewhere around 15MB/s. Not a speed monster but enough for our goal.After these changes on the operating

how to install oracle 10.2.0.4 on intel (client) macs - quick

2009-04-12T00:08:00.001+02:00

Finally oracle released the long awaited 10gR2 release of the rdbms for intel macs. The release notes show that it is far from complete. Missing is (amongst others) support for RAC, ASM and APEX.a Quick installationIn this quick installation we forget everything that we normally do for a production capable installation. It does not make sense to setup for production on a system that is not

moving scheduler jobs from one to an other database

2009-04-10T19:37:00.001+02:00

howto imp/exp a job without causing a running job on impThe challenge here is to transport jobs defined in a source database to a target database, without having the jobs running after the import finishes. We can do this by disabling the job in the source database but because this is an important production job that has to run very frequently this is not an option.This is where we can use a

Presentation about Oracle Scheduler

2009-03-25T11:40:00.001+01:00

Presentation about Oracle Scheduler: "At May 26 I will be doing a presentation at Planboard's Oracle DBA Symposium. The presentation is about how we can use the Oracle Scheduler.Even though the symposium is aimed at DBA's, I see several interesting presentations for a database developer as well. I'm looking forward to those presentations and I am keeping my fingers crossed that they won't be at

ORA-02800 when starting a scheduler job

2009-03-12T23:13:00.001+01:00

Say you are playing with Oracle Scheduler and you are trying to start a job. Everything is working all right. The remote scheduler agent is upgraded to the latest patch level, the certificate is fixed and the scheduler agent is running.Everything looks OK and still you are greeted with a happy ORA-02800: Requests timed out.Before pulling your last hair, take a look at the status of the scheduler:

Oracle Scheduler developments in DbVisualizer

2009-03-07T17:24:00.001+01:00

The scheduler in oracle is available for quite a while now. Still there is hardly any support for it in the form of a usable graphical user interface. I mentioned the tool before but with a little effort DbVisualizer can be turned into a simple scheduler tool. Together with Nathan Aaron I am adding more support for the oracle scheduler in DbVisualizer. This will make the scheduler a lot more

oracle and NUMA

2009-01-13T18:16:00.001+01:00

It may have happened to many. For those who did not got the clue, since the oracle 10.2.0.4 update it looks like the default behavior of the database is to think it is running on a NUMA machine, where NUMA stands for Non Uniform Memory Architecture. I do not know many NUMA machines. Sequent had some machines running on dynix/pts that had a NUMA architecture. I am sure IBM - that bought sequent a

oracle client on intel macs is available - and working !

2008-12-31T17:00:00.001+01:00

It took a while before we could use a decent oracle client like sqlplus on a mac machine with an intel cpu. Since April it was available as a download on OTN: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocsBy the time I wanted to install it on my brand new macbook (running macosx 10.5.5) I had a little problem. The installation went smooth but starting any of the client

how to use the command line mail tool when your isp blocks port 25

2007-12-17T21:42:00.001+01:00

There are times that you want to be able to sent mail using simple command line tools and scripts. Here in the Netherlands many isp's have decided to block port 25 in order to get more control on the spam flood. I won't comment on the usefulness of this solution but it's quite easy to get this working again. The keyword here is postfix.For the mac you can download Rapido SMTP, a nice free tool

oracle 10.1.0.5 on Leopard

2007-10-29T21:06:00.001+01:00

I had my installation upgraded to 10.1.0.5 while running Tiger. After the leopard installation (I installed on a new volume and imported the users from the old volume) I only had to create the dba group like it was in tiger and assign it to my dba account.$>sudo dscl . -create /Groups/dba$>sudo dscl . -create /Groups/dba gid 504$>sudo dscl . append /Groups/dba GroupMembership ronrAfter this I

what to expect from oracle 11g ?

2007-10-04T23:17:00.001+02:00

last weekIt's already more than a week ago that I visited the oracle partner briefing where a presentation was given about a few of the new features to expect in 11g. As always every thing is better than ever before and it works ... I really hope this is true. A very welcome feature would be stability. It really amazes me how many problems we currently have trying to run with 10.2.0.3. Memory

ssh in a windows environment

2007-07-10T21:12:00.001+02:00

More and more sites are moving from telnet to ssh and they should. Since networks are connected to other networks it is a bit hard to speak about a network that is 'safe'. It's very easy to use a sniffer to read passwords that are passed in plaintext during logon using old protocols like telnet and ftp.Here is where ssh or openssh comes in. Many of us are caught on a windows desktop that default

Howto use Apache-2 in Tiger's sharing controlpanel

2007-05-31T21:12:00.000+02:00

Apple still uses the ancient Apache 1.33 as webserver in MacosX 10.4.9 or Tiger. It's quite easy to download from and install it. The default install location is /usr/local/apache2/ When you want to integrate this in the sharing controlpanel for Personal Web Sharing, all you have to do is to rename /usr/sbin/httpd to /

oracle upgrade 10.1.0.5 for macosX

2007-05-10T22:46:00.000+02:00

Without telling it the world oracle silently released the 10.1.0.5 patch for macosX. In the release notes they tell that macos 10.3.9 is now the supported platform. In the bug list they also mention having solved issues on Tiger ...The installation on 10.4.9 nearly went smooth. The workaround to install on tiger, as mentioned in http://ronr.blogspot.com/2005/05/how-to-run-oracle-10gr1-

Invalid data type in view columns - 10gR2

2006-05-08T20:48:00.000+02:00

Some views that were completely valid and usable in 10gR1 - and compiled without errors in 10gR2 did cause some peculiar errors in packages that depended on them. Even a normal select * from the_view failed.ORA-06552: PL/SQL: Compilation unit analysis terminatedORA-06553: PLS-201: identifier 'UNDEFINED' must be declaredAfter a quick review I found that the - generated - view definition was

dbconsole: unable to connect to the database

2006-05-03T20:37:00.000+02:00

Today it happened again. A 10gR2 database with a dbconsole installed on it was giving problems. The dbconsole was able to get the status of the instance and the agent was able to have the agent connected. It was not able to get the status of the listener. On this specific site there was a problem with system administration, to be more precise with the dns. Some settings were based on ip-address,

database browser - dbVisualizer

2006-04-01T20:50:00.000+02:00

A perfect tool will be very hard to accomplish. The guys that work on dbVisualizer really do a good job. It's not a dedicated oracle tool, it's multidatabase and multiplatform, but it has some very interesting features. Next to what it already has out of the box, one can easily create lots of extra functions by modifications to the profiles. Who loves toad will probably stick to toad but who is

statspack queries

2006-03-05T15:06:00.000+01:00

Statspack is very nice, the report you get with spreport usable but this can be made more valuable when you can follow the history of the database. A query like this one:select snap_id, db_name, instance_name, snap_time,item,current_value, current_value - prev_value delta, round((snap_time - prev_time) * 24 * 60 * 60) secs, round( (current_value - prev_value) /

Proc compilation and linking with xcode 2.0.

2005-05-25T21:29:00.000+02:00

Initially compiling and linking proc program was a bit problematic.For compilation I defined a dependency structure using an aggregate target that depends on the *.pc file resulting in the *.c file where the object file depends on.The problem I got after linking wasZeroLink: unknown symbol '_iaprval' at runtime.Disabling zerolink might help (caveats using zerolink)It does help !disable

How to run oracle 10gR1 on tiger ?

2005-05-24T21:43:00.000+02:00

Installing oracle 10gR1 on tiger is not supported by oracle. It also is not very straight forward but ... it is possible. Just install the software as you did with macos 10.3.make sure you have gcc 3.3 as default compiler, set this as default by running the command "sudo gcc_select 3.3"cd $ORACLE_HOME/libmv libnnz10.dylib libnnz10.dylib.orirelink allmv libnnz10.dylib.ori libnnz10.dylibWhen you

oracle on Apple macos X

2005-05-09T21:08:00.000+02:00

Nice to see that several companies are considering to deploy oracle on the Macintosh in favor of windows and even Solaris systems. On december 31th 2004 I opened a site for a norwegian customer that is now 100% mac based. Until that date they were forced to use a windows server for the oracle database.Several other people have contacted me for advice to help them to make a choice between macosX,

browser compatibility

2005-04-09T13:31:00.000+02:00

It's a pity that Safari does not do all the work in this blog. Using Safari 1.2.4 at the moment.Yesterday there was a problem with the Browser publishing the new entry. Now suddenly it just works. Strange but welcome.

starting up

2005-04-08T18:00:00.000+02:00

Hey, just found back my blog. Completely forgotten about it.Have been quite busy with oracle on the mac and am still looking for a way to build a rac on a mac. In my next project I have to build a rac on hp-ux which is also very nice to do.Also see http://homepage.mac.com/ik_zelf/oracle for some mac related oracle stuff.

first line

2003-01-17T14:14:00.000+01:00

Just finding my way around ...