Ken, To answer your questions, theoritically, the Oracle server can be in your own server and the ARS server can be EC2 or vice versa, or as we did, we put both in the cloud.
During our initial efforts to put ARS in the cloud, we found an AMI created by Oracle (AMI ami-7acb2f13) There are several AMIs available from Oracle which you could use. We chose this one for no particular reason other than 11g. When you start the AMI and login the first time, it will configure a database for you. You will find once the database is created, if you do not shut it down, it will persist (including reboots). However when you terminate the AMI, all the information (database, configurations, etc) will be lost. I would strongly encourage you to learn how to create your own AMI. After we created the database and was able to access it locally and remotely, we created our own copy of the database server AMI. But there is some gotchas which border on water-boarding torture. Oracle created a partition and stored the database on this partition, but when you create the AMI, it is not recognized as a seperate partition, just as a directory (/u02). When you start your AMI, the /etc/fstab mounts the partition but the data is not there, it is in the space reserverd for /u02 on the root partition. I'll let you figure out how to get around this. Also, if you are not a dba, you should involve a dba to help with backing up and restoring a database. Each time the AMI is shutdown, all the data, configuration, etc will be lost. You will have to implement some type of method to deploy/restore a database each time it is restored. You will not have this problem with reboots. Some sales consultants may find this adventageious since they don't have to rebuild a presentation server. Stop it and your back where you begin. The ARS server was initially placed on the same AMI (no we haven't shut it down yet) as a proof of simple concept. You can also install your own oracle server, start a MS AMI which has SQL-Server and install ARS on Windows 2003 Server. There is no real limit to what you can do in EC2. Good Luck, ==Mac On Mon, May 4, 2009 at 9:01 AM, Leihkauff, Kenneth < kenneth.g.leihka...@saic.com> wrote: > ** > > Thanks for the reply. > > > > Does the Oracle 11g database need to be installed in Amazon’s EC2 > environment using the “Oracle Enterprise Linux” operating system? So, do > you install Remedy ARS 7.1 on a Red Hat Linux instance, and the Oracle > database on a separate instance (AMI) using Oracle Enterprise Linux OS? > > > > Thanks. > > > > Ken L. > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Geoffrey Endresen > *Sent:* Tuesday, April 28, 2009 1:44 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Remedy in Amazon Computing Cloud? > > > > ** Here is my outline from the presentation yesterday at NW RUG > > CARS (Cloud AR System) FIRST TRY > Mac McMillan and Geoff Endresen > Amazon.com Workflow Applications Team > > Presented 04/27/2009 > to the NWRUG (North West Remedy User Group) > Seattle,WA hosted by Amazon.com > > What are the services we are using? > • Amazon EC2 – elastic compute cloud used to provision new hosts > • Amazon S3 – simple storage solution used to store machine images > • We are using BMC AR System 7.1 in our example today. > > What is the cloud ? > • It’s elastic IP Addresses and servers allocated on demand. > • How many do you need? Ask for a server get a server > • Pay by the hour, month, day, even more options > • AWS is a great way to reduce capital expense. > • BMC wants to help you reduce Operating expense. > > Steps to get your AR System running in the cloud > • 1) Get an AWS account > • 2) Sign up for EC2 (Elastic Compute Cloud) > • 3) Use the AWS Console to Provision DB Host > • 4) Install AR System > • 5) Login via the driver, > • 6) still working on port settings for access via the User Tool > > Links and Getting started > 1) Get an Amazon Web Services Account http://aws.amazon.com > 2) Sign up for Amazon EC2 http://aws.amazon.com/ec2 > 3) Use the AWS Console to provision a DB Host > • https://console.aws.amazon.com/ > • https://console.aws.amazon.com/ec2/home > • See video here: (how to use the console) > • http://media.amazonwebservices.com/console/AwsConsole.html > • Login as root > > 4) Install AR System > • The first time we did these steps > • ssh to the host using the keys > • Created an oracle database > • Verified via sqlplus > • get the arsystem-tar file to the host > • Created a non-root user (arsys) > • su - arsys > • ./ar_install > > 5) Login via driver > • Add the host name and port > • Login as Demo > • cd /opt/ar/api/src/driver > • ssp 22222 > • Log > • Demo > • 22222 > • Init > • Gls > • List of schemas > > > 6) What’s next? > • Setup security ports to access externally > • Install a Mid-Tier web server > • Storing file attachments in S3? > • Setup another NW RUG > > On Tue, Apr 28, 2009 at 10:14 AM, Geoffrey Endresen <geoffer...@gmail.com> > wrote: > > Rick is correct. > > Mac McMillan and I presented yesterday at the NWRUG. We got the AR System > 7.1 installed on Linux with Oracle 11g running in EC2. We are still working > on the security settings to allow the ports to access it from outside our > firewall. > > I'm calling it CARS (Cloud Action Request System). We may need to pay > royalties to Disney/Pixar; they might already have a trademark on it ;0) > > When we figure out the port settings I'll update the instructions and send > them out. > > Thanks, > -Geoff Endresen > Amazon.com > > > > On Tue, Apr 28, 2009 at 6:36 AM, Rick Cook <remedyr...@gmail.com> wrote: > > ** > > Actually, the guys at Amazon, who also use Remedy, are working on that > already. I am sure they will let the list know when there is a tested > process for doing that. > > Rick > > Sent from my Verizon Wireless BlackBerry > ------------------------------ > > *From*: "Leihkauff, Kenneth" > *Date*: Tue, 28 Apr 2009 09:00:12 -0400 > *To*: <arslist@ARSLIST.ORG> > *Subject*: Remedy in Amazon Computing Cloud? > > Hi, > > > > Does anyone have any experience with hosting Remedy ARS/MidTier/ITSM in > Amazon’s computing cloud (EC2)? > > > > Ken Leihkauff > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > > > -- > -Geoff Endresen > Amazon.com > > > > > -- > -Geoff Endresen > Amazon.com > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
