Archive for September, 2007

Compile all your forms at once

Friday, September 28th, 2007

This is the script I use to compile all forms in a directory using ifcmp90.

set ORACLE_HOME=c:oracle10gdevsuite
for %%p in (”*.fmb”) do c:oracle10gdevsuitebinifcmp90 module=.%%p module_type=form userid=/

@ batch=YES
don’t forget the ORACLE_HOME bit, if it is not set correctly you might end up with an ORA-12538: No such protocol adapter

ora-12538

Friday, September 28th, 2007

I have this script that uses ifcmp90 to compile all forms in one directory. I sometimes need it when I change a library, but lately it has been failing me with an ORA-12538: No such protocol adapter. I had been fiddling around with my oracle homes and apparently I broke this.

It turned out that the error occurs when you have your oracle_home environment variable not set correctly. It is usually set to the home of the database but for ifcmp90 i needed to set it to the devsuite home.
This solved it

iAS 10.1.3.0

Friday, September 28th, 2007

If you try to log into iAS 10.1.3.0 and you get the following error:

This OC4J is configured to make JMX connections via RMIS and fall back to RMI if the RMIS port is not configured. The RMIS connection on the OC4J instance home on Application Server iashome.asdes is configured but a connection could
not be established. The JMX proto is specified by the oracle.oc4j.jmx.internal.connection.proto property in opmn.xml

go to metalink note 365062.1 if you are running iAS 10.1.3.0 and db 10.2.0.1. on the same machine. It worked for me

Or install 10.1.3.1, it’s alot better….