Tuesday, 24 January 2012

Oracle NoSQL database

I'm just reviewing Oracle NoSQL database. This database is part of BigData and Oracle has an interesting view about the coexistence of NoSQL, Hadoop, Traditional SQL.
Check out this image:
Oracle NoSQL View
Oracle view is really impressive and may become a real challenge.

Oracle claims to have a BASE compliant database but this seems not true. Reading documentation you can discover that sometimes eventual consistency model is not obeyed.

I'm also impressed from this technical aspect: ACID compliant transactions. Is this the first NoSQL database ACID compliant? Is Oracle able to deal against a paradigm? Is it able to change the theory? Of course not.
Support for atomic transactions is not provided in fact and this is in contrast with A of ACID.

Ending, I can suggest the interesting overview offered by Daniel Abadi, available here. Furthermore you may also check this cool link too.

Wednesday, 4 January 2012

Oracle Enterprise Manager 12c agent deploy problems?

I'm dealing with the upgrade to Enterprise Manager 12c (the cloud version....we really need the cloud version?).
Agent deploy is totally managed by enterprise manager console where, after the installation of patch #13503844 for bug #10044087, you will find the Upgrade Console under deployments tab.
A long job will:

  • Copy agent

  • Copy dependent plugins

  • Deploy agent

  • Configure agent


I have discovered a bug (Oracle support said it's internal bug 12911215 ... obviously not published) where if agent installation is done without sudo or powerbroker may fail.

The behaviour is that during job phase unzipAndDeploySoftware the command agentDeploy.sh fails signaling a mismatch between installation user and the owner of agent12g directory. This is a false alarm and the only workaround is to trick the agent installation making it to use the argument -ignoreDirPrereq.
To do it you have to connect to the enterprise manager database and issue the statement:


update PRE_UPGC_MASTER_INFO set PROPERTY_VALUE='-ignoreDirPrereq' where PROPERTY_NAME='deploy_param';
commit;