APEX Schema installaation

1) shared pool size should be more than 100 Mb.

if not follow the below process...

sho parameter shared

ALTER SYSTEM SET SHARED_POOL_SIZE='100M' SCOPE=spfile;

You should restart the db

startup;

2) XDB schema should be installed.

if not follow the below process....

connect to the db to  sys DBA

show user

user should be sys then

select comp_name "Component" from dba_registry;

if not exist in the repository

then execute the below script to install XDB

@?/rdbms/admin/catqm.sql password_NAME Tablespace_name temporarytablespace

select comp_name "Component" from dba_registry;

3) CONTEXT schema should be installed.

connect to the db to  sys DBA

show user

user should be sys then

select comp_name "Component" from dba_registry;

if not exist in the repository

then execute the below script to install CONTEXT

@?/ctx/admin/catctx.sql password_NAME Tablespace_name temporarytablespace

select comp_name "Component" from dba_registry;

If all the above have installed sucessfully then proceed with APEX installation

4) DoWNload the latest APEX version from the below link

http://www.oracle.com/technology/products/database/application_express/download.html

After that copy the downloaded file to server (Any location)

unzip apex_4.2.0.zip

it wil create one directory called APEX

go to APEX direcory

sqlplus sys/SYS_password as sysdba

@apexins  tablespace_apex tablespace_files tablespace_temp images

Example: @apexins SYSAUX SYSAUX TEMP /i/

it will create FLOWS_040000,FLOWS_FILES and APEX_PUBLIC_USER three schemas.

then check the invalid objects in db, aswell as in the newly created schemas and compile them if you found any invalid objects.

select comp_name "Component" from dba_registry;

then to change the ADMIN password exicute the below script by connecting to sysdba

go to APEX direcory

sqlplus sys/SYS_password as sysdba

@apxconf

it will promt to change the password as well as HTTP server port.

defualt the port wil be 8080.




Regards,
Trinadh