Forum Stats

  • 3,855,178 Users
  • 2,264,465 Discussions
  • 7,905,912 Comments

Discussions

Oracle 12c for Windows download aborts after about 30 minutes

Barbara Boehmer
Barbara Boehmer Member Posts: 4,625 Gold Trophy
edited Jul 26, 2013 5:21AM in Downloads Issues

Every attempt to download Oracle 12c for Windows file1 starts out downloading just fine, then aborts after about 30 minutes and leaves a download-fail-1505220.html file that says,


"Sorry! In order to download products from Oracle Technology Network you must agree to the OTN license terms. Be sure that... Your browser has "cookies" and JavaScript enabled. You clicked on "Accept License" for the product you wish to download. You attempt the download within 30 minutes of accepting the license. From here you can go... Back to Previous Page Site Map OTN Homepage".

When I attempt this, I am logged in to OTN, everything is enabled, I accept the license agreement, and immediately begin the download.  I am attempting the download using the FireFox 22.0 browser with the DownThemAll 2.0.16 extension download utility via Verizon Wireless 7.2.1.2 mobile broadband.  This combination has worked quickly and enabled resuming of interrupted downloads of many other things.  My operating system is Windows 7 Professional 64 bit.  I currently have Oracle 11g installed and I downloaded that in the same fashion a long time ago.

Best Answer

«1

Answers

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,890 Red Diamond
    Answer ✓

    I use wget to download large files from Oracle. A browser download is too flaky, cannot restart, etc.

    Not sure if wget (or similar) is available for Windows. But if it is, it gets my recommendation.

    To get the download URL from Oracle (that includes an auth token based on your OTN account), I use Firefox and select Tools|Web Console.

    This tells me the URLs that are passed between browser and server. The output (last few lines) looks as follows (after clicking accept license and the download file link on OTN):

    [08:03:53.777] GET https://login.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_login?Site2pstoreToken=v1.2~CA55CD32~A638B9xxxE48A70EB874229A8C0078C31DB [HTTP/1.0 200 Connection established 1455ms]
    [08:03:56.327] GET https://edelivery.oracle.com/osso_login_success?urlc=v1.2%7E64AB21C3D76096C1C9CCDExxxx3D61805 [HTTP/1.1 302 Moved Temporarily 629ms]
    [08:03:56.970] GET https://edelivery.oracle.com/akam/otn/nt/oracle12c/121010/winx64_12c_database_1of2.zip [HTTP/1.1 302 Moved Temporarily 615ms]
    [08:03:57.594] GET http://download.oracle.com/otn/nt/oracle12c/121010/winx64_12c_database_1of2.zip?AuthParam=1374559605_9cb258e6xxxxxxxxxxxxd73cd0f2 [HTTP/1.0 200 OK 2655ms]
    

    The last line is the download URL with authentication token. Copy and paste and use as parameter for wget.

  • Christian Erlinger
    Christian Erlinger Member Posts: 3,244 Gold Trophy
    edited Jul 23, 2013 6:31AM
    Not sure if wget (or similar) is available for Windows. But if it is, it gets my recommendation

    See GnuWin32

    also useful if you get tired of syntax errors when typing ls -la on a windows machine

    cheers

    Message was edited by: ChristianErlinger Edit: oh and by the way, I just finished the download successfully.

    Christian Erlinger
  • Barbara Boehmer
    Barbara Boehmer Member Posts: 4,625 Gold Trophy

    Thanks Billy and Christian.  I tried the following with the following results.  Please let me know what I did wrong.

    I downloaded the complete package, except sources, from:

    http://gnuwin32.sourceforge.net/packages/wget.htm

    and ran the setup file, so I now have:

    C:\Program Files (x86)\GnuWin32\bin>dir

    Volume in drive C has no label.

    Volume Serial Number is F0BB-93C9

    Directory of C:\Program Files (x86)\GnuWin32\bin

    07/23/2013  01:18 PM    <DIR>          .

    07/23/2013  01:18 PM    <DIR>          ..

    09/03/2008  01:49 PM         1,177,600 libeay32.dll

    03/14/2008  03:21 PM         1,008,128 libiconv2.dll

    05/06/2005  12:52 PM           103,424 libintl3.dll

    09/03/2008  01:49 PM           232,960 libssl32.dll

    12/31/2008  07:03 AM           449,024 wget.exe

                   5 File(s)      2,971,136 bytes

                   2 Dir(s)  381,718,335,488 bytes free

    C:\Program Files (x86)\GnuWin32\bin>

    From Firefox on the following page:

    http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

    I selected Web Developer->Web Console, then clicked on accept license, then file1, and got, as part of the last line (authparam value obscured):

    http://download.oracle.com/otn/nt/oracle12c/121010/winx64_12c_database_1of2.zip?AuthParam=...

    From a DOS Command Prompt window, I then did (authparam value obscured):

    C:\Program Files (x86)\GnuWin32\bin>wget http://download.oracle.com/otn/nt/oracle12c/121010/winx64_12c_database_1of2.zip?AuthParam=...

    and got (authparam value obscured):

    SYSTEM_WGETRC = c:/progra~1/wget/etc/wgetrc

    syswgetrc = C:\Program Files (x86)\GnuWin32/etc/wgetrc

    --2013-07-23 13:47:07--  http://download.oracle.com/otn/nt/oracle12c/121010/winx64_12c_database_1of2.zip?AuthParam=...

    Resolving download.oracle.com... 184.50.26.11, 184.50.26.9

    Connecting to download.oracle.com|184.50.26.11|:80... connected.

    HTTP request sent, awaiting response... 403 Forbidden

    2013-07-23 13:47:23 ERROR 403: Forbidden.

    What did I do wrong?

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,890 Red Diamond
    edited Jul 24, 2013 1:14AM
    From a DOS Command Prompt window, I then did (authparam value obscured):
    
    C:\Program Files (x86)\GnuWin32\bin>wget http://download.oracle.com/otn/nt/oracle12c/121010/winx64_12c_database_1of2.zip?AuthParam=...
    
    and got (authparam value obscured):
    
    SYSTEM_WGETRC = c:/progra~1/wget/etc/wgetrc
    syswgetrc = C:\Program Files (x86)\GnuWin32/etc/wgetrc
    --2013-07-23 13:47:07--  http://download.oracle.com/otn/nt/oracle12c/121010/winx64_12c_database_1of2.zip?AuthParam=...
    Resolving download.oracle.com... 184.50.26.11, 184.50.26.9
    Connecting to download.oracle.com|184.50.26.11|:80... connected.
    HTTP request sent, awaiting response... 403 Forbidden
    2013-07-23 13:47:23 ERROR 403: Forbidden.
    
    
    

    Not a DOS command prompt - as DOS is an old 16bit real mode operating system. That is a 32bit (or 64bit) Windows console, running inside a standard Windows VM. The only means to find DOS these days is in Virtual Boxes. Of which I have a bunch, including ones with Microsoft and Novell TCP/IP support that brought back the past when I created them.

    Not sure what went wrong there Barbara. I did a quick test and got the download URL for SQL-Developer with an auth token. I then ssh'ed into another Linux box and did a wget on that URL. Worked fine. So it would seem that the URL with token is transportable between systems (and token is not for a single specific web client, no additional cookies needed, etc).

    The only reason for the 403 error that comes to mind is an invalid or expired auth token.

    You can wrap the URL with double quotes to ensure it is passed as a single parameter to wget (command shell parsing sometime mess CLI parameters around). But I doubt that this is the problem.

    Unfortunately I do not have a Windows machine nearby to do a test (my last one was formatted with Oracle Linux 6.4 and 12c installed).

  • Barbara Boehmer
    Barbara Boehmer Member Posts: 4,625 Gold Trophy

    I started over with using Web Console from Firefox and accepted the license agreement again and clicked on file1 again to get a fresh auth token.  Then I used the new url with fresh auth token with wget from the Windows command prompt or whatever you call it, without any double quotes, and it is currently downloading.  It shows an eta of several hours.  I am waiting to see if it gets past the half hour point where the download using FireFox and DownThemAll previously aborted.  If it makes it past that, then I will need to let it finish overnight and hope I don't lose my wireless internet connection or something while it is running.  I'll let you know how it turns out.

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,890 Red Diamond

    wget supports restarting a partial download. You will however need to have it read and write from the same file - which in this case is funky filename that includes the complete URL.

    What should work is renaming the download file to something simpler, and restart wget with the new auth URL and use the -o (output) parameter to point it to the renamed zip file to continue downloading.

    Have not used the restart option for some time though - I leave the wget for overnight and usually get a completed download the next morning.

    Billy Verreynne
  • Barbara Boehmer
    Barbara Boehmer Member Posts: 4,625 Gold Trophy

    I happened to wake up around 3 a.m., so I decided to check the download.  I found that my laptop computer was shut down, so I re-started it and found a message that it had shut down due to overheating.  I found the following:

    C:\Program Files (x86)\GnuWin32\bin>wget http://download.oracle.com/otn/nt/oracle12c/121010/winx64_12c_database_1of2.zip

    ?AuthParam=...

    SYSTEM_WGETRC = c:/progra~1/wget/etc/wgetrc

    syswgetrc = C:\Program Files (x86)\GnuWin32/etc/wgetrc

    --2013-07-23 23:30:48--  http://download.oracle.com/otn/nt/oracle12c/121010/winx64_12c_database_1of2.zip?AuthParam=...

    Resolving download.oracle.com... 184.50.26.11, 184.50.26.9

    Connecting to download.oracle.com|184.50.26.11|:80... connected.

    HTTP request sent, awaiting response... 200 OK

    Length: 1337085275 (1.2G) [application/zip]

    Saving to: `[email protected]=...'

    17% [============>                                                                  ] 232,191,474 --.-K/s   in 2h 37m

    2013-07-24 02:07:59 (24.1 KB/s) - Read error at byte 232191474/1337085275 (Connection reset by peer). Retrying.

    --2013-07-24 02:08:01--  (try: 2)  http://download.oracle.com/otn/nt/oracle12c/121010/winx64_12c_database_1of2.zip?AuthP

    aram=...

    Connecting to download.oracle.com|184.50.26.11|:80... failed: Network is unreachable.

    Connecting to download.oracle.com|184.50.26.9|:80... failed: Network is unreachable.

    Resolving download.oracle.com... failed: No data record of requested type.

    wget: unable to resolve host address `download.oracle.com'

    C:\Program Files (x86)\GnuWin32\bin>

    So, it looks like it downloaded 17%, then something happened, then it did one retry that failed, prior to the shutdown due to overheating.  So, I reconnected to the internet and went through the process to get a new url with a new auth.  Then I did and got the following:

    C:\Program Files (x86)\GnuWin32\bin>wget -c http://download.oracle.com/otn/nt/oracle12c/121010/winx64_12c_database_1of2.

    zip?AuthParam=<new authparam> -o [email protected]=<old authparam>

    SYSTEM_WGETRC = c:/progra~1/wget/etc/wgetrc

    syswgetrc = C:\Program Files (x86)\GnuWin32/etc/wgetrc

    There is nothing else listed underneath it, showing the status, as there was in the previous run.  So, I am a bit baffled as to what is happening.  My Verizon Wireless statistics shows that it is downloading something like crazy.  A directory listing before and after the restart shows a second file with a different name as if it is starting over:

    C:\Users\Owner\AppData\Local\VirtualStore\Program Files (x86)\GnuWin32\bin>dir

    Volume in drive C has no label.

    Volume Serial Number is F0BB-93C9

    Directory of C:\Users\Owner\AppData\Local\VirtualStore\Program Files (x86)\GnuWin32\bin

    07/23/2013  11:30 PM    <DIR>          .

    07/23/2013  11:30 PM    <DIR>          ..

    07/24/2013  02:07 AM       232,191,474 [email protected]=1374647525_41bf65c34b02cf7a809d8a7edeb1c04

    2

                   1 File(s)    232,191,474 bytes

                   2 Dir(s)  380,973,043,712 bytes free

    C:\Users\Owner\AppData\Local\VirtualStore\Program Files (x86)\GnuWin32\bin>dir

    Volume in drive C has no label.

    Volume Serial Number is F0BB-93C9

    Directory of C:\Users\Owner\AppData\Local\VirtualStore\Program Files (x86)\GnuWin32\bin

    07/24/2013  03:25 AM    <DIR>          .

    07/24/2013  03:25 AM    <DIR>          ..

    07/24/2013  03:25 AM                 0 [email protected]=<old authparam>

    07/24/2013  03:25 AM                 0 [email protected]=<new authparam>

                   2 File(s)              0 bytes

                   2 Dir(s)  381,152,092,160 bytes free

    C:\Users\Owner\AppData\Local\VirtualStore\Program Files (x86)\GnuWin32\bin>

    So, does it look like it ignored the -o and started with the new authparam, but silently for some reason, or what?

  • Barbara Boehmer
    Barbara Boehmer Member Posts: 4,625 Gold Trophy

    I just noticed that the status is in the title on the top of the window, indicating it has downloaded 7%.  It has obviously started over with the new authparam.  So, if this load fails, how do I get it to resume, instead of starting over?  I didn't rename the file as you suggested, since I just used the whole original.  Shouldn't that have worked?

  • Barbara Boehmer
    Barbara Boehmer Member Posts: 4,625 Gold Trophy

    Perhaps I should not have used the -c?

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,890 Red Diamond

    Best would be to hit google with keyword phrase like "wget restart". I cannot recall how I did wget restarts as it has been that long ago (and yes, age also likely is a factor ).

    What I do remember is that for the restart to work, it needs the aborted target file to continue the download.

This discussion has been closed.