7 Replies Latest reply on May 17, 2018 4:01 PM by Oscar Armanini

    How can I install Advance Analytic into a computer which cannot be connected to the Internet?

    user4034993

      My computer for some reason can't be connected to the Internet. Can I install advanced analytics? Has anywhere a install package for advanced analytic?

        • 1. Re: How can I install Advance Analytic into a computer which cannot be connected to the Internet?
          Geoff Winkworth

          There is no easy way.

           

          We ended up installing R 3.1.1. separately, then we installed AA on a machine that had Internet connectivity and copied the resulting R libraries from that machine onto the one without Internet.

           

          There were also couple properties/json files we had to update as well to point to the manually installed R installation.

           

          Not ideal but we did manage to get it working.

           

          Hope that helps - sorry.

          • 2. Re: How can I install Advance Analytic into a computer which cannot be connected to the Internet?
            Robert Brooks

            Give this a try. I had the same problem but after spending hours with tech support and checking forums and blogs, this is my own documentation that I have found to have worked. Give it a try.

            1. a)      Click start menu and type in Command Prompt.
              1. i)       Right click command prompt and open file location.
              2. ii)     Right click and run as administrator.
            2. b)      Once in cmd prompt, locate the file path for Oracle DVD on your computer. (ex. For me the file path was:   C:\Program Files\Oracle Data Visualization Desktop)
            3. c)      In order to get to this. First type:
              1. i) cd \
              2. ii)     then copy paste (if your drive or file path is different change it accordingly): “C:\Program Files\Oracle Data Visualization Desktop\install_advanced_analytics.cmd” _payload_ "C:\Program Files\Oracle Data Visualization Desktop\"
              3. iii)   Example (if file path not same as above): "C:\your_path\Oracle Data Visualization Desktop\install_advanced_analytics.cmd" _payload_ "C:\your_path\Oracle Data Visualization Desktop\"

             

            1. d)      The online web-forum link is: https://community.oracle.com/thread/3945341
            • 3. Re: How can I install Advance Analytic into a computer which cannot be connected to the Internet?
              Easwara Chandran-Oracle

              Ideally, the recommended way to install with internet.

               

              Thanks

              Eswar.

              • 4. Re: How can I install Advance Analytic into a computer which cannot be connected to the Internet?
                Oscar Armanini

                Ideally, the best way to provide some sw to customers should be:

                a- a fast download with MD5 checksum;

                b- an easy way to automate silent and unattended installations on many PC clients at the same time;

                c- no Internet access required during installation;

                especially in case of a product which is not free, but we pay yearly maintenance for it.

                 

                I cannot understand point c- .

                In my organization, no computer has Internet access, also CD-ROM, USB, and other connections are blocked, no user has Administrative rights (no one can install sw), StartUp menu is not configurable, Internet Explorer is not configurable, ecc ecc (to gain access to Internet, we use a RemoteDesktop to connect to some server, where just en email client, an Internet browser, Acrobat and Office are installed, no additional sw can be installed even here). No files can be moved from "inside" to "outside", and also the other way aorund (there are exceptions, of course, otherwise I'd not be able to open SR to Metalink).

                At Oracle, do developers working in the laboratories have their computers with Internet access? Is a developer able to send the source code of the Oracle RDBMS engine outside of your organization freely?

                • 5. Re: How can I install Advance Analytic into a computer which cannot be connected to the Internet?
                  Oscar Armanini

                  I have exactly the same problem, I'd like to install Advanced Analytics (with R) and DVML (that is, Phyton) but both additional installations fail.

                  Our proxy don't let them go outside to Internet, so the installers cannot reach:

                  https://oss.oracle.com/ORD/ORD-3.1.1-win.zip  
                  <-- 34 MB ,

                  https://oss.oracle.com/DVML/DVML-1.0.0-win.zip

                    <-- 250 MB ,

                  I opened a SR to Metalink, I have been redirected here, but the workaround  explained by R.Brooks is just to bypass the first section of the CMD scripts (please take a look at both of the .CMD scripts),

                  that is the part which try to create a VBS script to open a second Win Shell with elevated (that is Administrative) rights and then exectue the second part in it.

                  The second section of the script, when the Java installer is called at the last line,

                  is still the one that fails, if your PC cannot access Internet.

                   

                  That's way this question it is still "Without Answer"

                   

                  Regards

                  Oscar

                  • 6. Re: How can I install Advance Analytic into a computer which cannot be connected to the Internet?
                    Oscar Armanini

                    Just a short update

                    Our IT Security guy opened the Proxy (and the Web Gateway) on my PC in order to access https://oss.oracle.com only.

                    a-The script install_dvml.cmd went fine. Also I was able to save somewhere else the setup.exe (that is BiPython_Framework.exe) after it was downloading and before it was deleted at the end of the installation, so I think I can copy it on other PCs and install it there too.

                    b-The script install_advanced_analytics went partially fine. It downloaded another setup.exe (that is R-3.1.1-win.exe) and I was able to save it too before it was deleted at the end of the graphic installation (so, again, I think I can copy it on other PCs and install it there too). Anyway after the setup of R-3.1.1 was finished, from the Win Shell it tried to connect to http://cran.us.r-project.org/   (no directory nor file specifically, just the web site) and of course it failed because the Proxy stopped it. 

                     

                    I'm pretty confident that if I copy the BiPython_Framework.exe and R-3.1.1-win.exe on other PCs and run them, everything will be fine on other PCs too,

                    but I'haven't tried yet. 

                     

                    I don't know why did it try to contact  http://cran.us.r-project.org/  so I don't know which additional parts of R might be missing (documentations, components, updates, etc) because the installation failed at this point. Anyway R 3.1.1 works fine so far.

                     

                    Meanwhile the support answered that this is considered bug and they'll try to fix it, even if there is a disclaimer:

                    "Note: This is INTERNAL ONLY research.  No action should be taken by the customer on this information. This is research only, and may NOT be applicable to your specific situation.

                    Bug 27562012   : UNABLE TO INSTALL ADVANCED ANALYTICS FOR ORACLE DVD 12.2.4.0 "

                     

                    Regards

                    Oscar

                    • 7. Re: How can I install Advance Analytic into a computer which cannot be connected to the Internet?
                      Oscar Armanini

                      Meanwhile I found also Doc 2181816.1

                      https://support.oracle.com/epmos/faces/DocumentDisplay?id=2181816.1

                      OBIEE 12c: Where Can I Find What Oracle R Enterprise (ORE) and 'R' Statistical Packages Are Supported?

                       

                      which has some useful instructions

                       

                      Oscar