安装
@APEXINS.SQL SYSAUX SYSAUX TEMP /i/
@apex_epg_config.sql e:\apex
Alter user anonymous account unlock;
@apxconf.sql
ORDS 安装
SQLPLUS:
EXEC DBMS_XDB.SETHTTPPORT(0);
@apex_rest_config.sql
DECLARE ACL_PATH VARCHAR2(4000); BEGIN SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL; IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_050100', 'connect') IS NULL THEN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH, 'APEX_050100', TRUE, 'connect'); END IF; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml', 'ACLthat lets power users to connect to everywhere', 'APEX_050100', TRUE, 'connect'); DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*'); END; |
COMMIT;
Cd apex/utilities/
Sqlplus command line: @ reset_image_prefix.sql , change /i/ to /i51/
复制 ords.war to webapp , and change name to apex51.war
复制 image dir to webapp , and change name to /i51/
Command line
Mkdir c:\devtools\apex_conf\5.1
// -- setup config dir to c:\devtools\apex_conf\5.1 and setup parameters ;
Cd tomcat/webapp/java –jar apex51.war setup
如果上述方法不能正常连接数据库,请逐一检查 -- c:\devtools\apex_conf\5.1 目录中的 4 个XML 文件中指定的数据库帐号以及密码是否正确,如果某个数据库帐号密码错误,请重新执行 java –jar apex51.war setup
变更 /i/ 的路径
Command line
SQLPLUS /NOLOG
CONN / AS SYSDBA;
@E:\apex\utilities\reset_image_prefix.sql
汉化:
Command line
set NLS_LANG=American_America.AL32UTF8
SQL line
ALTER SESSION SET CURRENT_SCHEMA = APEX_040200;
@d:\apex\builder\zh-cn\load-zn-cn.sql
国际化:
select wwv_flow_lang.system_message('PAGE') label from dual;