I've been concentrating on PL/SQL over that time, but really need to start investing some time in APEX itself and so am keen to get it back up and running.
Basically, I upgraded APEX from 3 (which worked fine) to 4.2 and had (what seems to be a common problem) of the image file not being installed correctly. This is on an XP machine (which I use as a server).
I tried to rectify this image file problem and now cannot connect to APEX via a browser on either the 'server' nor a 'client' pc (ip:port/apex/apex_admin) and get 'This web page is not available'.
I can connect to the database with Oracle SQL Developer - no problem.
TNSLSNR has 3 services 'ready': XEXDB, XE_XPT and xe.
I am beginning to consider dropping the whole db and APEX and installing 4.2 directly (although I'm not even sure how to do a complete uninstall), although I wouldn't want to lose a lot of test schema's etc.
I have no idea how to start to analyse what the issue is - any help would be appreciated (I'm a developer - not a DBA).