Oracle SOA Suite 11g Certified Implementation Specialist

Last week I took the Oracle SOA Suite 11g Certified Implementation Specialist exam (1Z0-478) and passed.

Oracle Certified Specialist

Oracle Certified Specialist

I can now officially wear the badge of Oracle Certified Specialist.
So in the future you will also see some SOA related posts on this blog next to the APEX content.

Oracle Certified Specialist

Oracle Certified Specialist

Configure APEX in Oracle 11g

Application Express comes packaged with the OracleXE and Oracle11g database versions. In XE you can get started with APEX right away. In 11g the embedded PL/SQL gateway has to be configured first. These steps take you through the process of running the configuration script apxconf.sql.
Running this script enables you to configure the port for the Oracle XML DB HTTP server and to specify a password for the Oracle Application Express ADMIN account. Then you unlock the ANONYMOUS account.

Perform the following steps:

1. Open a terminal window and enter the following commands:

cd $ORACLE_HOME/apex
sqlplus sys/ as sysdba
@apxconf

2. Enter an administrator password for the Application Express Administrator account and press Enter.

3. Enter 8080 for the port for the XDB HTTP server and press Enter. This is also the default port. Change this number when another application (eg. Tomcat) is running on the same port. Keep in mind that ports below 1024 are not advisable when running Linux/Unix.
(The embedded PL/SQL gateway has now been configured.)

4. Unlock the anonymous user. From your terminal window, enter the following command:

ALTER USER ANONYMOUS ACCOUNT UNLOCK;

And now you’re all set to start developing APEX applications in 11g.

When you later want to change the port on which APEX is configured, you can run the following command:
dbms_xdb.sethttpport('9090');
If you want to check what the current port is, use the following query:
select dbms_xdb.gethttpport from dual;

For more information, visit the Oracle site at www.oracle.com

My Whitebooks

I work at the company Whitehorses. Each month we publish 2 so-called Whitebooks. These are articles written by us about things that are interesting for us and our customers.

In the past few years I’ve written some of these Whitebooks aswell. You can read them (in dutch) by following these links:

Kapow Mashup Server: content integratie met een knal
Java 1.5 New features
Oracle Forms JDAPI: bulk-wijzigingen vereenvoudigd
Kapow Mashup in de praktijk
Oracle 11g feature van de maand: Efficiëntere PLSQL code schrijven
RFID: risico’s en beveiligingsmaatregelen