Hello All,
I am currently learning Oracle 12c R1 and wanted to install Apex on a PDB which created, however, I am encountering a strange problem and need some help. I have installed Apex in the CDB and it works fine. After creating a PDB (named pdbsv) I configured Apex for the PDB following the install instructions, particularly,
1. Ran apex_epg_config.sql with the ORACLE_HOME path.
2. Ran apxconf.sql and set the ADMIN password and port. The Apex in CDB is running on 8080 port so I configured this to be on port 8081.
3. ANONYMOUS use is unlocked.
4. Tested apex_admin on localhost:8081 and it was running. Created a workspace, schema etc. and tested a demo app which is working fine.
Now when I restarted the computer, it started the Oracle services and the Apex installation is up and running in CDB (8080 port). But trying the access the PDB installation (at port 8081) I find it is not running. Next, when I try to enable the port using
Login as sysdba
Alter session to set container to PDBSV and
Run: EXEC DBMS_XDB.SETHTTPPORT(8080);
It says, DBMS_XDB does not exist.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> DESC DBMS_XDB --> WORKS
SQL> alter session set container = pdbsv;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDBSV
SQL> desc dbms_xdb
ERROR:
ORA-04043: object dbms_xdb does not exist
I am using a Windows 64 bit system to test this and trying out completely offline.
So my questions are,
1. Is there any step I need to perform to "start" the Apex installation for the PDB?
2. Does it mean something went wrong during the installation and I need to re-install again? Which means I need to create the schemas and workspaces again. Could there be any step at the end of install that I missed?
3. Should I have removed the Apex installation from Root container?
4. If I should not install separately for a PDB and use the Apex installation from Root itself, how can I access my DB objects from a workspace created in Root Apex install?
Since I am beginning in 12c and Apex development, any help would be great! Thanks.