Tuesday, April 19, 2011

Oracle apex 4.0 installation in oracle database 11g quickly

Oracle apex 4.0 installation in oracle database 11g quickly
===========================================================
===========================================================


installation of oracle Database 11gr2
======================================

you have moved the entire content of Components folder from File 2 (after
unzipping Database > Stage > Components: ) to Component folder of file 1
(after unzipping F:\Oracle 11g EE R2\Oracle\database\stage\Components).
Now you have got your complete Oracle Database 11g EE R2 Software in a single file.
Now open setup.exe from Oracle Database 11g EE R2/database folder and continue the
installation process.


installation of Apex 4.0 into 11g
===================================

1)After downloading unzip it in the following directory :

G:\app\apex_4_install\

its create a apex directory like :-

G:\app\apex_4_install\apex


2) Now You need to create a Tablespace for apex data as below :

SQL> CONN / AS SYSDBA

SQL> CREATE TABLESPACE APEX_DATA datafile
'E:\app\Administrator\oradata\Orcl\APEX_data.DBF'
SIZE 6g ;


3) install apex (@apexins) software in your created tablespace .


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator> G:

G:\cd G:\app\apex_4_install\apex

G:\app\apex_4_install\apex>
G:\app\apex_4_install\apex>
G:\app\apex_4_install\apex>
G:\app\apex_4_install\apex>sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Tue J

Copyright (c) 1982, 2007, Oracle. All rights rese

SQL>
SQL> conn / as sysdba
Connected.
SQL>
SQL> @apexins APEX_DATA APEX_DATA TEMP /i/

----its needs 25/30 minutes


4) again creating for image directory (@apxldimg.sql)


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator> G:

G:\cd G:\app\apex_4_install\apex

G:\app\apex_4_install\apex>
G:\app\apex_4_install\apex>
G:\app\apex_4_install\apex>
G:\app\apex_4_install\apex>sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Tue J

Copyright (c) 1982, 2007, Oracle. All rights rese

SQL>
SQL> conn / as sysdba
Connected.
SQL>
SQL> @apxldimg.sql

PL/SQL procedure successfully completed.

Enter value for 1: G:\app\apex_4_install
old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as 'G:\app\apex_4_install/apex/images'

Directory created.

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Commit complete.

timing for: Load Images
Elapsed: 00:03:26.51

Directory dropped.

SQL>

5) --for configuration ( @apxconf.sql)


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator> G:

G:\cd G:\app\apex_4_install\apex

G:\app\apex_4_install\apex>
G:\app\apex_4_install\apex>
G:\app\apex_4_install\apex>
G:\app\apex_4_install\apex>sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Tue J

Copyright (c) 1982, 2007, Oracle. All rights rese

SQL>
SQL> conn / as sysdba
Connected.
SQL>
SQL>
SQL>
SQL> @apxconf.sql

PORT
----------
8080

Enter values below for the XDB HTTP listener port and the password for the Appli
cation Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.


Enter a password for the ADMIN user []
Enter a port for the XDB HTTP listener [ 8080]
...changing HTTP Port

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Session altered.

...changing password for ADMIN

PL/SQL procedure successfully completed.


Commit complete.

SQL>



And then press enter and your installation in this stage is done.


6) But you need to unlock few of the schema that is related to Apex application.
Now unlock the schema as :

SQL>
SQL>
SQL> conn / as sysdba
Connected.
SQL>
SQL>
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

User altered.

SQL> ALTER USER XDB ACCOUNT UNLOCK;

User altered.

SQL> ALTER USER APEX_040000 ACCOUNT UNLOCK;

User altered.

SQL> ALTER USER FLOWS_FILES ACCOUNT UNLOCK;

User altered.

SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

User altered.

SQL>



7)Now is the time to open the apex application

Open a brower window and type the url as http:// < computername>:/apex

Example: If computer name is Halim_pc and port is 8080
then URL will be like

http://halim_pc:8080/apex

LOGIN like below

Workspace : internal
Username : ADMIN
Password : admin

change password .


cheers...................................

No comments: