It depends how you want to run the eve instance and how your licensing agreements with oracle are if youbare an enthusiast and want to run oracle for testing there are AMIs available to use including AMis with Linux and oracle 11.2 xe Details are this …

]]>By: Alex Gorbachevhttp://www.pythian.com/blog/oracle-database-11g-xe-beta-amazon-ec2-image/#comment-593381
Sat, 17 Sep 2011 04:02:08 +0000http://www.pythian.com/news/?p=22025#comment-593381Hm… received recently a warning that the AMI contained an SSH public key and the image was made non-public. This is odd as I scanned it all and couldn’t see any of that.
I’ve made it public for now – let’s see if I find something else soon but in the meantime it should work.
On the other hand, I should actually now rebuild this image using non-beta XE.
]]>By: Gus Spierhttp://www.pythian.com/blog/oracle-database-11g-xe-beta-amazon-ec2-image/#comment-593327
Sat, 17 Sep 2011 01:45:38 +0000http://www.pythian.com/news/?p=22025#comment-593327Hi, Alex.
Extensive search through “Community AMIs” in the US East (Virginia) region does not reveal your instance.
Should I be looking somewhere else?
Regards,
Gus
]]>By: Håvardhttp://www.pythian.com/blog/oracle-database-11g-xe-beta-amazon-ec2-image/#comment-579667
Wed, 17 Aug 2011 10:58:28 +0000http://www.pythian.com/news/?p=22025#comment-579667Hi Alex,

This is excellent! Is it possible for you to make it available in the EU-region as well?

I’m sure there are more than me interested in the ami on this side of the pond :)

Regards,
Håvard

]]>By: Jasonhttp://www.pythian.com/blog/oracle-database-11g-xe-beta-amazon-ec2-image/#comment-574281
Sun, 31 Jul 2011 03:30:49 +0000http://www.pythian.com/news/?p=22025#comment-574281I am unable to locate this AMI when attempting to launch a new instance. Is it still available?
]]>By: Alex Gorbachevhttp://www.pythian.com/blog/oracle-database-11g-xe-beta-amazon-ec2-image/#comment-571795
Sat, 23 Jul 2011 21:36:55 +0000http://www.pythian.com/news/?p=22025#comment-571795I was using this image on Micro EC2 instance very successfully and it works quite well so it seems there is enough memory allocated now. It might get slow on Micro at times but you get what you pay for (no guaranteed CPU cycles basically).

One problem I hit recently was trying to use web-services from APEX (while writing an S3 client – very cool) – “ORA-20001: The webservice was unreachable because either the URL you supplied was invalid, your environment requires a valid proxy server address for HTTP requests, or a wallet needs to be configured for HTTPS requests”.

After checking all the network connectivity (outgoing messages are permitted and are working), I mistakenly started digging into missing wallet and that was a big mistake — still not sure what’s needed there. However, the moment I stumbled upon mentioning of network ACLs, I immediately recalled that in Oracle database 11g, all TCP network communication are prohibited by default and must be explicitly enabled. Usually, it’s done after APEX install for the APEX_040000 user but I thought to keep image more secure and didn’t do it back then. So…

If you need to use UTL_HTTP or web-services or whatever out network connections from APEX — follow these instructions. Basically you need to run this as SYS:

DECLARE
ACL_PATH VARCHAR2(4000);
ACL_ID RAW(16);
BEGIN
-- Look for the ACL currently assigned to '*' and give APEX_040000
-- the "connect" privilege if APEX_040000 does not have the privilege yet.
SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
-- Before checking the privilege, ensure that the ACL is valid
-- (for example, does not contain stale references to dropped users).
-- If it does, the following exception will be raised:
--
-- ORA-44416: Invalid ACL: Unresolved principal 'APEX_040000'
-- ORA-06512: at "XDB.DBMS_XDBZ", line ...
--
SELECT SYS_OP_R2O(extractValue(P.RES, '/Resource/XMLRef')) INTO ACL_ID
FROM XDB.XDB$ACL A, PATH_VIEW P
WHERE extractValue(P.RES, '/Resource/XMLRef') = REF(A) AND
EQUALS_PATH(P.RES, ACL_PATH) = 1;
DBMS_XDBZ.ValidateACL(ACL_ID);
IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040000',
'connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
'APEX_040000', TRUE, 'connect');
END IF;
EXCEPTION
-- When no ACL has been assigned to '*'.
WHEN NO_DATA_FOUND THEN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',
'ACL that lets power users to connect to everywhere',
'APEX_040000', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END;
/
COMMIT;