Although I readily admit I am not an expert in this field, I think there is a confusion here between free software and open source software.
Open source isn't about making money. It's about freedom.
Open source is about the source being open, available. Free software is about freedom. Open source software is not necessarily as free as free software. You can also choose to make money and sell open source software.
As soon as you have released a software with the open software source license you are not in control of it any more. You can still sell the copyright of it but you cannot restrict it in the ways being described in earlier posts.The copyright holder can indeed do whatever he wants and release his code with a different (not open source) license, he can however not retract any licensed code already published.
Yes you can. As the copyright owner you can dictate whatever you want. There are many dual-license open source software packages which are free for non-commercial use and paid for commercial use. See MySQL and Qt (in the past?).
If you have licensed open source software you can not go ahead and prohibit commercial use. It must have been a different license than open source software. From what I can see, the part you are paying for is the proprietary application that the MySQL is embedded in or bundled with in the case that a company does not want to be subject to the GPL license that MySQL is licensed under. From my understanding in this case Oracle is selling a copyright (and it seems they call it 'license').
For the majority of what was said I think we're in violent agreement :p I'm just being a bit nit picky about some things I believe are not in the right context (and am happy to be proven wrong of course!)