Academic, Researcher, Data Specialist
I have updated the installation guide for the Oracle MySQL 5.6.21 Community Server since a number of issues were encountered and the previous guide was no longer valid.
To view the guide click on the following link: Oracle MySQL 5.6.21 Community Server Guide.
For educational use only, I have prepared an installation guide of MySQL 5.6.20 Community Server tested on Windows XP (32-Bit), Windows 7 (32-Bit), Windows 8 (64-Bit), Ubuntu 14.04 (64-Bit) and Mac OS 10.9.4 (64.bit)
Click on the following link for the MySQL 10.6.20 Installation Guide.
SQL Developer – Connections tab not visible
1) Do make sure that you have downloaded the version that includes the jre
2) Do make sure that you have the right version, there is a 64-bit version if you have a 64-bit system.
3) Do make sure that SetJavaHome has been properly set to the Java location on your system, the option is found in the SQL Developer configuration file \sqldeveloper\bin\sqldeveloper.conf (http://forums.oracle.com/forums/thread.jspa?threadID=1049872)
Oracle XE Home Page returns Error 404
If you are using NetBeans or Visual Studio and your web pages or Oracle XE Home page are returning a Error 404: Page Not Found you might want to try the following link: http://hubpages.com/hub/ASPNET-DEVELOPMENT-SERVER–WEB-PAGE-CANNOT-BE-DISPLAYED
Unknown Locale
If when attempting to connect you are getting a Locale not recognized error, make sure that your regional settings are set to English, Control Panel->Regional and Language Options, you also need to add the following to the sqldeveloper.conf file: AddVMOption -Duser.Xlanguage=en
AddVMOption -Duser.region=US
(http://forums.oracle.com/forums/thread.jspa?threadID=369603)
Access Denied error when starting Oracle Database
If you are getting an Access Denied error when starting the Oracle XE server you need to right-click on the “Start Dabatase” option and select “Run as administrator”.
Other Errors
It is know that some errors are particular to Windows Vista, if you still cannot get either Oracle XE or Oracle SQL Developer to work you might want to try to install a Virtual Machine, install an OS of your choice (recommended Windows XP) and install Oracle XE then Oracle SQL Developer.
In response to a question on stackoverflow, here is a short guide on how to completely uninstall PostgreSQL 9.1 from Mac OS X Lion.
Utilities->Terminal
sudo /Library/PostgreSQL/9.1/uninstall-postgresql.app/Contents/MacOS/installbuilder.sh
sudo rm -rf /Library/PostgreSQL
sudo rm /etc/postgres-reg.ini
System Preferences -> Users & Groups
Unlock the settings panel by clicking on the padlock and enter your password
Select the PostgreSQL user and click on the minus button.
Installing MAMP on Mac OS X Lion is surely an easy way of getting Apache, PHP and MySQL working on your system. If you plan on using MySQL Workbench you will need to do some additional steps.
Keep checking through the guide for additional configuration.
Another task that I needed to do after buying my Mac was to get my Web toolkit working. Apache, MySQL and PHP are very conveniently managed by MAMP, WordPress is as straight forward as always. MySQL Workbench required some fine tuning but managed to fix it properly.
Decided to document everything as I went along and prepared a well documented guide with some of my personal recommendations. Hope you will find it useful and as always all feedback is welcome.
MAMP, MySQL Workbench and WordPress setup guide
Out of sheer curiosity I had decided at the beginning of the year not to satisfy myself with Oracle Express Edition and started experimenting with Oracle 11g Release 2. It wasn’t long before I got it up and running on Windows systems and was able to administer it with ease thanks to the ample documentation found. The same can be said for installation on Red Hat Linux which is officially supported by Oracle. Being a little bit curious I wanted to test it on my two favorite operating systems, CentOS and Ubuntu.
Well it wasn’t all that easy and there isn’t much documentation for those OSs. I spent a lot of time reading various postings then testing and experimenting myself, documenting all along the way. Finally I managed to get Oracle working for CentOS 5.5, Ubuntu 10.10 and Ubuntu 11.04 with good documentation. This will be a continuous work in progress and will plan to keep updating it.
Today I found some time to fix the presentation of the document and decided that it is fine time to share it with the public. So here is the link in the way that I would have loved to have found it on the net: Oracle 11g R2 Guide
As usual all feedback is more than welcome!
One of my subject areas is information systems, and the undisputed number one brand in database systems is obviously Oracle. Recently Oracle have improved their light version of their flagship product the Oracle Express Edition and have also updated SQL Developer. I had prepared an installation guide for both software which I have updated for public use!
If it interests you here is the link: Oracle Express Edition 11g Release 2 and Oracle SQL Developer
Do leave some feedback for this guide!