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.
- Download APEX 4.0 from here
- Copy the .zip to an S3 bucket
- Make the bucket public
- Use PUTTY to log on to the AMAZON EC2 instance as root
- su Oracle
- cd /home/oracle
- wget oracleapex4.0.zip (or whatever your S3 public URL for the zip file is)
- Unzip *.zip
- sqlplus sys/password
- @apexins SYSAUX SYSAUX TEMP /i/ (takes around 40 mins)
- @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