This discussion is archived
1 Reply Latest reply: Nov 24, 2012 4:52 AM by 975964 RSS

XE broken after upgrde to Apex 4.2

975964 Newbie
Currently Being Moderated
I installed XE few days ago (on Windows 7 64-bit) and it seemed to work. I created an apex workspace, new user and navigated around; did not create any application.

Today I...
1. Upgraded APEX to 4.2
2. Executed apxldimg.sql
3. Executed apxchpwd.sql
4. Unlocked ananymous and APEX_PUBLIC_USER
5. dbms_xdb.gethttpport showed 8080

At this point, http://localhost:8080/apex/f?p=100 worked but nothing else (p=4950, p=4550, etc.)

I noticed only one error in log that said something could not be created.

I executed apxremov.sql and removed APEX_040000 schema. Reinstalled 4.2 and did all above steps. No errors in log this time.

Now nothing works (not even P=100!). I get this error: Error Error processing request.
ORA-01403: no data found

SQL Plus works fine. I can query random data. So does connection with SQL Developer.

LSNRCTL status shows this:
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 23-NOV-2012 22:18:36

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date 23-NOV-2012 21:45:57
Uptime 0 days 0 hr. 32 min. 39 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\SATABBARAJULT6\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SATABBARAJULT6)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SATABBARAJULT6)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully

Please advise.

Thanks.
Satya

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points