1 Reply Latest reply: Nov 24, 2012 6:52 AM by 975964 RSS

    XE broken after upgrde to Apex 4.2

    975964
      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