Ludovic Dessemon

New Oracle ADF Essentials - Free to develop and deploy

2012-09-25T16:05:51Z

Oracle ADF is a powerfull J2EE framework, and for adoption it's a very good news for learning that Oracle have just released a free release : Oracle ADF Essentials

Oracle ADF Esentials is free for developping and deploying ADF applications on certified Application Servers as Weblogic 11g, GlassFish 3.1, WebSphere 7 but it's also free on other J2EE servers.

Oracle ADF Essentials includes the following Oracle ADF components: Oracle ADF Faces Rich Client Components, Oracle ADF Controller, Oracle ADF Model and Oracle ADF Business Components.

The following functionality is not included in Oracle ADF Essentials, and requires the full Oracle ADF version – Oracle ADF Mobile, Oracle ADF Desktop Integration, Oracle ADF Security, The Oracle ADF Web service data control, Oracle ADF remote taskflows, Oracle ADF Business Component’s Service Interfaces, Oracle ADF Data Controls for BI, Essbase and BAM, Integration with Oracle Fusion Middleware features such as MDS, OPSS, OWSM, Enterprise Manager and MBeans, High Availability and Clustering.

GoldenGate : ORA-12899 : value too large for column

2010-09-16T12:55:00Z

Context

- Source database have a table with a column as "VARCHAR2(n BYTE)"
- Target database have a the same table with the same column but as VARCHAR2(n CHAR)

Workaround

- Oracle Note : ORA-12899 When The Semantics Of An Oracle Column Is Character [ID 965706.1]

GoldenGate / ORA-01843: not a valid month

2010-09-16T12:08:00Z

Problem description

2010-09-10 17:22:35 GGS WARNING 109 OCI Error ORA-01843: not a valid month (status = 1843), SQL <INSERT INTO "MYAPP_CH01"."PLSQL_PROFILER_UNITS" ("RUNID","UNIT_NUMBER","UNIT_TYPE","UNIT_OWNER","UNIT_NAME","UNIT_TIMESTAMP","TOTAL_TIME","SPARE1","SPARE2") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7>.

2010-09-10 17:22:35 GGS WARNING 218 Aborted grouped transaction on 'MYAPP_CH01.PLSQL_PROFILER_UNITS', Database error 1843 (ORA-01843: not a valid month).

2010-09-10 17:22:35 GGS WARNING 218 Repositioning to rba 85470607 in seqno 27.

2010-09-10 17:22:35 GGS WARNING 218 SQL error 1843 mapping MYAPP.PLSQL_PROFILER_UNITS to MYAPP_CH01.PLSQL_PROFILER_UNITS OCI Error ORA-01843: not a valid month (status = 1843), SQL <INSERT INTO "MYAPP_CH01"."PLSQL_PROFILER_UNITS" ("RUNID","UNIT_NUMBER","UNIT_TYPE","UNIT_OWNER","UNIT_NAME","UNIT_TIMESTAMP","TOTAL_TIME","SPARE1","SPARE2") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7>.

2010-09-10 17:22:35 GGS WARNING 218 Repositioning to rba 85470607 in seqno 27.
Source Context :
SourceModule : [er.main]
SourceID : [$Id: //depot/releases/OpenSys/v10.4.0/src/app/er/rep.c#41 $]
SourceFunction : [take_rep_err_action(short, int32_t, const char *, extr_ptr_def *, std_rec_hdr_def *, char *, file_def *, bool)]

SourceLine : [15165]
2010-09-10 17:22:35 GGS ERROR 218 Error mapping from MYAPP.PLSQL_PROFILER_UNITS to MYAPP_CH01.PLSQL_PROFILER_UNITS.

Diagnostic

tvdggdiag.sh -action DIAG -warning 5 -critical 30
(tvdggdiag.sh is a Trivadis Tools for GoldenGate)
...
2010/09/10 09:22:51.002.220 Insert Len 130 RBA 85470607
Name: MYAPP.PLSQL_PROFILER_UNITS
After Image: Partition 4 GU s
0000 0006 0000 0002 3437 0001 0005 0000 0001 3100 | ........47........1.
0200 1300 0000 0f41 4e4f 4e59 4d4f 5553 2042 4c4f | .......ANONYMOUS BLO
434b 0003 000f 0000 000b 3c61 6e6f 6e79 6d6f 7573 | CK........<anonymous
3e00 0400 0f00 0000 0b3c 616e 6f6e 796d 6f75 733e | >........<anonymous>
0005 0015 0000 3130 3031 2d30 2d2d 302d 3a30 203a | ......1001-0--0-:0 :
313a 3a31 3a00 0600 0500 0000 0130 0007 0004 ffff | 1::1:........0......
0000 0008 0004 ffff 0000 | ..........
...

* This dump displays the corresponding date causing the problem : 1001-0--0-:0

Solution

* Adding a rule in the parameter file of the replication process to convert the bad date to a date understood by Oracle :

MAP MYAPP.PLSQL_PROFILER_UNITS, TARGET MYAPP_CH01.PLSQL_PROFILER_UNITS , &
COLMAP ( RUNID = RUNID,
UNIT_NUMBER = UNIT_NUMBER,
UNIT_TYPE = UNIT_TYPE,
UNIT_OWNER = UNIT_OWNER,
UNIT_NAME = UNIT_NAME,
UNIT_TIMESTAMP = @IF ( @STRNCMP ( UNIT_TIMESTAMP, "1001-0", 6) = 0, "0001-01-01:00:00:00", UNIT_TIMESTAMP),
TOTAL_TIME = TOTAL_TIME,
SPARE1 = SPARE1,
SPARE2 = SPARE2
);

Oracle JDeveloper 11g (11.1.1.3.0) (Build 5660) available on OTN

2010-04-30T20:54:00Z

Oracle JDeveloper/ADF 11g Release 1 Patchset 2 (11.1.1.3.0) is available on OTN.

This release is primarily a bug-fix release and contains little of new features.

New features and bugs fixed list here .

A little new feature that I will appreciate is the support of Oracle 11gR2 for both online and offline database (database emulation).

But the most interesting feature is ADF Mobile Client, not to be confused with ADF Mobile Browser (development of mobile browser-based application). ADF Mobile supports development of on-device, disconnect capable mobile applications !!

ADF Mobile Client is available as a separate extension. In Jdeveloper, choose Help and then "Check for extensions", then next. Select "Official Oracle Extensions and updates". At this step you can select the "ADF Mobile Client" update.

Oracle JDeveloper 11g (11.1.1.2.0) on Mac OS X 10.6 Snow Leopard

2010-04-28T22:35:00Z

I'm using Oracle JDeveloper 11g (11.1.1.2.0) on my Mac Book Pro (OS X Snow Leopard 10.6.3).
It was necessary that I make some modifications to my OS X in order to execute JDev without issues.

The first thing to do is to check your JDK version installed on your OS X. The JDK 1.6 64 bits must be the default JVM.

Ludovic-DESSEMONs-MacBook-Pro:~ ludovic$ java -version
java version "1.6.0_17"
Java(TM) SE Runtime Environment (build 1.6.0_17-b04-248-10M3025)
Java HotSpot(TM) 64-Bit Server VM (build 14.3-b01-101, mixed mode)

If it is not the case, you must modify your java preference : Finder -> Applications -> Utilities -> Java Preferences

On the Applications section, move Java SE 6 64bits to the top.

After that, you can make the modifications to install/run JDev :

sudo mkdir -p /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Home/jre/lib
cd /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Home/jre/lib
sudo ln -s /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/classes/classes.jar rt.jar

Now, let's start the installation :

java -jar Downloads/jdevstudio11112install.jar

At this step, JDev is installed and can be running without issues :