How to install Apex
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\APEX\APEX_data.DBF'
SIZE 3g ;
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>
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
ALTER USER XDB ACCOUNT UNLOCK;
ALTER USER APEX_040200 ACCOUNT UNLOCK;
ALTER USER FLOWS_FILES ACCOUNT UNLOCK;
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://10.11.201.200:8080/apex
LOGIN like below
Workspace : internal
Username : ADMIN
Password : admin
change password .
The Following steps of configuring Application Server for Oracle Database 11gR2 will no be required.
#=====================================================================
Configuring Oracle Application Server 10gR2 for Oracle Database 10gR2
#=====================================================================
1.Install Oracle Application Server 10g R2.
2.Copy 'Images' folder to (Oracle Application Server Home) FRMHome_1/Apache/Apache from apex Installation folder
3. Change in FRHome_1\Apache\modplsql\conf\dads.conf Like Bellow
#================================================
# ================== # mod_plsql DAD Configuration File
# ============================================================================
# 1. Please refer to dads.README for a description of this file
# ============================================================================
# Note: This file should typically be included in your plsql.conf file with
# the "include" directive.
# Hint: You can look at some sample DADs in the dads.README file # ==========
# ==============For creating Image Directory=====
Alias /i/ "D:\oracle\FRHome_1\Apache\Apache\images/"
AddType text/xml xbl
AddType text/x-component htc
# =============For configuring Apex URL===========
<Location /hasan>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDatabasePassword abc123
PlsqlDatabaseConnectString 10.11.201.200:1521:hasan
PlsqlAuthenticationMode Basic
PlsqlDefaultPage apex
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDocumentPath docs
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
</Location>
#url would be like http://app_server_ip:port (default 7778)/hasan
#================================================
4. Login to Internal Workspace and change Admin Passwod
WorkSpace : internal
User : Admin
Pass : selected in apex installation step 7.
5. Create New Workspace and users as needed.
Now the system is ready for start application Development
===========================================================
===========================================================
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\APEX\APEX_data.DBF'
SIZE 3g ;
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>
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
ALTER USER XDB ACCOUNT UNLOCK;
ALTER USER APEX_040200 ACCOUNT UNLOCK;
ALTER USER FLOWS_FILES ACCOUNT UNLOCK;
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://10.11.201.200:8080/apex
LOGIN like below
Workspace : internal
Username : ADMIN
Password : admin
change password .
The Following steps of configuring Application Server for Oracle Database 11gR2 will no be required.
#=====================================================================
Configuring Oracle Application Server 10gR2 for Oracle Database 10gR2
#=====================================================================
1.Install Oracle Application Server 10g R2.
2.Copy 'Images' folder to (Oracle Application Server Home) FRMHome_1/Apache/Apache from apex Installation folder
3. Change in FRHome_1\Apache\modplsql\conf\dads.conf Like Bellow
#================================================
# ================== # mod_plsql DAD Configuration File
# ============================================================================
# 1. Please refer to dads.README for a description of this file
# ============================================================================
# Note: This file should typically be included in your plsql.conf file with
# the "include" directive.
# Hint: You can look at some sample DADs in the dads.README file # ==========
# ==============For creating Image Directory=====
Alias /i/ "D:\oracle\FRHome_1\Apache\Apache\images/"
AddType text/xml xbl
AddType text/x-component htc
# =============For configuring Apex URL===========
<Location /hasan>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDatabasePassword abc123
PlsqlDatabaseConnectString 10.11.201.200:1521:hasan
PlsqlAuthenticationMode Basic
PlsqlDefaultPage apex
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDocumentPath docs
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
</Location>
#url would be like http://app_server_ip:port (default 7778)/hasan
#================================================
4. Login to Internal Workspace and change Admin Passwod
WorkSpace : internal
User : Admin
Pass : selected in apex installation step 7.
5. Create New Workspace and users as needed.
Now the system is ready for start application Development
মন্তব্যসমূহ
একটি মন্তব্য পোস্ট করুন