APEX

I have two test Databases D1 abd D2 ; both are identical clones of a production database.

Both had APEX 3.0 and were upraded to Apex 3.2 . ( ie removed Apex 3.0 and installed Apex 3.2 ).

Both D1 and d2 had no errors in the log after running @apexins.sql .
I am able to get both admin and workspace admin screens on D1 but not on D2.

On D2 both admin and logon screens ( ie http://....../pls/apex/ and http://...../pls/apex/apex_admin ) complain about Application 4500 not found).

I ran the following on both databases :

alter session set current_schema=apex_030200
/
select id from wwv_flows where security_group_id=10
/
select id||':'||name||':'||security_group_id from wwv_flows where id between 4000 and 4999
/
SQL> select id||':'||name||':'||security_group_id from wwv_flows where id betwee
n 4000 and 4999
2 /

The database that works fine ( D1) returned the following results :

ID||':'||NAME||':'||SECURITY_GROUP_ID
--------------------------------------------------------------------------------

4000:APEX - Application Builder:10
4050:APEX - Internal Administration:10
4155:Scheme Authentication Login:10
4300:APEX - Data Workshop:10
4350:APEX - Workspace Admin:10
4400:APEX - Application Migration:10
4411:APEX - System Messages:10
4500:APEX - SQL Workshop:10
4550:APEX - Login:10
4700:APEX - New Service Signup:10

10 rows selected.


The one that is having issues ( D2) retiurns the following results :

ID||':'||NAME||':'||SECURITY_GROUP_ID
--------------------------------------------------------------------------------

4155:Scheme Authentication Login:10
4411:APEX - System Messages:10


How do I fix this ? What am I missing ?


Thanks for any insight .