Thursday, September 22, 2011

Downloading Oracle software from linux server with wget

When I need to install software on a linux server, I locate all the software I need and start downloading it.

Downloading it first to your laptop and moving it then to the server is one option, which works ok if you are on the same network as the server. However with having a lot in the cloud it would be far easier to download the software directly on the server (as the server is already connected to the internet).

If I was running a graphical interface on the server, which I'm not, I could have used a browser. I could also have used lynx, a text based browser. My experience with lynx isn't that great, for example when I had to login and the site used javascript things got messed up or were not working. Probably I did something wrong or didn't have enough experience using it.

The way I download for example Oracle software straight into the server is by using wget.
As you can only download Oracle software after you are logged in, I had to do an additional step to get wget working.

These are the steps I followed:
- Open Firefox and install the Expert Cookies add-on. That tool allows you to download the cookies of your pc into a text file.
- Clear all cookies (Tools - Clear Recent History... - Select Cookies and click the Clear now button)

- In your browser on your pc login to the Oracle website and/or depending the software you need on Logging in will set a cookie.
- With the Expert Cookies add-on you can now download the cookies of your pc (Tools - Export Cookies ...) and save the file to your filesystem

- Upload that file to your server
- Now you can run the wget command from the server to download the software you want :-)
For example to download Apache the command looks like:
wget --load-cookies=cookies.txt

Wednesday, September 21, 2011

Updates on APEXBlogs

Some of you might have seen that APEXBlogs wasn't updated with twitter messages anymore for some time. Since last week blog posts were not taken anymore either.

I only found a little time today to look a bit closer into these issues and am happy to share with you what is going on.

The reason for not updating the blog posts was that my package produced this error:

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00217: invalid character 160 (U+00A0)
Error at line 1

Although the Oracle database is running in UTF-8 and Google is sending the posts as UTF-8, it looks like it's not doing that with the blog names. The name "João Oliveira" has some bad characters which Oracle didn't understand. After changing this name in Google Reader the procedure didn't produce the error anymore and Oracle could parse the xml again.

Concerning twitter... that is a different story. It looks like the APEXBlogs is banned to use the Twitter API. As I didn't take out the twitter api calls from the hourly sync, we stayed banned and it got worse I guess.

Although I thought I followed the guidelines of using the API, I'll change the syncing of twitter message to do it less frequently so we aren't blacklisted again in the future. The syncing worked for many months, so Twitter must have changed their policies.

Today I asked Twitter to remove from the blacklist so hopefully the twitter syncing will work again in a few days.

Wednesday, September 14, 2011

APEX Meetup @ OOW 2011

It's an annual tradition that the APEX developers get together at Oracle Open World to have some drinks and meet each other and tell great stories.

This year it's the 5th year we do this! (update: 6th year!) The first APEX Meetup was in 2006, this is the picture that was taken at that time.

You recognise the people? It's funny to see that picture again, it shows how fast life goes and that we don't stay young ;-)

Where in 2006 APEX had still everything to proof, the stories were about "will APEX stay?" and "how can I convince my manager/customer that APEX is really good?"... now, APEX has proven it's value many times and almost every customer using Oracle knows about it or uses APEX. Things change... and the life of APEX isn't over yet... there is more to come.

So what about the meet up this year?

As the tradition wants, the APEX Meetup will be at the 4th Street Bar & Deli on the Tuesday (7.30 PM) during Oracle Open World. Everybody is welcome! OTN (thanks Lillian!) is sponsoring this year again too, so the first round is already paid for :-)

Hope to see you there...