Upgrading Oracle Apex 3.2 to Apex 4.0 on Amazon EC2 Cloud

Warning: mysql_get_server_info(): Access denied for user ''@'localhost' (using password: NO) in /home/blucel/public_html/wp-content/plugins/xml-google-maps/xmlgooglemaps_dbfunctions.php on line 10

Warning: mysql_get_server_info(): A link to the server could not be established in /home/blucel/public_html/wp-content/plugins/xml-google-maps/xmlgooglemaps_dbfunctions.php on line 10

Just today, I upgraded one of my Amazon cloud servers to Application Express 4.0.

Few wee problems along the way, but got there in the end.

Here is how I did it.

1. Download APEX 4.0 from here
2. Copy the .zip to an S3 bucket
3. Make the bucket public
4. Use PUTTY to log on to the AMAZON EC2 instance as root
5. su Oracle
6. cd /home/oracle
7. wget oracleapex4.0.zip (or whatever your S3 public URL for the zip file is)
8. Unzip *.zip
9. sqlplus sys/password
10. @apexins SYSAUX SYSAUX TEMP /i/ (takes around 40 mins)
11. @apxldimg.sql /home/oracle (takes around 10 mins)

Voila, job done. Not too bad.

Looking forward to getting my hands on all the new features. Especially, declaritive uploads, and my writing my own plugins

Mark