We just did an upgrade to 4.2 on a new WebLogic server. We are using the latest Apex Listener as well.
The install seemed to go well (no errors during the DBA install) and we configured the Listener to connect to the database using the basic connection settings.
I was able to login to the Admin console and create my workspace and users, but I cannot even get the workspace login screen to appear.
All we get it is:
Error Error processing request.
ORA-01403: no data found
This is the only thing that shows up when going to the default Apex URL - http://hostname:port/apex/
I get the same ' no data found' message. I think I may know the problem...our DBA did not drop the old APEX version from the schema so right now we have both APEX_040100 and APEX_040200 on the same schema so maybe that is it?
I got the same issue when using embeded pl/sql mode
but it disapper after I did a complete remove.
suggest you use @apxremov.sql
drop user apex_040200 cascade;
drop user flows_files cascade; (seems it cause the issue, i remember i did not remove it in my failed instance which I just drop apex_030200 and apex_public_user)
drop user apex_public_user cascade;