Tips After installation Oracle Forms 11gr2 on OEL 6

Some problems you can find are:

  • “FRM-10142- The HTTP listener is not working in mypc at port 9001. Please start the Listener or check your runtime setting”

Remember you must have WebLogic running:
/WLS_PATH/user_projects/domains/base_domain/startWebLogic.sh

  • To configure the browser you can set your prefered browser in Edit –> Preferences–>Runtime –>Web Browser Location   /usr/bin/firefox
  • For running forms 11g in browser you need a JRE plugin.If you have a newer version than 1.6.0_12 you can change the jpi version in formsweb.cfg file

Find the jpi-version reference:
jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_12
and remove version:
jpi_mimetype=application/x-java-applet

Forms Builder doesn´t launch on OEL 6

When attempting to launch Forms Builder using the command frmbld.sh in $INSTANCE_HOME/bin/, the following error message can be displayed:

error while loading shared libraries: libXm.so.3: cannot open shared object file: No such file or directory

check that you have installed openmotif and openmotif22

yum install openmotif -y
yum install openmotif22 -y

Install Oracle Forms 11gr2 on OEL 6

The aim of this post isn´t write a complete guide about the installation process.
There are a good tutorials in internet and oficial doc is very clear
I will write about some important things that you should keep in mind before the installation.

  • Install a correct JDK

7.0.13 is a good option.OpenJDK can be good for Weblogic but not for Forms

rpm -ivh jdk-7u13-linux-x64.rpm

Register your JDKs for alternatives and change the current java version

/usr/sbin/alternatives --install /usr/bin/java java /usr/java/jdk1.7.0_71/bin/java 17071
# /usr/sbin/alternatives --config java
  • Configure your etc/hosts with your correct name
10.0.2.15   forms forms.formsdomain
127.0.0.1   forms forms.formsdomain

if you want to know the domain and host name you can try run this comannd

echo `uname -n`.`awk '/^domain/ {print $2}' /etc/resolv.conf`

It´s important have a IP and not init the installation without IP

  • Increase the tmp size in /etc/fstab until 6GB
tmpfs /tmp tmpfs nodev,nosuid,size=6000m

 

ADF with WebSockets Tips.

In these days everybody talk about the WebSokects  integration with ADF.
In this post I will give some advices about this integration.

  • You can use WebSockets in combination with Database Change Notification(DCN)
    • In this case remember you need a grant grant change notification to hr
  • In DCN You need to explicitly unregister a registration to delete it from the server and release the resources in the driver. You can unregister a registration using a connection different from one that was used for creating it
  • With DCN you could have problem with some column types.
    • ORA-29977: Unsupported column type for query registration in guaranteed mode
    • Check if in your query you have a blob,clob or xmlType column
  • Websockets have a default timeout in 30s
  • WebSocketAdapter now is deprecated, here you have oficial doc to build WebSockets in weblogic.

With WebSockets you can build something like that

websockets

 

LOV with create option

Sometime clients demands this feaute and I think is unknown funcionality

The LOV component  have a property called CreatePopupId where  you can indicate the popup that will use for create new rows.

Then above of the  table result appear a buton to open the new popup to create rows.

Extra Links:

http://www.oracle.com/webfolder/ux/middleware/richclient/guidelines5/lov.html#create

MongoDB and ADF

This week I have been learning MongoDb and I’m looking for some ways to connect MongoDB with ADF Faces.
We can use Bean or EJB DataControl.
Another way could be https://spring.io/guides/gs/accessing-data-mongodb/ in combination with ADF Faces

Here there are another way http://weblog.singhpora.com/2013/12/adf-ui-with-mongodb-for-persistence.html

And remember that in Oracle you have another No SQL database http://www.oracle.com/technetwork/database/nosqldb/downloads/default-495311.html

ADF 12c. It´s time to migrate to 12c

The last release of ADF 12.2.1 has a lot of improvments and news.I think now we have a stable release and is time to migrate o to begin a new project.

  • JDK8
  • JSF2.2
  • A lot of new Components
  • GIT Integration
  • Maven Integration with online maven repository
  • Support to REST Datacontrols
  • New Alta Skin
  • Explore Dependencies,af:target,…

Oracle Applications Cloud User Experience Rapid Development Kit

The Oracle Applications Cloud User Experience Rapid Development Kit (RDK) is Development Kit with a set of funcionalities to build application with a oracle cloud style and modern look and feel.

innovation-165  RDK is a set of free resources that will help you learn faster, design simpler and build better.

Is a good tool to learn how to build user friendly applications and get ideas

Isn’t necessary deploy this aplications in cloud, you can use this guidelines for your stand alone applications

Install FMW Test environment

  1. install OEL.
  2. install JDK
    • rpm -ivh jdkname.rpm
  3. install JDeveloper
    • before install JDev
      • yum install glibc.i686
      • yum install libXtst-devel libXrender-devel kernel-devel libXtst-devel.i686
    • chmod +x jdevname.bin
  4. install oracle XE
  5. install WLS
    • $ unzip fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip
    • $ $JAVA_HOME/bin/java -jar fmw_12.2.1.0.0_infrastructure.jar
  6. Rcu for ADF development
    • $ORACLE_HOME/oracle_common/bin/rcu
  7. Create domain
    • $ORACLE_HOME/oracle_common/common/bin/config.sh
    • check Oracle JRF

Pack and unpack WebLogic Domains

This commands can be useful when you need pass a domain between node.

pack -domain=<path>\SourceDomain -template=<path>\domain.jar -template_name="Default Domain"
unpack -template=<path>\domain.jar -domain=<path>\TargetDomain

These shell scripts are available in

  • $MW_HOME/wlserver_[ver]/common/bin

More info