Friday, August 26, 2011

APEX 4.1 was released & sample - install & configure with Embedded PL/SQL Gateway

Oracle Application Express Release 4.1 was released on August 24, 2011. You can download
and read more New Features in Release 4.1. Documentation and Tutorials
I would like to install NEW!!! with it (APEX 4.1) and configure Embedded PL/SQL Gateway (just test ... install and use it with Embedded PL/SQL Gateway. not connect to anywhere)
$ ls apex_4.1.zip
apex_4.1.zip
$ unzip apex_4.1.zip
$ cd apex
$ ls
apex_epg_config_core.sql apxchpwd.sql apxldimg.sql apxxemig.sql coreins.sql load_trans.sql
apex_epg_config.sql apxconf.sql apxremov.sql apxxepwd.sql devins.sql owa
apexins.sql apxdevrm.sql apxrtins.sql builder endins.sql utilities
apexvalidate.sql apxdvins.sql apxsqler.sql core images
- Installed APEX 4.1 Full development environment.
SQL> @apexins APEX APEX TEMP /i/
Session altered.

. ____ ____ ____ ____
. / \ | \ /\ / | /
.| || / / \ | | |
.| ||--- ---- | | |--
.| || \ / \ | | |
. \____/ | \/ \ \____ |____ \____
.
. Application Express (APEX) Installation.
..........................................
.
... Checking prerequisites
.
.
.
...Compiled 623 out of 2826 objects considered, 0 failed compilation 00:26:08
...247 packages
...239 package bodies
...436 tables
...12 functions
...19 procedures
...3 sequences
...438 triggers
...1238 indexes
...184 views
...0 libraries
...6 types
...0 type bodies
...0 operators
...0 index types
...Begin key object existence check 00:26:08
...Completed key object existence check 00:26:08
...Setting DBMS Registry 00:26:08
...Setting DBMS Registry Complete 00:26:08
...Exiting validate 00:26:08
timing for: Validate Installation
Elapsed: 00:10:47.71
timing for: Development Installation
Elapsed: 00:27:43.38
- Checked schemas in database.
SQL> select username from dba_users where CREATED > sysdate - 1/12;

USERNAME
------------------------------
APEX_PUBLIC_USER
APEX_040100
FLOWS_FILES
APEX_040100 - The account that owns the Oracle Application Express schema and metadata. FLOWS_FILES - The account that owns the Oracle Application Express uploaded files. APEX_PUBLIC_USER - The minimally privileged account used for Oracle Application Express configuration with Oracle Application Express Listener or Oracle HTTP Server and mod_plsql.

- Changed ADMIN password.
SQL> @apxchpwd
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
- Configured the Embedded PL/SQL Gateway (It's new Installation. So, used apex_epg_config.sql script)
SQL> @apex_epg_config /home/oracle

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Directory created.

PL/SQL procedure successfully completed.

Commit complete.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

timing for: Load Images
Elapsed: 00:02:54.75

Session altered.

PL/SQL procedure successfully completed.

Commit complete.

Session altered.

Directory dropped.
- Unlocked ANONYMOUS ACCOUNT
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

User altered.
- Check Oracle XML DB HTTP Server
SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

GETHTTPPORT
-----------
8080

SQL> !lsnrctl status | grep 8080
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linuxtest01)(PORT=8080))(Presentation=HTTP)(Session=RAW))
*** not run about access list, because this test (APEX) not connect to anywhere ***

- Tested http://IP_ADDRESS:8080/apex
A. admin page
B. Workspace page
If You are installing or upgrading it... Enjoy -)

No comments: