当前位置:  数据库>oracle

启用Oracle 11g中的Apex

    来源: 互联网  发布时间:2017-04-19

    本文导语: Oracle 的信息生命周期管理工具ILMA的使用前提是Apex.Apex在oracle 11g Release 2版本中是默认安装的。但安装后没有启用。可以使用下面方法启用它。 SQL> show userUSER is "SYS"SQL> spool apex查看安装的Apex详情。SQL> select * from dba_registry w...

Oracle信息生命周期管理工具ILMA的使用前提是Apex.
Apex在oracle 11g Release 2版本中是默认安装的。但安装后没有启用。可以使用下面方法启用它。
SQL> show user
USER is "SYS"
SQL> spool apex
查看安装的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%RDBMSADMINepgstat.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 spool iis7站长之家 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>
查看HTTP所使用的port,其中0表示没有开启。
SQL> select dbms_xdb.getHTTPPort from dual;

          0

1 row selected.

SQL>
设置port并查看。
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.
启用匿名帐号
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
修改密码
SQL> @%Oracle_home%apexapxchpwd.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>
修改访问权限
SQL> begin
  2    DBMS_XDB.SETLISTENERLOCALACCESS (FALSE);
  3  end;
  4  /





PL/SQL procedure successfully completed.
通过下面链接访问Apex.

http://localhost:8080/apex/apex_admin


    
 
 

您可能感兴趣的文章:

 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • Apache如何启用gzip压缩
  • sql server 禁用与启用触发器的语句
  • IE(Internet Explorer)浏览器中启用cookie的步骤
  • kdevelop3 如何启用代码帮助(code complete)功能?
  • CentOS 6内核升级:下载编译启用新内核版本详细过程
  • android ListView的右边滚动滑块启用方法 分享
  • 在 Windows Sever 2003 里面怎么启用 3D 加速
  • UNIX如何启用/禁用网卡?
  • linux系统下怎么控制外设(光驱、U盘、串口等)端口的禁用和启用?
  • 如何让非root用户启用小于1024号的端口?
  • 新手提问:RHLinux9.0下如何启用telnet?
  • sqlserver 禁用触发器和启用触发器的语句
  • 如何让gnome自带的终端启用语法高亮
  • 如何在fedora6启用apache服务?
  • 如何默认启用vim而不是vi
  • 关于RHEL 5如何启用3D桌面
  • 请问qt启用两个QThread线程可不可以运行不同的程序
  • 如何linux 程序中启用其他进程,非阻塞,非popen
  • 是不是这样关闭和启用NAGLE?
  • ubuntu11.04启用unity,经常假死
  • ubuntu11.04,无线网络已禁用,怎么启用?


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,