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:
#!/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
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:
$ download.sh ;
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.
Subscribe to Our Blog
Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.
Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.
Imagine over 100 logins on the source server, you need to migrate them to the destination server. Wouldn’t it be awesome if we could automate the process?