Enable Apex in Oracle 11g

Source: Internet
Author: User

The prerequisite for ORACLE's information lifecycle management tool ILMA is Apex.
Apex is installed by default in oracle 11g Release 2. It is not enabled after installation. You can use the following method to enable it.
SQL> show user
USER is "SYS"
SQL> spool apex
View the details of the installed Apex.
SQL> select * from dba_registry where comp_id = 'apex ';
 
APEX
Oracle Application Express
3.2.1.00.10 VALID 02-APR-2010 14:20:27
SERVER SYS
APEX_030200
VALIDATE_APEX
 
FLOWS_FILES
 
 
SQL>
SQL> @ % oracle_home % \ RDBMS \ ADMIN \ epgstat. SQL
+ -------------------------------------- +
| XDB protocol ports: |
| XDB is listening for the protocol |
| When the protocol port is non-zero. |
+ -------------------------------------- +
 
0 0
 
1 row selected.
 
+ --------------------------- +
| DAD virtual-path mappings |
+ --------------------------- +
 
/Apex/* APEX
 
1 row selected.
 
+ ---------------- +
| DAD attributes |
+ ---------------- +
 
APEX database-username ANONYMOUS
Default-page apex
Document-table-name wwv_flow_file_objects $
Request-validation-funct wwv_flow_epg_include_modules.authorize
Ion
 
Document-procedure wwv_flow_file_mgr.process_download
Nls-language american_america.al32utf8
Document-path docs
 
7 rows selected.
 
+ --------------------------------------------------- +
| DAD authorization: |
| To use static authentication of a user in a DAD, |
| The DAD must be authorized for the user. |
+ --------------------------------------------------- +
 
No rows selected
 
+ ---------------------------- +
| DAD authentication schemes |
+ ---------------------------- +
 
Apex anonymous Anonymous
 
1 row selected.
 
+ -------------------------------------------------------- +
| ANONYMOUS user status: |
| To use static or anonymous authentication in any DAD, |
| The ANONYMOUS account must be unlocked. |
+ -------------------------------------------------------- +
 
Anonymous expired & LOCKED
 
1 row selected.
 
+ ------------------------------------------------------------------- +
| ANONYMOUS access to XDB repository: |
| To allow public access to XDB repository without authentication, |
| ANONYMOUS access to the repository must be allowed. |
+ ------------------------------------------------------------------- +
 
False
 
1 row selected.
 
SQL>
View the port used by HTTP. 0 indicates that HTTP is not enabled.
SQL> select dbms_xdb.getHTTPPort from dual;
 
0
 
1 row selected.
 
SQL>
Set the port and view it.
SQL> begin
2 dbms_xdb.setHTTPPort (8080 );
3 commit;
4 end;
5/
 
PL/SQL procedure successfully completed.
 
SQL>
SQL> select dbms_xdb.getHTTPPort from dual;
 
8080
 
1 row selected.
Enable anonymous accounts.
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
Change Password:
SQL> @ % Oracle_home % \ 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.
 
User altered.
 
SQL>
SQL>
Modify access permissions:
SQL> begin
2 DBMS_XDB.SETLISTENERLOCALACCESS (FALSE );
3 end;
4/
 
PL/SQL procedure successfully completed.
Access Apex through the link below.
 
Http: /localhost: 8080/apex/apex_admin

From henrybai's column

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.