Looking for a simpler way to download from the new Metalink? Oracle has replaced the ftp site with http downloads using wget. If you’re looking for a simple way to use wget without all of that cutting-and-pasting from the web site, you can use a simple script like this: [code language=”bash”]#!/bin/bash # Program: download.sh # Description: Download Oracle patches from Metalink PROGRAM=`basename $0` USAGE=”Usage: $PROGRAM [ patch file ]” [ $# -lt 1 ] && echo $USAGE && exit 1 patch=$1 username=$METAUSER password=$METAPASS URL=”http://updates.oracle.com/Orion/Download/download_patch/$patch” while [ -z $username ]; do echo -n “Enter metalink username: ” read username done while [ -z $password ]; do echo -n “Enter metalink password: ” stty -echo read password stty echo done wget –http-user=$username –http-password=$password –no-check-certificate –output-document=$patch $URL exit[/code] It’s pretty basic, so you can add error checking or more sophisticated wget options as you like. The only thing you need is the full name of the patch zip file and your Metalink credentials: [code language=”plain”]$ download.sh ;[/code] You can export your Metalink username and password to the variables $METAUSER and $METAPASS, respectively, or the script will prompt you for both. Let me know how this works for you, or if you have a better option – I’m sure there are plenty out there.
EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.
It’s 2015 and you can now establish totally respectable MS SQL DBA credibility just by mentioning you have been in the game since SQL Server version 9. You may even get the same gasps of shock from some colleagues that used to be reserved for the version 6 veterans.