Hi,
I've spent the last two days trying to install a new instance of 12C (12.1.0.2.0) on a Windows 10.1 Pro machine. The installation goes without a hitch. I know this because I've installed and removed it at least a half dozen times or more by now.
The problem is that I want APEX 5 on it. Unless I'm misreading the 12C notes on this version, APEX 5 should be per-installed on the CDB. I can see the APEX 4.2 user (APEX_040200) but not the apex 5 one (APEX_050000). I've tried every option permutation I can think of with the installation but no APEX 5.
I've tried uninstalling APEX 4.2 and installing APEX 5 but instead of the usual 10 or 15 minutes of scrolling "PL/SQL done" type messages in the command window it completes in five seconds and comes up with seven messages similar to the following:
open2: IO::Pipe: Can't spawn-NOWAIT: No such file or directory at C:\Oracle12C\product\12.1.0\dbhome_2/rdbms/admin/catcon.pm line 470
This is the full output:
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Session altered.
FOO3
------------------------------
install2015-12-30_06-32-02.log
. ORACLE
.
. Application Express (APEX) Installation.
..........................................
.
... Checking prerequisites (MANUAL)
.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
... Prerequisite checks passed.
.
Performing installation in multitenant container database in the background.
The installation progress is spooled into apexins_cdb*.log files.
Please wait...
catcon: ALL catcon-related output will be written to coreins_catcon_9288.lst
catcon: See coreins*.log files for output generated by scripts
catcon: See coreins_*.lst files for spool files, if any
open2: IO::Pipe: Can't spawn-NOWAIT: No such file or directory at C:\Oracle12C\product\12.1.0\dbhome_2/rdbms/admin/catcon.pm line 470
catcon: ALL catcon-related output will be written to coreins6_catcon_14404.lst
catcon: See coreins6*.log files for output generated by scripts
catcon: See coreins6_*.lst files for spool files, if any
open2: IO::Pipe: Can't spawn-NOWAIT: No such file or directory at C:\Oracle12C\product\12.1.0\dbhome_2/rdbms/admin/catcon.pm line 470
catcon: ALL catcon-related output will be written to coreins2_catcon_13264.lst
catcon: See coreins2*.log files for output generated by scripts
catcon: See coreins2_*.lst files for spool files, if any
open2: IO::Pipe: Can't spawn-NOWAIT: No such file or directory at C:\Oracle12C\product\12.1.0\dbhome_2/rdbms/admin/catcon.pm line 470
catcon: ALL catcon-related output will be written to coreins7_catcon_13668.lst
catcon: See coreins7*.log files for output generated by scripts
catcon: See coreins7_*.lst files for spool files, if any
open2: IO::Pipe: Can't spawn-NOWAIT: No such file or directory at C:\Oracle12C\product\12.1.0\dbhome_2/rdbms/admin/catcon.pm line 470
catcon: ALL catcon-related output will be written to coreins3_catcon_1944.lst
catcon: See coreins3*.log files for output generated by scripts
catcon: See coreins3_*.lst files for spool files, if any
open2: IO::Pipe: Can't spawn-NOWAIT: No such file or directory at C:\Oracle12C\product\12.1.0\dbhome_2/rdbms/admin/catcon.pm line 470
catcon: ALL catcon-related output will be written to coreins4_catcon_9300.lst
catcon: See coreins4*.log files for output generated by scripts
catcon: See coreins4_*.lst files for spool files, if any
open2: IO::Pipe: Can't spawn-NOWAIT: No such file or directory at C:\Oracle12C\product\12.1.0\dbhome_2/rdbms/admin/catcon.pm line 470
catcon: ALL catcon-related output will be written to coreins5_catcon_14072.lst
catcon: See coreins5*.log files for output generated by scripts
catcon: See coreins5_*.lst files for spool files, if any
open2: IO::Pipe: Can't spawn-NOWAIT: No such file or directory at C:\Oracle12C\product\12.1.0\dbhome_2/rdbms/admin/catcon.pm line 470
Installation completed. Log files for each container can be found in:
apexins_cdb*.log
You can quickly scan for ORA errors or compilation errors by using a utility
like grep:
grep ORA- *.log
grep PLS- *.log
I'm running as administrator and I already have an 11g with APEX 5 installed. The is using MOD PL/SQL gateway. I could go back to 11g and install a clean instance to get around this. I only wan the set up to play with ORDS. It's not for production or anything, so it doesn't really matter. It's just irritating that I can't get it to work.
I'm led to believe the error is some sort of permissions issue but I've no idea what or how to fix it. No logs are produced, although given the message, it could be the writing of the logs that is causing the failure.
Before I either revert to 11g or go crazy and sit in the corner sucking my thumb and singing a song about a little pixie, has anyone any suggestions as to what I could try next? To say I'm sick of installing and uninstalling is an understatement.
I've no doubt that it's something simple I'm missing and it would not surprise in the least if I feel monumentally stupid if I ever get this fixed but I've run out of ideas.
Any suggestions will be gratefully appreciated,
Danny