Hi All,
I am struggling getting APEX 18.1 (with ORDS 18.2) and Oracle database 18.3 (PDB).
(I felt I did something seriously wrong, as I can't even get the apex_version.txt. The same 404 error is reported)
Setup that need help: APEX 18.1 local install to PDB
Setup previously worked*: APEX 18.1 installed to PDB (18.1) with incompatible CDB (5.1)
(apex_to_common.sql error out as it was unable to get lock on SYS.STANDARD package, which makes me to remove APEX from CDB$ROOT)
Environment:
Oracle Linux 7.4 x64
Oracle database 18.3 (standalone, CDB)
ords-18.2.0.zip
apex_18.1.zip
(eventually will use tomcat to run the web server)
Steps to configure my system.
1. remove APEX from CDB (new step)
cd %ORACLE_HOME%\apex
sqlplus sys as sysdba
alter pluggable database open all;
@apxremov_con
2. Create PDB to host APEX schema
create pluggable database newspo admin user admin identified by ChangeME;
alter pluggable database all open;
alter session set container=NEWSPO;
create bigfile tablespace USERS datafile size 10m autoextend on maxsize unlimited;
alter database default tablespace USERS;
exit
3. Extract apex software and run installer
mkdir /u01/apex
unzip /home/oracle/apex-18.1.zip -d /u01/aepx
cd /u01/apex
sqlplus sys/ChangeME@localhost:1521/newspo.pojencrossing.local as sysdba
@apexins USERS USERS TEMP /i/
@apxchpwd.sql
@apex_rest_config.sql
-- check installation
SQL> select COMP_ID, VERSION, STATUS from CDB_REGISTRY where COMP_ID='APEX' order by CON_ID;
COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
APEX 18.1.0.00.45 VALID
select r.COMP_NAME, r.VERSION, c.NAME, c.CON_ID from CDB_REGISTRY r, V$CONTAINERS c where r.CON_ID=c.CON_ID and r.COMP_ID='APEX' order by CON_ID;
COMP_NAME VERSION NAME CON_ID
Oracle Application Express 18.1.0.00.45 NEWSPO 7
4. Prepare ords
mkdir /u01/ords
unzip /home/oracle/ords-18.2.0.zip -d /u01/ords
cd /u01/ords
mkdir /u01/ordrs/conf
[root@oel2 ords]# cat params/ords_params.properties
db.hostname=localhost
db.port=1521
db.servicename=newspo.pojencrossing.local
db.username=APEX_PUBLIC_USER
migrate.apex.rest=false
rest.services.apex.add=true
rest.services.ords.add=true
schema.tablespace.default=USERS
schema.tablespace.temp=TEMP
standalone.http.port=8080
standalone.static.images=/u01/apex/images
user.tablespace.default=USERS
user.tablespace.temp=TEMP
user.apex.listener.password=ChangeME
user.apex.restpublic.password=ChangeME
user.public.password=ChangeME
sys.user=SYS
sys.password=ChangeME
[root@oel2 ords]# java -jar ords.war configdir /u01/ords/conf
Sep 21, 2018 4:32:26 PM
INFO: Set config.dir to /u01/ords/conf in: /u01/ords/ords.war
[root@oel2 ords]# java -jar ords.war configdir /u01/ords/conf
Sep 21, 2018 4:32:26 PM
INFO: Set config.dir to /u01/ords/conf in: /u01/ords/ords.war
[root@oel2 ords]# java -jar ords.war
Retrieving information.
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]: <default, hit return>
Enter the database password for APEX_PUBLIC_USER: <ChangeME>
Confirm password: <ChangeME>
Sep 21, 2018 4:33:12 PM
INFO: Updated configurations: defaults, apex, apex_pu, apex_al, apex_rt
Installing Oracle REST Data Services version 18.2.0.r1831332
... Log file written to /root/ords_install_core_2018-09-21_163312_00943.log
... Verified database prerequisites
... Created Oracle REST Data Services schema
... Created Oracle REST Data Services proxy user
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to /root/ords_install_datamodel_2018-09-21_163321_00642.log
... Log file written to /root/ords_install_apex_2018-09-21_163323_00003.log
Completed installation for Oracle REST Data Services version 18.2.0.r1831332. Elapsed time: 00:00:11.288
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2
[root@oel2 ords]#
Up to this point, All steps (except 1, I used to install apex to CDB$ROOT) was identical to how I installed APEX previously. What am I missing?
Thanks,
P.Huang