Startup APEX with Oracle 11g on AWS

In my previous post I completed creating an Oracle instance from public AMI on AWS. In a following post we configured OEM.
In this post I’ll start APEX on this instance. This instance of Oracle comes preinstalled with APEX.
First we have to reset the password of ADMIN and APEX_PUBLIC_USER and unlock the accounts. The process to reset these are described here.
For resetting password of ADMIN user we must use apxchpwd.sql. For APEX_PUBLIC_USER we can use ALTER USER command.
ADMIN user password change…
oracle@domU-12-31-39-00-64-53:[/u01/app/oracle/product/11.2.0/db_1/apex]
$ ls
apex_epg_config.sql       apexvalidate.sql  apxdbmig.sql  apxe101.sql  apxldimg.sql  apxremov.sql  apxxemig.sql  catapx.sql   devins.sql  load_trans.sql  utilities
apex_epg_config_core.sql  apxchpwd.sql      apxdevrm.sql  apxe102.sql  apxpatch.sql  apxrtins.sql  apxxepwd.sql  core         endins.sql  owa
apexins.sql               apxconf.sql       apxdvins.sql  apxe111.sql  apxrelod.sql  apxsqler.sql  builder       coreins.sql  images      patches
oracle@domU-12-31-39-00-64-53:[/u01/app/oracle/product/11.2.0/db_1/apex]
$ sqlplus / as sysdba;
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 14 20:27:12 2013
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @/u01/app/oracle/product/11.2.0/db_1/apex/apxchpwd.sql
Enter a value below for the password for the Application Express ADMIN user.
Enter a password for the ADMIN user              []
Session altered.
…changing password for ADMIN
PL/SQL procedure successfully completed.
Commit complete.
SQL>
APEX_PUBLIC_USER password change…
SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY ********;
User altered.
SQL>
Now we can access the APEX via web browser.
We’ll explore the APEX application development environment in the next post.
Till then BYE.

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s