4 Replies Latest reply: May 24, 2013 2:41 PM by EdStevens RSS

    ORA-01403: no data found when using the Get Started WIth Oracle Link

    1010878
      When I click on the desktop Get Started with Oracle link (http://127.0.0.1:8080/apex/f?p=4950), my IE browser opens with the ORA-0143: no data found error.

      I'd like to once again be able to open the Oracle 11g XE database GUI front end. I just downloaded the 11G XE database and installed it on my Windows 8 64 bit system. I reinstalled the database 3X, all with the same result, which is that this linked initially worked after installation, then stopped working when I installed the latest version of Apex (4.2) from the Oracle website.

      I understand this database is not supported on 64 bit machines, however, I can now successfully log into Apex (http://localhost:8080/apex/f?p=4550:10:15747627858344). I also can open SQL Developer (which I installed immediately after 11G) and examine all the database objects, so I'm hopeful that I can also regain the functionality of the 11G GUI front end.

      In addition to uninstalling and reinstalling all of the above 3X, I have already unsuccessfully performed the following actions (separately and together):
      * replaced 127.0.0.1 with localhost in the above Oracle link (resulting in the link http://localhost:8080/apex/f?p=4950) which also gives me the no data found error
      * replaced "Mike-PC" with localhost in C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\listener.ora (then rebooted my system, and attempted the link directly above this)

      I am a newbie in the Oracle world and do not have strong network skills (which I'm sure you have deduced by now). Therefore I would appreciate any solution that will get me back into the Oracle 11G GUI front end.

      Thanks.
      - Mike
        • 1. Re: ORA-01403: no data found when using the Get Started WIth Oracle Link
          sb92075
          1007875 wrote:
          When I click on the desktop Get Started with Oracle link (http://127.0.0.1:8080/apex/f?p=4950), my IE browser opens with the ORA-0143: no data found error.

          I'd like to once again be able to open the Oracle 11g XE database GUI front end. I just downloaded the 11G XE database and installed it on my Windows 8 64 bit system.
          No Oracle version is currently certified on any Windows 8 Edition.

          Consider installing VirtualBox & then load a pre-configured OS that contains Oracle DB installation
          • 2. Re: ORA-01403: no data found when using the Get Started WIth Oracle Link
            1010878
            I assume you're referring to loading a Linux OS since no Oracle version is currently certified on a Windows 64 bit platform. Is that true or did you have another specific recommendation in mind?

            (FYI: the database is running now; I can connect to it with SQLPlus or SQL Developer, and the Start link works until the installation of APEX 4.2) It's just a matter of me connecting to the GUI front end.
            • 3. Re: ORA-01403: no data found when using the Get Started WIth Oracle Link
              sb92075
              1007875 wrote:
              I assume you're referring to loading a Linux OS since no Oracle version is currently certified on a Windows 64 bit platform. Is that true or did you have another specific recommendation in mind?
              Yes, VM is a Linux OS.
              http://www.oracle.com/technetwork/community/developer-vm/index.html

              (FYI: the database is running now; I can connect to it with SQLPlus or SQL Developer, and the Start link works until the installation of APEX 4.2) It's just a matter of me connecting to the GUI front end.
              • 4. Re: ORA-01403: no data found when using the Get Started WIth Oracle Link
                EdStevens
                1007875 wrote:
                I assume you're referring to loading a Linux OS since no Oracle version is currently certified on a Windows 64 bit platform.
                where did you get the idea that "no Oracle version is currently certified on a Windows 64 bit platform."

                No oracle version is certified for Windows 8. That is a version issue, not a 32 vs 64 bit issue.

                Is that true or did you have another specific recommendation in mind?

                (FYI: the database is running now; I can connect to it with SQLPlus or SQL Developer, and the Start link works until the installation of APEX 4.2) It's just a matter of me connecting to the GUI front end.