SQL> select name from v$database;
NAME
---------
TEST
SQL> select owa_util.get_version from dual;
GET_VERSION
--------------------------------------------------------------------------------
10.1.2.0.8
SQL> create tablespace APEX datafile
'/oradata/data04/APEX01.dbf' size 1000M autoextend on next 50M maxsize
5000M;
Tablespace created.
Change your working directory to /apex
Full
development environment
- Run apexins.sql passing the following
4
arguments in the order shown:
[orat@db01
apex]$ sqlplus "/as sysdba"
SQL*Plus:
Release 11.2.0.1.0 Production on Wed Aug 18 21:01:48 2010
Copyright
(c) 1982, 2009, Oracle. All rights
reserved.
Connected
to:
Oracle
Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With
the Partitioning, OLAP, Data Mining and Real Application Testing options
Execution of script will take 30-45
minutes.
SQL>
@apexins APEX APEX TEMP /i/
...Compiled 622 out of 2720 objects considered, 0 failed
compilation 22:49:32
...234 packages
...227 package bodies
...426 tables
...12 functions
...19 procedures
...3 sequences
...439 triggers
...1177 indexes
...175 views
...0 libraries
...4 types
...0 type bodies
...0 operators
...0 index types
...Begin key object existence check 22:49:32
...Completed key object existence check 22:49:32
...Setting DBMS Registry 22:49:32
...Setting DBMS Registry Complete 22:49:32
...Exiting validate 22:49:32
timing for: Validate Installation
Elapsed: 00:27:49.70
timing for: Development Installation
Elapsed: 00:35:32.03
Disconnected from Oracle Database 11g Enterprise Edition
Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real
Application Testing options
SQL> @apxchpwd.sql
Enter a value below for the password for the Application
Express ADMIN user.
Enter a password for the ADMIN user [] Admin – Apex
Session altered.
...changing password for ADMIN
PL/SQL procedure successfully completed.
Commit complete.
SQL> alter user apex_public_user account unlock;
User altered.
SQL> alter user apex_public_user identified by apex;
User altered.
SQL> select version_no from apex_release;
VERSION_NO
--------------------------------------------------------------------------------
4.0.2.00.06
[apexd@disco ~]$ cd /d01/apex
[apexd@disco apexd]$ ls
Disk1 Disk2 lost+found
ofm_webtier_linux_11.1.1.2.0_32_disk1_1of1.zip
[apexd@disco apexd]$ ls -ltr
total 1222688
drwxr-xr-x 6 apexd dba 4096 Nov 4 2009
Disk1
drwxrwxr-x 3 apexd dba 4096 Nov 4 2009
Disk2
drwx------ 2 root
root 16384 Nov 29 21:58
lost+found
-rw-r--r-- 1 apexd dba
1250778396 Nov 29 22:59 ofm_webtier_linux_11.1.1.2.0_32_disk1_1of1.zip
[apexd@disco apexd]$ cd Disk1
[apexd@disco Disk1]$ ls -ltr
total 28
-rwxrwxr-x 1 apexd
dba 11460 Oct 28 2009 runInstaller
drwxrwxr-x 3 apexd
dba 4096 Nov 4 2009
plugins
drwxrwxr-x 9 apexd
dba 4096 Nov 4 2009
doc
drwxrwxr-x 3 apexd
dba 4096 Nov 4 2009
install
drwxr-xr-x 12 apexd dba
4096 Nov 4 2009 stage
[apexd@disco Disk1]$ pwd
/d01/apex/Disk1
[apexd@disco Disk1]$
---Installation screens were removed due to low size image.
/d01/apex/product/Oracle_apex/ohs/images
Configure dads.conf to point to APEX schema /home/apexd/Oracle_HTTP/Oracle_DEV/instances/instance1/config/OHS/ohs1/mod_plsql
– dads.conf
Alias /i/
"/home/apexd/Oracle_HTTP/Oracle_DEV/ohs/images/"
<Location
/pls/apex>
Order deny,allow
PlsqlDocumentPath
docs
AllowOverride None
PlsqlDocumentProcedure
wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString db01.ven.net:1521:APEX ServiceNameFormat
PlsqlNLSLanguage
AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode
Basic
SetHandler
pls_handler
PlsqlDocumentTablename
wwv_flow_file_objects$
PlsqlDatabaseUsername
APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword
apexd
PlsqlRequestValidationFunction
wwv_flow_epg_include_modules.authorize
Allow from all
</Location>
Copy Images from DB node APEX folder, Edit dads.conf –
bounce opmnctl
URL for APEX
: http://disco.ven.net:8080/pls/apex/apex_admin
Change port
number :
/d01/apex/product/Oracle_apex/instances/instance1/config/OHS/ohs1/httpd.conf
Start/Stop
Scripts
[apexd@disco
bin]$ pwd
/d01/apex/product/Oracle_apex/instances/instance1/bin
[apexd@disco
bin]$ ./opmnctl status
Processes in
Instance:TEST
---------------------------------+--------------------+---------+---------
ias-component | process-type |
pid | status
---------------------------------+--------------------+---------+---------
TEST |
WebCache-admin | 32114 | Alive
TEST | WebCache |
32115 | Alive
ohs1 | OHS | 32113 | Alive
No comments:
Post a Comment