Install apex on oracle 10.2.0.4 db new install


sudo su - oracle
. oraenv
<mydb>
cd $ORACLE_HOME
cp /software/oracle11gappserver/apex/apex_4.1.zip .
unzip apex_4.1.zip
cd apex
sqlplus / as sysdba
Verify the tablespace names
select tablespace_name from dba_tablespaces where tablespace_name in ('SYSAUX','TEMP');
@apexins sysaux sysaux temp /i/
@apxchpwd
<mypassword>
alter user apex_public_user account unlock;
alter user apex_public_user identified by <mypassword>;
alter user apex_public_user profile oracle_restricted;
exit
tar -czvf apex_images.tgz images
scp apex_images.tgz <username>@webserver:~
-- on web server
sudo su - root
cd /
mkdir /www/apex4.1images
chmod 775 /www/apex4.1images
cd /www/apex4.1images
cp /home/<username>/apex_images.tgz .
tar -xzvf apex_images.tgz
cd ..
chown <webuser>.<webgroup> /www/apex4.1images

sudo su - oracle
backup_confs
cd /app/oracle/product/ofm11g/<ofmname>/instances/<instancename>/config/OHS/ohs1/mod_plsql/
vi dads.conf

Alias /i/ "/www/apex4.1images/images/"

<Location /pls/apex>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure         wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString     host:port:service_name ServiceNameFormat
PlsqlNLSLanguage               AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode        Basic
SetHandler                     pls_handler
PlsqlDocumentTablename         wwv_flow_file_objects$
PlsqlDatabaseUsername          APEX_PUBLIC_USER
PlsqlDefaultPage               apex
PlsqlDatabasePassword          apex_public_user_password
PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
Allow from all
</Location>

Posted by at