AskTom

0. APEX in installed and running on database tier
How to install APEX
1.Unlock APEX_PUBLIC_USER Account & change password
- Connect to db as sys user
- alter user apex_public_user account unlock;
- alter user apex_public_user identified by NEW_PASSWORD;

2. Configure HTTP Server
2.0: Install Oracle HTTP Server ( OHS_SERVER )
Oracle HTTP Server (Apache 2.0) (10.1.3.3.0) for Linux x86

The following information is available in:
/opt/ohs/10133/install/setupinfo.txt
—————————————–
Use the following URL to access the Oracle HTTP Server and the Welcome Page:
http://apex.myweb.cz:7777

2.1: Copy APEX Images
- Copy images from database tier to middle tier
tar cvf images.tar images/
unpack on new server

2.2: Adding DAD entry to connect to APEX
Alias /i/ “/opt/ohs/10133/ohs/images/”
AddType text/xml xbl
AddType text/x-component htc

<Location /pls/apex>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString hostname.domainname:db_port:SID 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>

Make sure these values are properly set before saving this file.

- IMAGE_LOC Value
- hostname:port:SID => eg: localhost:1521:ORCL
- APEX_PASSWORD => eg: password_you_had_selected_on_step_1

3: Start HTTP Server

/opt/ohs/10133/opmn/bin/opmnctl startproc ias-component=HTTP_Server

4: Access the admin page of APEX

http://hostname:port/pls/apex/apex_admin
http://apex.myweb.cz:7777/pls/apex

Regards,

Tom

If you are using APEX, then you probably know the difference between Authentication and Authorization but I’ll give a quick example anyway.  The simplest way to think about it is that Authentication controls access to your program, and Authorization controls the resources in your program.  So if you were trying to make a distinction between an administrator and a user, that would be done at the Authorization level.  Since I couldn’t set up two types of Authentication, I decided I would use LDAP to authenticate, and would handle access from the Oracle account at the authorization level.
First, LDAP.  In your APEX program, go to Shared Components -> Authentication Schemes.  You may have already set up some basic security automatically when you create the application, so click on the one marked as current.  If not, just hit Create and go through the wizard.
When you have chosen or created an authentication scheme, go to the Login Processing tab and set it up similar to the following…

Obviously the host, port, and dn string will need to be changed to your settings, however note the %LDAP_USER% string which containts the user name of the attempted login.  You’ll need to use that.  And if you need to test your settings, click the LDAP Test Tool.
For our Oracle database, let’s go back to the Shared Components but go to Authorization Schemes this time.  From there, Create your scheme.
Name it whatever you want, but keep it in mind for later.

It’s all covered nicely in a book titled “Pro Oracle Application Express”

Regards,

Tom

Here is the SELECT:

SQL> SELECT sum(bytes)/1048576 Megs, segment_name
FROM dba_extents
WHERE segment_name = ‘&enter_object_name’
GROUP BY segment_name
/

Enter value for enter_object_name: I_T_MARTIN_01
old   3: WHERE segment_name = ‘&enter_object_name’
new   3: WHERE segment_name = ‘I_T_MARTIN_01′

MEGS
———-
SEGMENT_NAME
——————————————————————————–
264
I_T_MARTIN_01

Regards,

Tom