Oracle 12c is out!

Oracle 12c Release 1 is released! You can download versions for Linux x86-64, Solaris Sparc64 and Solaris x86-64. No Windows yet…

UPDATE: 12c for Windows 64-bit is now also available!

The documentation can be downloaded here, or viewed online here.

Interesting is the list of new features. It’s a long list… Some things worth mentioning:

  • default values for columns can refer sequences (so no more triggers needed for this!)
  • VARCHAR2 increased to 32767 bytes
  • partial indexes for partitioned tables
  • concurrent statistics gathering (instead of serial…) – might speed up things if your processors can handle it
  • new is the “multitenant” architecture with pluggable databases (PDB’s) – might be great to refresh a pre-production environment!
  • move a data file online – data files can be moved online now?
  • Enterprise Manager dbconsole is now called Enterprise Manager Database Express
  • PGA size limit – you can now set a limit for the total amount of PGA that an instance can allocate – interesting, because we had some problems with this…
  • queryable patch inventory – you can now use SQL to query the data dictionary to see the installed patches (as replacement for the OPatch command lsinventory)
  • Oracle Flex ASM – the ASM instance can now run on a separate physical server than the one holding the database instances
  • advanced network compression – new parameters SQLNET_COMPRESSION and SQLNET.COMPRESSION_SCHEME_LIST – interesting…
  • and much more…

Now if only I could find some time to try it out! :-)



APEX 4.2.1 and APEX Listener 2.0 released!

First of all: a happy New Year to all my blog readers! I wish you an exciting 2013 with lots of interesting projects, no budget restraints and no unexpected downtime ;-)

When I returned from the Christmas holidays, I noticed that both Application Express 4.2.1 and the APEX Listener 2.0 have been released!

APEX 4.2.1 is actually the first patch set release for APEX 4.2. You can download the full release here (for new installations or upgrades) or, if you have a support contract, you can download the patch only (with number 14732511) here (for upgrades from version 4.2). There are a lot of bugs that have been fixed with this patch set (check for a full list here),  and also some new features have been introduced, for example the inclusion of AnyChart version 6 (which has even more HTML5 support). I’m happy with this patch set release, since this means it’s time to upgrade for us. We had some issues in the past after upgrading to a minor APEX release, so I learned to have patience and wait for the first patch set ;-)

Application Express Listener 2.0 was available as a Early Adaptor version for a while, but now the first production release is available. There are a lot of new features, like the ability to define multiple database connections, and more support for RESTful services. There are now also 2 ways to configure it: using SQL Developer (you need at least version 3.2.2) and using a new command-line interface. The web interface however has been removed, which I find a bit sad because I liked it :( We are using the APEX listener deployed to GlassFish, and I’m not sure if anything has changed in that matter. This is something I need to look into. I also wonder how you would upgrade from a previous version of the APEX Listener to this one. I suppose this involves some redeployment, and so also some (planned) downtime.



APEX 4.2 Early Adaptor available

I just saw on Dimitri Gielis’ blog that Oracle relased an early adaptor version of APEX 4.2. You can try it out yourself here (registration needed), and for a list of new features, see this page. Looks like this will be a big release, with lots of new stuff for mobile development and HTML5 support. A final release date for APEX 4.2 production is not yet available.


Update: it seems like they are having problems provisioning space for the workspaces and schemas. I got this error when trying to register:
ORA-20001: Execution of the statement was unsuccessful. ORA-01653: unable to extend table APEX_040200.WWV_FLOW_PAGE_PLUGS by 1024 in tablespace APEX_REL42

Return to application.

Language: en
Application Express


But now I can’t login because I never received a password… Hmmm…