Configure Oracle Apex in 11g on SUSE Linux Enterprise Server


Today I configured Oracle APEX in Oracle 11g Release 1 on SUSE Linux Enterprise Server 11. I did not realize that Oracle APEX is a part of the 11g standard database components.

So I just follow simple steps to configure Oracle APEX. 
APEX application can access either the embedded PL/SQL gateway or Oracle HTTP server. For simplicity I chose the embedded PL/SQL gateway. By using the embedded PL/SQL gateway, it will run using the Oracle XML DB HTTP server which is already in Oracle database, so there is no need to install a separate HTTP server.

Step 1

To Configure the embedded PL/SQL gateway go to the $ORACLE_HOME/apex directory. In my case apex directory in the given below path

/opt/oracle/OraDB11g/apex

Step 2

Use SQL/Plus to connect as SYS to 11g database where APEX is installed. After connection type @apxconf and press enter as shown in the screenshot.



Create password for admin user


Step 3

Unlock the ANONYMOUS account.


Step 4

Enable Oracle XML DB HTTP server




Step 5

Oracle APEX is ready to access

http://host:port/apex
http://host:port/apex/apex_admin — for admin page


Comments

  1. UnknownAugust 20, 2012 at 9:19 AM

    thanks, It's a very helpfull but, what about the '/i/' directory where the images are suppossed to be??
    I can access the apex start page but its blank, I bet its because no images directory has setup by the moment..

    thanks

    ReplyDelete

Post a Comment

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

Image
Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.
Read more

How to Create Packages in Oracle Database using TOAD for Oracle

Image
What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package Body Package body is used to provide implementation for the subprograms, queries for the cursors declared in the package specification.
Read more

How to create a Simple Scheduler Job in Oracle Database using Toad

Image
Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. It contains the name of the program (a procedure or an executable, the type of the program (pl/sql block, shell script etc). A schedule specifies when and how many times a job is executed. 1. Login to the database using Toad, and create a Scheduler Job as follows;
Read more