额外补充:
解决无法通过网络和主机名访问APEX的问题:启动SQL*PLUS并以SYSDBA身份登录数据库,执行以下语句:
SQLexecute DBMS _ xdb。setlistener本地访问(l _ access=FALSE);4、设置后台运行参数
alter system set JOB _ QUEUE _ PROCESSES=2; Note: If the job queue process=0, subsequent positions will not run without job scheduling process.
第三,修改OracleXE监听器占用的1521和8080端口。安装Oracle XE时,有这样的提示。
1. destination folder: D:\oraclexe\ 2. Port of Oracle Database Listener: 1521 3. Port of "Oracle service for Microsoft transaction server": 2030 4. Port of HTTP listener: 8080 As you can see,
1 .开始. DBMS _ xdb。设置http端口(' 8080 ');3.DBMS _ xdb。setftp端口(“0”);4 .结束;5./再看看日志文件d:\ Oracle xe \ app \ Oracle \ product \ 10。2 .0 \ server \ config \ log \ postdbcreation。原木里,
1.SQL starts 2. DBMS _ xdb . sethttp port(' 8080 '); 3.DBMS _ xdb . setftp port(' 0 '); 4. End; 5. The/pl/SQL process has been successfully completed. It can be seen that Oracle XE uses it to set the port of Hyper Text Transport Protocol.
Step 1 start. DBMS _ xdb . sethttp port(' 8088 '); 3.DBMS _ xdb . setftp port(' 0 '); 4. End; 5./This sets the port to 8081.