5 Replies Latest reply on Jul 19, 2011 5:09 AM by Kiran Pawar

    Apex XDB Login Problem

    XYZ123
      hi everyone, i have a question about the login apex.
      I am using oracle 11g ee.

      when i try to login the apex login page i am getting this prompt consistently:

      XDB
      username:
      password:


      anyway, i try to do "Oracle Database Postinstallation Tasks" and i could not find the ORACLE_HTTPSERVER_HOME parameter that what is the path of this? I unlock the anonymous and apex_public_user users. But i am getting an error when i am running the apex_epg_config.sql :

      @apex_epg_config /tmp

      PL/SQL procedure successfully completed.


      PL/SQL procedure successfully completed.

      old 1: create directory APEX_IMAGES as '&1/apex/images'
      new 1: create directory APEX_IMAGES as '/tmp/apex/images'

      Directory created.

      declare
      *
      ERROR at line 1:
      ORA-22288: file or LOB operation FILEOPEN failed
      No such file or directory
      ORA-06512: at "SYS.XMLTYPE", line 296
      ORA-06512: at line 18


      In linux, i try to find the where is the Apache folder through write "find /dwh0/ -name Apache*" and nothing is found.

      For example, i haven't any changing on dads.conf file. Is it necessary?

      What is the real problem? How can i fix this?
        • 1. Re: Apex XDB Login Problem
          XYZ123
          is it a hard question? I think that there is small detail i overlooked.
          • 2. Re: Apex XDB Login Problem
            698379
            The same problem is happening with me also ,
            I have installed oracle 11gR1
            11.0.1.6.0 in Ubuntu 10.04 , and i am trying to configure apex 3.1
            I followed the steps , same as given in the documentation, but when i try to login at the address
            http://localhost:8080/apex/apex_admin

            using
            username admin
            password password

            Nothing happens,it seems as though the link is dead ,in short "No response" to the page .
            Please tell me , what am i missing !

            Edited by: user8020951 on Jul 17, 2011 2:19 AM
            • 3. Re: Apex XDB Login Problem
              876011
              Hi -

              Are you wanting to use the embedded gateway or http server (ohs)?

              It's not clear from above.

              OHS would need to be installed and configured separately.

              [http://download.oracle.com/docs/cd/E10513_01/doc/install.310/e10496/overview.htm#CJAFEAJJ]

              Also, did you enable network service and configure an ACL: [http://download.oracle.com/docs/cd/E10513_01/doc/install.310/e10496/otn_install.htm#BEHGBHDF]

              Chaim
              • 4. Re: Apex XDB Login Problem
                698379
                Hi,
                very well thank you for the fast response , well i installed apex 4.0 using the followng link.

                http://hendrydasan.wordpress.com/2010/07/01/install-and-configure-apex-4-0-in-oracle-database-11gr2/

                with some careful reading , and practice.actually it worked for me just fine for 11gr1 ...........
                but must admin , that official 4.0 documentation is not clear ,anyway thanks again . o and i used embedded gateway method.

                Edited by: user8020951 on Jul 18, 2011 2:26 PM
                • 5. Re: Apex XDB Login Problem
                  Kiran Pawar
                  Hi A. Fuat Sungur,

                  From the error it seems that the EPG is not configured correctly!
                  Where have you extracted apex zip installation?
                  Follow the steps carefully about Configure the Embedded PL/SQL Gateway :

                  http://download.oracle.com/docs/cd/E17556_01/doc/install.40/e15513/otn_install.htm#CHDEIGGI

                  Suppose you have extracted the zip setup of APEX on desktop of your linux having directory path:

                  /home/user1/Desktop/apex

                  then for your EPG configuration command will be:

                  @apex_epg_config /home/user1/Desktop

                  Regards,
                  Kiran