Installing Oracle application express 4.2 in MS-Windows 7 Oracle Database server 10.2 (Fresh Install)

You must have installed Oracle Database server 10.2.0.3 or greater.

My ORACLE_HOME is c:\oracle\product\102r2

My ORACLE_SID= presales 

My Oracle Database version is 10.2.0.3

Let's start downloading the Oracle express software

- Download Oracle application express 4.2 from OTN

go to  http://www.oracle.com/technetwork/index.html

then click on Downloads menu

go to Application express under Databases Option

click on there and you will see the following screen. Then choose the Accept License agreement option

Then click on Download link whether you want all languages or English only.

Note: This is not a complete software distribution.

the system will ask you your otn user`s name and password

After this download finishes we can start the installation procedure as shown below.

Extract the apex_4.0.2.zip into ORACLE_HOME directory in my case c:\oracle\product\102r2

press   continue button

After  this extract we need to go to ORACLE_HOME directory using CMD window and run it as administrator user

go to Accesories and choose Command prompt, press right click and select Run as administrator

Then click on this option . You will see a black window

go to $ORACLE_HOME directory, in my computer is

cd      c:\oracle\product\102r2\apex

---------------------------------------

Define the environment variables

TNS_ADMIN, ORACLE_HOME and ORACLE_SID

Now load sqlplus as system administrator

sqlplus / as sysdba

if you get to log in to the database, the environment variables were well defined;

otherwise repeat their definition and try again.

 Drop apex_030200 user if exists.

SQL> drop  user apex_030200 cascade;

Then  install Oracle apex entering ..

SQL>@apexins SYSAUX SYSAUX TEMP /i/

Updating the Images Directory When Running the Embedded PL/SQL Gateway

The images in an Oracle XML DB HTTP Server with the embedded PL/SQL gateway installation are in the XML DB repository. Updating the images is accomplished by running the SQL Script apxldimg.sql located in the top level directory where the patch was unzipped.

Load sqlplus as system administrator again

sqlplus / as sysdba

SQL>@apxldimg.sql c:\oracle\product\102r2\apex 

Now run this script with one parameter the oracle home directory, in this
example is

c:\oracle\product\102r2

@apex_epg_config.sql c:\oracle\product\102r2

change the password

@apxchpwd.sql

@apxconf.sql

Enter the password you entered before

define the port you will use for working with apex

execute this script from

http://forums.oracle.com/forums/thread.jspa?threadID=641846

Pravednik

SET SERVEROUTPUT ON

DECLARE

l_configxml XMLTYPE;

l_value VARCHAR2(5) := 'true'; -- (true/false)

BEGIN

l_configxml := DBMS_XDB.cfg_get();

IF
l_configxml.existsNode('/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access')
= 0 THEN

-- Add missing element.

SELECT insertChildXML

(

l_configxml,

'/xdbconfig/sysconfig/protocolconfig/httpconfig',

'allow-repository-anonymous-access',

XMLType('<allow-repository-anonymous-access
xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd">' ||

l_value ||

'</allow-repository-anonymous-access>'),

'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"'

)

INTO l_configxml

FROM dual;

DBMS_OUTPUT.put_line('Element inserted.');

ELSE

-- Update existing element.

SELECT updateXML

(

DBMS_XDB.cfg_get(),

'/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access/text()',

l_value,

'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"'

)

INTO l_configxml

FROM dual;

DBMS_OUTPUT.put_line('Element updated.');

END IF;

DBMS_XDB.cfg_update(l_configxml);

DBMS_XDB.cfg_refresh;

END;

/

Now Unlock the anonymous account.

now go to http://localhost:8080/apex/apex

You are ready to use Oracle Apex

How to install Oracle Forms Builder 11g on Windows Vista 64 Sp1

Today I decided to start the migration process of all oracle forms applications that I have made during the last twenty years. The oldest forms version that I will have to start the migration process it will be 6i. So the first step will be to start the download process of the Oracle developer tools. In this case Oracle forms 11g.

Let's start dowloading the software from http://www.oracle.com/technetwork/indexes/downloads/index.html go down on the page and stop on Middleware section

choose Forms & Reports Services option, click on there and you will see







then choose Oracle Fusion Middleware Application Server 11g Release 1 (if you see its description says "Contains Forms 11.1.1 so this description gave me confidence to clicked on it.

This page is not clear in its message due to Oracle Forms Builder is not a deployment tool; as a result I decided to continue looking for a link of Oracle forms installation files and I found it "See Additional Development Tools"

I clicked on it and