6 Replies Latest reply on Aug 29, 2016 1:32 AM by handat

    Installing ORDS in Oracle 11g Release 2 XE

    M.Emmanuel

      I am trying to install ords.3.0.6.176.08.46 in Oracle 11g Release 2 XE Linux x64.

       

      I follow carefully all documentation https://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm#AELIG7015 , but when launching:

       

      java -jar ords.war

       

      The process is stuck when entering ORDS_PUBLIC_USER password:

      # java -jar ords.war

      This Oracle REST Data Services instance has not yet been configured.

      Please complete the following prompts

       

      Enter the location to store configuration data:/u01/app/oracle/ords/

      Enter the name of the database server [localhost]:

      Enter the database listen port [1521]:

      Enter 1 to specify the database service name, or 2 to specify the database SID [1]:

      Enter the database service name:XE

      Enter the database password for ORDS_PUBLIC_USER:

      Confirm password:

       

      .... wait minutes........

      Aug 27, 2016 5:40:58 PM oracle.dbtools.rt.config.setup.SchemaSetup getInstallOrUpgrade

      WARNING: Failed to connect to user ORDS_PUBLIC_USER jdbc:oracle:thin:@//localhost:1521/XE

      IO Error: Connection reset

       

       

       

      User ORDS_PUBLIC_USER is not created, I am wondering if this has to be created in advance. If so, where in the documentation or at which part of the process is this user created?

       

      Any help is welcomed, I have tried to install everything from scratch three times.

      My ultimate goal is to have Oracle 11gr2 XE + apex5 + ords + tomcat.

       

      Thanks

        • 1. Re: Installing ORDS in Oracle 11g Release 2 XE
          handat

          Please follow the Oracle documentaion: https://docs.oracle.com/cd/E56351_01/doc.30/e56293/install.htm#AELIG7217 , in particular look at section 1.3.4.1 regarding the password for the ORDS_PUBLIC_USER.

          1 person found this helpful
          • 2. Re: Installing ORDS in Oracle 11g Release 2 XE
            M.Emmanuel

            I do exactly that, but I still get that error

             

            # cd /u01/app/oracle/ords/

            # pwd

            /u01/app/oracle/ords

             

            # cat params/ords_params.properties

            db.hostname=localhost

            db.port=1521

            db.servicename=xe

            #db.sid=

            db.username=APEX_PUBLIC_USER

            migrate.apex.rest=false

            rest.services.apex.add=

            rest.services.ords.add=true

            schema.tablespace.default=SYSAUX

            schema.tablespace.temp=TEMP

            standalone.http.port=8080

            standalone.mode=true

            standalone.static.images=

            user.tablespace.default=USERS

            user.tablespace.temp=TEMP

             

            # java -jar ords.war

            This Oracle REST Data Services instance has not yet been configured.

            Please complete the following prompts

             

            Enter the location to store configuration data:/u01/app/oracle/

            Enter the database password for ORDS_PUBLIC_USER:

            Confirm password:

            Aug 28, 2016 8:19:31 PM oracle.dbtools.rt.config.setup.SchemaSetup getInstallOrUpgrade

            WARNING: Failed to connect to user ORDS_PUBLIC_USER jdbc:oracle:thin:@//localhost:1521/xe

            IO Error: Connection reset

             

            I have tried it several times, about 5 installations from scratch (database + apex + ords), any help is really welcomed I do not what else to do.

            • 3. Re: Installing ORDS in Oracle 11g Release 2 XE
              handat

              So I assume you have already check that the database is up and running and you can connect to it right?

              Try adding the following java option:

               

              -Djava.security.egd=file:///dev/urandom

              1 person found this helpful
              • 4. Re: Installing ORDS in Oracle 11g Release 2 XE
                M.Emmanuel

                Sure, database was up and running and I was able to connect via sqlplus and netstat shown host listening on port 1521 as expected.

                 

                I am in the process of reinstalling everything (6th time) from scratch. I used ORDS2 procedure at least twice, so I prefer to double check another time.

                 

                If it fails again I will try with that java option.

                 

                Thanks for the help, it is truly appreciated,

                • 5. Re: Installing ORDS in Oracle 11g Release 2 XE
                  M.Emmanuel

                  I did a fresh install

                   

                  **** WITHOUT JAVA OPT PARAMETER

                  bash-4.2$ java -jar ords.war install simple

                  Enter the database password for ORDS_PUBLIC_USER:

                  Confirm password:

                  >>>>>>>> GETS STUCK UNTIL IO ERROR

                   

                  *** WITH JAVA OPT PARAMETER

                  bash-4.2$ java -Djava.security.egd=file:///dev/urandom -jar ords.war install simple

                  Enter the database password for ORDS_PUBLIC_USER:

                  Confirm password:

                  Please login with SYSDBA privileges to verify Oracle REST Data Services schema.

                   

                  Enter the username with SYSDBA privileges to verify the installation [SYS]:

                  >>>>>>>> WORKS AT ONCE!

                   

                  APEX is now happily accessed through ORDS, now I can proceed to install tomcat and deploy ORDS using Tomcat.

                  @handat

                  Do I have to somehow disable the "stand alone mode"?

                  and

                  What did we do with that Java Opt parameter?

                  • 6. Re: Installing ORDS in Oracle 11g Release 2 XE
                    handat

                    On some Linux distros, the default java random generator is a bit slow during startup (too slow for ORDS installer) so that option made it initialise faster.