Missing Applcation 4500
I-PAug 24 2009 — edited Aug 24 2009I 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 .