Oracle 11G first look
Oracle 11g is now available for download, but only for Linux. This blog posting covers practical issues we've seen since we started playing with it. If you are looking for marketing/new feature info you can find the PDF's here.
Installation
DB Upgrade Process
Process expects that your copy of 10.2.0 is patched to 10.2.0.3.0 to address a DST issue. If not you have to manually apply Oracle patches and jump through various other hoops. We encountered problems with the upgrade and eventually built an11g DB from scratch for our regression testing. This may a fundamental problem with the upgrade but is more likely to be because 'someone' unplugged our router during the upgrade process and left the DB in a mess.
Security
Passwords are now case sensitive. This will cause hours of fun.
11g JDBC Driver
JPublisher
The 11g version of JPublisher still creates .sqlj files but then deletes them after producing .java files. JPublisher still has all its other limitations.
OrindaBuild 11g Support
We have completed regression testing and the first build that supports 11g is available here. JDeveloper users can use this update center:
http://www.orindasoft.com/public/jdev103Center.xml
SQLDeveloper users can use this update center:
http://www.orindasoft.com/public/sqldevCenter.xml
Installation
- Download is a 1.8GB zip file.
- The Installer requires a minimum of 922MB of memory and large quantities of swap space. If you need more swap you can use 'swapadd'.
- Installer for X86 expects recent patches - don't think that your copy of RHEL4 will work without new rpm's.
- Oracle has changed the default location of the *dump and other configuration directories.
- Some minor Kernel tweaks required.
DB Upgrade Process
Process expects that your copy of 10.2.0 is patched to 10.2.0.3.0 to address a DST issue. If not you have to manually apply Oracle patches and jump through various other hoops. We encountered problems with the upgrade and eventually built an11g DB from scratch for our regression testing. This may a fundamental problem with the upgrade but is more likely to be because 'someone' unplugged our router during the upgrade process and left the DB in a mess.
Security
Passwords are now case sensitive. This will cause hours of fun.
11g JDBC Driver
- 1.4 and earlier versions of Java are not supported.
- 9.0.1 and prior versions of Oracle are not supported.
- 'oracle.jdbc.driver' is gone - but then it's been deprecated since 9i...
- We were expecting OracleConnection to be extended to prrovide support for Asynchronous Commit, but that didn't happen. We'll be adding our own support to OrindaBuild.
JPublisher
The 11g version of JPublisher still creates .sqlj files but then deletes them after producing .java files. JPublisher still has all its other limitations.
OrindaBuild 11g Support
We have completed regression testing and the first build that supports 11g is available here. JDeveloper users can use this update center:
http://www.orindasoft.com/public/jdev103Center.xml
SQLDeveloper users can use this update center:
http://www.orindasoft.com/public/sqldevCenter.xml
Labels: 11G, Java, JDBC, JDeveloper, Oracle, SQLDeveloper
