Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 12c for Windows download aborts after about 30 minutes

Barbara BoehmerJul 16 2013 — edited Jul 26 2013

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.

This post has been answered by Billy Verreynne on Jul 23 2013
Jump to Answer

Comments

Billy Verreynne
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.

Marked as Answer by Barbara Boehmer · Sep 27 2020
Christian Erlinger
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.

Barbara Boehmer

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

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

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

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.

Barbara Boehmer

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: `winx64_12c_database_1of2.zip@AuthParam=...'

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 winx64_12c_database_1of2.zip@AuthParam=<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 winx64_12c_database_1of2.zip@AuthParam=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 winx64_12c_database_1of2.zip@AuthParam=<old authparam>

07/24/2013  03:25 AM                 0 winx64_12c_database_1of2.zip@AuthParam=<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

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

Perhaps I should not have used the -c?

Billy Verreynne

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.

Barbara Boehmer

I already did search for "wget restart" and similar things like "wget restart windows".  That's how I found the -c to continue a load, but I didn't find anything about dealing with an authparam on anything else causing a different file name or how to deal with that.   The current download attempt is now at 73%.  If it aborts again, then I will try without the "-c".  Of course, there is still the second file.

Barbara Boehmer

I think I have it figured out.  If I rename the old file with the old url and the old authparam to the new file with the new url and the new authparam, then load using wget -c <new file with new url and new authparam> then theoretically it should work.  If it aborts, then I will try that instead.

Barbara Boehmer

Success!  File1 finished downloading.  One down and one to go.  I just started downloading file2.  I'll keep you posted.

Billy Verreynne

And what about Grid Infrastructure!? Cannot leave that on its own.

Barbara Boehmer

My laptop overheated and shut down again.  This time it didn't shut down normally, so I had to do a full re-start, so I didn't get to see exactly what happened before the shutdown.  I checked the size of the file it was downloading and could tell that it wasn't finished.  I went through the process to get a new url with new authparam.  I renamed the old file to the file name in the new url, using double quotes.  Then I ran wget -c <new url with new file name with new authparam> and it immediately resumed downloading at 66%.  "-c" is for continue.  So, that is one method for anyone else that needs it.  In my previous internet searches, I did read various things about the behavior of -o changing from version to version, regarding continuing or overwriting.  So, what worked in the past may not anymore.  As to Grid Infrastructure, I don't know that I am ready to play with that yet.  I think I will just settle for downloading and installing the 12c database for now.  I will let you know when the download has actually finished.

Barbara Boehmer

I woke up at 2 a.m. to find that I lost my internet connection, so I used the same method to resume the load of file2 at 78%.  This is agonizingly slow, but it is getting there.

Barbara Boehmer

Download complete!  My laptop shut down abnormally again, but the size of the file tells me that it finished downloading first.  Thanks again for all the help.  Now I just have to unzip and install, so I can start having fun experimenting with the new features.

Barbara Boehmer

After finally completing the download, I now have an installation problem:

Oracle 12c installation on Windows 7 not progressing

Barbara Boehmer

The strangest thing happened.  I got an email saying that there was a response to my post in the installation forum, but when I clicked on the discussion link it went to an unrelated thread in a different forum.  I found the correct thread in the correct forum and tried to post the response below a few times, but each time I got a vague message saying that an error occurred and to try again.  So, I am going to try to post it here for now, so that those trying to help (Billy) will know that the problem appears to be solved.

The Windows Task Manager, under Applications, shows Database Configuration Assistant Running.  I don't see any log files in the c:\oracle12c directory or any of its sub-directories.  However, it finally dawned on me to check and see what I could find and do and guess what, I found OraDB12Home1 and Application Development and SQL*Plus and connected as sysdba, unlocked the scott account, connected as scott/tiger and behold everything works, as shown below.  So, I guess it finished even if it doesn't look like it.

SQL> select banner from v$version;

BANNER

------------------------------------------------------------------------------

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

PL/SQL Release 12.1.0.1.0 - Production

CORE    12.1.0.1.0      Production

TNS for 64-bit Windows: Version 12.1.0.1.0 - Production

NLSRTL Version 12.1.0.1.0 - Production

SQL> select * from scott.dept;

    DEPTNO DNAME          LOC

---------- -------------- -------------

        10 ACCOUNTING     NEW YORK

        20 RESEARCH       DALLAS

        30 SALES          CHICAGO

        40 OPERATIONS     BOSTON

SQL>

1 - 19
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 23 2013
Added on Jul 16 2013
19 comments
17,045 views