Invalid login credentials for APEX though I can connect with SQL PLUS
I have Oracle 11g on a Win7 pro machine and it was working fine. Yesterday it no longer allowed me to login to APEX, giving the error invalid login credentials.
I did not change my password but it no longer works, yet the same password and userid DO WORK if I do an SQL connect .
I went back into "getting started" and logged in as System and then created a new APEX Workspace and when I login with the new user, the object browser does not see any of the tables or SQL I had written. I figured it was because the schema is different but but even listing tables all_users and all_objects I see nothing from the schema I was locked out of.
I relogged in from sqlplus and my tables are still there but I cannot access them anyway from APEX.
When I created the new workplace and user I allowed it to see all schemas, but it seems like the schema I need and every object in it is not available in APEX yet they are still there in sqlplus. Can anyone help?
I have read every posting I could find about APEX problems but have found nothing to help at all.
Thank you in advance.
Steve