1 2 Previous Next 23 Replies Latest reply: Jul 19, 2011 7:08 AM by Udo Go to original post RSS
      • 15. Re: How to i migrate my applications created on 10g XE to 10g SE
        Udo
        Hi Uday,

        you can't use the apxchpwd.sql from an older release, or did you copy it from your Linux 11g XE? If so, is this actually the instance you've installed APEX on?
        You can run the following queries to verify your APEX installation
        SELECT username
          FROM all_users
         WHERE username LIKE 'APEX_%'
            OR username LIKE 'FLOWS_%';
        
        SELECT comp_id, comp_name, status
          FROM dba_registry
         WHERE comp_id='APEX';
        The first query should return three rows:
        FLOWS_FILES
        APEX_PUBLIC_USER
        APEX_040000
        The second one row:
        APEX     Oracle Application Express     VALID
        If that's not the case, your APEX is not installed properly.

        -Udo
        • 16. Re: How to i migrate my applications created on 10g XE to 10g SE
          277538
          Hi Udo

          I have checked this queries, APEX is installed properly. But i am not able to find apxchpwd.sql in oracle 11g directory.
          is there any other way to change admin password to access admin page of apex


          Thanks & Regards

          Uday

          Edited by: udaykumar309 on Jul 19, 2011 1:06 PM
          • 17. Re: How to i migrate my applications created on 10g XE to 10g SE
            Udo
            Hi Uday,

            no, nothing that would be different from what the script does.
            The apxchpwd.sql belongs to the APEX installation package. From what I've understood concerning the instance you are currently working on, it is not an XE instance. Did you install APEX 4.0 into that instance? If so, have a look into the installation package you used for this. You'll find the apxchpwd.sql in the root of that package.
            I I got it wrong, please clarify which APEX version on which database version you are trying to access, and if this is the preinstalled APEX version or one you installed afterwards.

            -Udo
            • 18. Re: How to i migrate my applications created on 10g XE to 10g SE
              277538
              Hi Udo

              I have installed oracle 11g SE, and according to our earlier discussions APEX comes preinstalled with oracle 11g Se. Do i need to install apex 4 on top of 11g SE? If yes i have not done this yet.

              Thanx and Regards

              Uday
              • 19. Re: How to i migrate my applications created on 10g XE to 10g SE
                Udo
                Hi Uday,

                it depends from what APEX version you try to migrate to your 11g SE, and also which 11g release you've installed, as the APEX version will differ. You can't migrate applications from a newer APEX release to an older one. So your 11g SE needs to have at least the same APEX version you've got on your source XE. If you come from 11.2 XE beta, you'll have APEX 4.0 as source, so you'll have to upgrade APEX in your 11g SE (which definetly has an APEX release prior to 4) to 4.0. You can do this by simply following the APEX Installation Guide mentioned before - the upgrade is documented in there as well. At the end of the upgrade, you'll have the chance to reset the password with the script supplied in the installation package.

                -Udo
                • 20. Re: How to i migrate my applications created on 10g XE to 10g SE
                  277538
                  Hi Udo

                  At this point we are talking about just connecting to apex admin, irrespective of any version i should be able to connect to apex on 11g.

                  when i try connecting thrugh this url http://localhost:8080/apex/apex_admin, it gives me login prompt for XDB username and password. i put system/manager, it ask for APEX username and password, i put admin/system it says unauthorised


                  Thanks and Regards

                  Uday
                  • 21. Re: How to i migrate my applications created on 10g XE to 10g SE
                    Udo
                    Hi Uday,

                    you can reset this password with the apxchpwd.sql that is part of the APEX installation package that corresponds to the APEX version you have in your database.

                    -Udo
                    • 22. Re: How to i migrate my applications created on 10g XE to 10g SE
                      277538
                      Hi Udo

                      Now I have installed apex 4 on top of oracle 11g following all the procedure including chage apex admin password. everything went successful.


                      SQL> @apexins SYSAUX SYSAUX TEMP /i/

                      SQL> @apxldimg.sql C:\

                      SQL> @apxchpwd



                      when i open the admin page it asks for xdb authentication, is xdb any different from apex admin?

                      thanks and regards

                      Uday
                      • 23. Re: How to i migrate my applications created on 10g XE to 10g SE
                        Udo
                        Hi Uday,

                        usually, you wouldn't have to do any xdb authentication for APEX. Probably you haven't configured the EPG properly yet. Please also perform the following steps described in the APEX Installation Guide. It seems you are now at the point where you could continue with [url http://download.oracle.com/docs/cd/E17556_01/doc/install.40/e15513/otn_install.htm#BEHCJDJA]section 3.4.4. Please follow the Installation Guide to the end of the EPG-part to make sure everything is in place as it should.

                        -Udo
                        1 2 Previous Next