9 Replies Latest reply on Feb 10, 2009 2:07 AM by 31837

    loin apex got error ora-01403?

    31837
      Hi guys:

      I installed apex 3.1.2 in oracle 9.2.0.3 ,but when i tred to login in apex/apex_admin,I got a error

      "
      ORA-01403: no data found

      Unable to get workspace name.

      Return to application.
      "
      I tried using other username ,all it returned the same error?
      I had searched the reason all the internet ,but hadnt got an answer,could you help me settle it? thanks.
        • 1. Re: loin apex got error ora-01403?
          60437
          Please tell us your first name and update your profile with it to help us. Thanks.

          What is the URL you used to get the login page?

          Scott
          • 2. Re: loin apex got error ora-01403?
            31837
            Hi scott:

            I am numen sun,come from china and I have updated my profile as you mentioned.
            My database(9i 9.2.0.3/4) installed in the redhad liunix enterprise server 4. So I download apex 3.1.2 and installed it followed by the document
            of released by oracle.When everything was ok,I logined in by the url: http://192.168.0.1:7777/pls/apex/apex_admin then appeared a page ,required me
            the username and password. put username admin ,password sunn and enter then the error appeared.
            the password is right ,I have used the script of 'apxchwpd.sql' to change it.
            then I tried any other username,the same error also appeared. then I created a new database useing dbca,installed everything the domcument required
            inculding,xml db,oracle text and plweb tookit. then shutdown listener and http server ,installed apex,configered dad description in wdbsvr.app as the domument mentioned , then restart listenter and http server. the same error appeared again.
            So I searched the error all the internet ,and didnot get the answer,So I posted it here,Can you help me?

            thanks anyway.

            numen

            Edited by: flysun on 2009-2-4 下午5:46
            • 3. Re: loin apex got error ora-01403?
              60437
              Numen,

              Thank you very much for providing all those details. Unfortunately, I have no idea what could be wrong. I encourage you to engage Oracle Support in pursuit of a solution.

              Scott
              • 4. Re: loin apex got error ora-01403?
                31837
                Anyone can help me?
                • 5. Re: loin apex got error ora-01403?
                  31837
                  When i open 'http://192.168.0.1:7777/pls/apex/apex_admin"

                  then the page need admin username and password appear

                  "

                  Using this interface the administrator can manage all aspects of the service including creating, removing, and managing workspaces.Application Express Administration Services
                  Username
                  Password

                  "

                  then I put username admin password sunn and enter then :


                  ORA-01403: no data found

                  "

                  Unable to get workspace name.
                  Return to application.

                  "

                  Can anyone give some help?
                  • 6. Re: loin apex got error ora-01403?
                    60437
                    What else are you doing in that database? Is it a database you've been using for other things for a while and are those working? What does "select count(*) from sys.dual" return? Why are you using 9.2.0.3?

                    Scott
                    • 7. Re: loin apex got error ora-01403?
                      31837
                      It should be 9.2.0.4 the following is the message when I login in.
                      "
                      Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
                      With the Partitioning, OLAP and Oracle Data Mining options
                      JServer Release 9.2.0.4.0 - Production
                      "
                      the database works.

                      select * from sys.dual;

                      D
                      -
                      X

                      I test for a long time to try finding where the error is.privately I think ,the Apex did not connect to database,Some times when I press 'enter' some times.
                      there would appear windows let me change my password,but when I changed it and press'enter' then the same errror appears.




                      Here I post wdbsvr.app for you.


                      ;
                      [PLSQL_GATEWAY]
                      administrators = all
                      adminPath = /admin_/
                      ;admindad =
                      ;debugModules =
                      defaultDAD = APEX
                      ;upload_as_long_raw =
                      ;upload_as_blob =
                      ;enablesso =
                      ;stateful =
                      ;custom_auth =
                      ;error_style =
                      ;

                      [DAD_apex]
                      connect_string = 192.168.0.1:1525:test
                      password = apex
                      username = apex_public_user
                      default_page = apex
                      document_table = wwv_flow_file_objects$
                      document_path = docs
                      document_proc = wwv_flow_file_mgr.process_download
                      ;upload_as_long_raw =
                      ;upload_as_blob =
                      ;name_prefix =
                      ;always_describe =
                      ;after_proc =
                      ;before_proc =
                      reuse = Yes
                      ;connmax =
                      ;pathalias =
                      ;pathaliasproc =
                      enablesso = No
                      ;sncookiename =
                      stateful = STATELESS_PRESERVE
                      ;custom_auth =
                      ;response_array_size =
                      ;exclusion_list =
                      ;cgi_env_list =
                      ;bind_bucket_widths =
                      ;bind_bucket_lengths =
                      ;error_style =
                      nls_lang = American_America.Al32UTF8
                      ;

                      by the way ,1525 is the port of listener. the database just a database for test ,having no other uses.

                      Thank you for your care

                      Edited by: flysun on 2009-2-8 下午6:59
                      • 8. Re: loin apex got error ora-01403?
                        60437
                        Would it be possible for you to abandon this database and install 11g and start over with Application Express?

                        Scott
                        • 9. Re: loin apex got error ora-01403?
                          31837
                          Okay,let me try to do it.


                          thank you for your help!