DevOps, CI/CD and Automation

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.

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?

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).

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.

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?

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?

Perhaps I should not have used the -c?

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.

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.

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.

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

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

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.

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.

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.

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

Oracle 12c installation on Windows 7 not progressing

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>