Senthil Murugan's Blog

Home » Apex » APEX up and running in few steps!

APEX up and running in few steps!

Thanks to Joel (https://www.blogger.com/profile/01915290758512999160)

January 2017, I had a meeting with Dr. Sriram Birudavolu from Hyderabad.  He got my attention when he said he would love to start a 1000-person APEX Meetup group in Hyderabad (gotta love aggressive goals!).  However, he spent much of December and January just trying to figure out how to get APEX installed, configured and running.  He won’t profess to be an expert, but he’s exactly the type of person we want to enable.  He was correct in saying that if a potential customer struggles to get APEX installed, we’ve already lost.

Recently, Gerald Venzl asked for some assistance in creating a Docker image for APEX.  His goal was to create an APEX Docker image on top of the base Oracle Database Docker image.  He knows a lot about Docker, but he won’t claim to be an expert in APEX.  He wanted something that is scriptable and can result in APEX being installed, configured and up and running, along with ORDS, in as few steps as possible.  A “silent install”, if you please. This was the final bit of motivation I needed for this blog post and video.
While the installation documentation is complete and detailed, it’s also lengthy and sometimes confusing – especially for the new person.  Thus, I wanted to provide the simplest set of instructions with as few steps as possible to get APEX installed, configured and up and running, along with ORDS configured and up and running.  It can be done in two steps.  That’s right, two.  While I explain the individual steps executed from SQL*Plus in detail below, you can combine all of these SQL commands into a single SQL script.  I prefer the name “hookmeup.sql”.

1. Download and unzip APEX http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

2. cd to apex directory

3. Start SQL*Plus and ensure you are connecting to your PDB and not to the “root” of the container database (APEX should not be installed at all):

1

sqlplus sys/your_password@localhost/your_pdb as sysdba @apexins sysaux sysaux temp /i/

4. Unlock the APEX_PUBLIC_USER account and set the password:

1

alter user apex_public_user identified by oracle account unlock;

5. Create the APEX Instance Administration user and set the password:

1

2

3

4

5

6

7

8

9

10

11

begin

    apex_util.set_security_group_id( 10 );

    apex_util.create_user(

        p_user_name => ‘ADMIN’,

        p_email_address => ‘your@emailaddress.com’,

        p_web_password => ‘oracle’,

        p_developer_privs => ‘ADMIN’ );

    apex_util.set_security_group_id( null );

    commit;

end;

/

6. Run APEX REST configuration, and set the passwords of APEX_REST_PUBLIC_USER and APEX_LISTENER:

1

@apex_rest_config_core.sql oracle oracle

7. Create a network ACE for APEX (this is used when consuming Web services or sending outbound mail):

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

declare

    l_acl_path varchar2(4000);

    l_apex_schema varchar2(100);

begin

    for c1 in (select schema

                 from sys.dba_registry

                where comp_id = ‘APEX’) loop

        l_apex_schema := c1.schema;

    end loop;

    sys.dbms_network_acl_admin.append_host_ace(

        host => ‘*’,

        ace => xs$ace_type(privilege_list => xs$name_list(‘connect’),

        principal_name => l_apex_schema,

        principal_type => xs_acl.ptype_db));

    commit;

end;

/

8. Exit SQL*Plus.  Download and unzip ORDS http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html

9. cd to the directory where you unzipped ORDS (ensure that ords.war is in your current directory)

10. Copy the following into the file params/ords_params.properties and replace the contents with the text below (Note:  this is the file ords_params.properties in the “params” subdirectory – a subdirectory of your current working directory):

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

db.hostname=localhost

db.port=1521

# CUSTOMIZE db.servicename

db.servicename=your_pdb

db.username=APEX_PUBLIC_USER

db.password=oracle

migrate.apex.rest=false

plsql.gateway.add=true

rest.services.apex.add=true

rest.services.ords.add=true

schema.tablespace.default=SYSAUX

schema.tablespace.temp=TEMP

standalone.mode=TRUE

standalone.http.port=8080

standalone.use.https=false

# CUSTOMIZE standalone.static.images to point to the directory

# containing the images directory of your APEX distribution

standalone.static.images=/home/oracle/apex/images

user.apex.listener.password=oracle

user.apex.restpublic.password=oracle

user.public.password=oracle

user.tablespace.default=SYSAUX

user.tablespace.temp=TEMP

11. Configure and start ORDS in stand-alone mode.  You’ll be prompted for the SYS username and SYS password:

1

java -Dconfig.dir=/your_ords_configuration_directory -jar ords.war install simple –preserveParamFile

That’s it!!  You should now be able to go to http://localhost:8080/ords/, and login with:

Workspace: internal

Username:  admin

Password:  oracle
IMPORTANT, PLEASE READ:
By no means is this a recommended or secure installation.  These are minimal instructions to get someone from zero to up and running easily and quickly.  In a production instance, I would create different tablespaces for APEX and ORDS, I would use far more complex and distinct passwords, I would use HTTPS and not HTTP, I would deploy ORDS on a physically distinct server, and more.
The above steps were tested with Oracle Application Express 5.1.1.00.08, Oracle REST Data Services 3.0.9, and Oracle Database 12.2.0.1 running on Oracle Linux.

 

https://www.youtube.com/watch?v=amF01SpNLUo

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: