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- Installed APEX 4.1 Full development environment.
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
SQL> @apexins APEX APEX TEMP /i/- Checked schemas in database.
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
SQL> select username from dba_users where CREATED > sysdate - 1/12;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.
USERNAME
------------------------------
APEX_PUBLIC_USER
APEX_040100
FLOWS_FILES
- Changed ADMIN password.
SQL> @apxchpwd- Configured the Embedded PL/SQL Gateway (It's new Installation. So, used apex_epg_config.sql script)
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_epg_config /home/oracle- Unlocked ANONYMOUS ACCOUNT
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.
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;- Check Oracle XML DB HTTP Server
User altered.
SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;*** not run about access list, because this test (APEX) not connect to anywhere ***
GETHTTPPORT
-----------
8080
SQL> !lsnrctl status | grep 8080
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linuxtest01)(PORT=8080))(Presentation=HTTP)(Session=RAW))
- Tested http://IP_ADDRESS:8080/apex
A. admin page
B. Workspace page
If You are installing or upgrading it... Enjoy -)
No comments:
Post a Comment