ORDS, SODA & JSON in the Database

Hi all ... Well yesterday I did a new installation of Oracle Express Edition 11g DB, which installed fine ... I then installed OC4J, and then finally installed APEX Listener 4.1 ...

Now, when I opened 127.0.0.1:8888/apex/listenerAdmin for the very first time .. I saw a page where I was to configure the connection .. At that point I was unable to get the 'Basic' connection working (I think the error was that the Listener was unable at connect to the database), and so I closed down that page ..

Now, one day later, when I open 127.0.0.1:8888/apex/listenerAdmin, I am asked for some login details ... I don't know what to put here to login .. In fact I have not successfully logged in here even once ..

However, some clues are as follows: Before installing APEX Listener, I defined some new roles and users from the OC4J web interface ... If I try logging in through any of these, I get the '403 Forbidden' error ... Otherwise, if I enter any other random login details, the same login box keeps popping up ..

So anyone know whats the problem here ? ... I suspect that no connect between APEX Listener and the Oracle DB is yet defined, which is why these problems are occuring ...

I tried 'undeploying' APEX listener from the OC4J web interface, and then again 'deploying' it, but the exact same thing is happening ..

Can anyone help me out here ?

EDIT:

I assume maybe I'm supposed to use the APEX_PUBLIC_USER account, which I configured in oracle before installing APEX (as per intructions in Oracle installation guides), but even when I try logging in through APEX_PUBLIC_USER, my login details are not accepted ... Also, I AM able to login into Oracle Database using APEX_PUBLIC_USER, but not in APEX Listener ... And since unlike what I described above, when I enter my APEX_PUBLIC_USER login details, the same login prompt keeps reappearing, meaning the login is not recognised at all ...

Edited by: user7366837 on Sep 9, 2011 3:39 AM