Showing posts with label windows. Show all posts
Showing posts with label windows. Show all posts

Tuesday, December 29, 2009

Windows in the Cloud

Last January I read a post by Mr. Dan Norris (not the UK guy), I bought my own server for $1.02 (USD!). The title is fairly self-explanatory, he fired up an instance at (in?) Amazon's EC2, did what he needed to do then shut down (terminated) the instance. Cost? $1.02. It was the first real world application I had seen of the cloud.

Shortly after that, Mr. Lewis Cunningham [ blog | twitter ] went looking for volunteers to provide feedback on a cloud book he was writing. He wanted those with experience and those without (me). I jumped on the opportunity and Mr. Cunningham accepted. Thankfully, the book went by the wayside, instead becoming a series of articles (which I can't seem to find) on his blog, because I had fallen behind...way behind.

Since then I haven't done a thing in the cloud (should I capitalize that?). Until today when a colleague asked about creating a test bed for OBIEE, Essbase and other software. I prefer having a big beefy machine at home that I can muck around with, but seeing as how I haven't had a job in a while and money is tight, I thought the cloud would be the best bet.

So I began to tinker.

To back up a little, one thing I always had problems with was connecting to the instance via Ubuntu (not sure if this was a me/Ubuntu issue or a cloud/Linux issue)...by problems I mean I was never able to connect.

Since we are talking about OBIEE and it can be a Windows only install (both server and client tools), I tried to see what I could do. First I looked to see if there were any OBIEE images (AMIs) out there. There was, but I needed some sort of subscription to that. So I fired up my own Windows Server 2003 (64bit) instance, downloaded java (JDK) and the OBIEE software.

Small side note, download speeds from there are AWESOME!

download speeds

I have 25 down and 15 up and home and I thought that was fast...we should really feel sorry for Kris.

How to Create an Instance using Amazon's EC2
First you'll need to create an account if you don't already have one. Then go to http://aws.amazon.com/. Find the AWS Management Console and click on that. Should look something like this:



On the lefthand side, you'll see a menu of actions.

AWS Console Menu

On the right side is your dashboard

AWS Dashboard

Back to the left side, choose AMIs

Select AMIs

That should take you to this page

AMI Home

Let's find some images.

First, pull down this drop down and select Amazon Images

Amazon Images

Then select your platform, Windows

Platforms

Select the amazon/Windows-Server2003R2-i386-Base-v108

Select Windows Server

Launch it

Launch it!

This will bring up the Request Instances Wizard, just go ahead and select the default and click on Continue

Wizard

Instance Details, I don't really know yet what this page is about, perhaps someone out there can enlighten me, but just go ahead and accept the defaults

Instance Details

Now we're on the Create Key Pair page. I have a couple of keys created but I'll walk you through creating a new one as well.

Create Key Pair

Select Create a new Key Pair

Create a New Key Pair

Name your new key "test_key" then select "Create & Download your Key Pair." Download the key to your Desktop.

Create and Download Key Pair

Next up, Security Group. This is probably what screwed me up previously, trying to connect to Linux instance. I was never sure where the key should reside. I followed all the instructions...I just couldn't get it to work.

With Windows, you need to add a Security Group so that you can RDP into the machine. The port is 3389, but the wizard will take care of that.

Windows Security Group

Name it whatever you want and down at the bottom, select RDP as the rule you want to add.

Add Rule

When you are done it should look something like this

Rule Added

Select continue and you get this nice little summary page

Summary Page

Click Launch.

Connecting to your Instance
It takes a few minutes for your server to start up. You may have to hit refresh in your management console to see it.

Once the instance has started up, you need to get the password. If you haven't waited long enough, you'll see this:

Password Not Available Yet

Be patient.

To retrieve your password go to Instance Actions

Get Windows Administrator Password

You'll be greeted with this

Decrypt Password

Enter the text from the key you downloaded to your desktop (note the screenshot says obiee_key, that's because I took this screenshot earlier today).

Enter Key and Decrypt

And here's your password

Password

Now open up Remote Desktop Connection (Windows) or your Terminal Server Client (Ubuntu), enter in the address, Administrator for the username and password you just generated.

Hit connect and you should be done!

Saturday, December 12, 2009

OBIEE: Install on Windows

This install on Windows is not significantly different than it is on Oracle Enterprise Linux, in an effort to maintain my Learning OBIEE page, I felt it necessary.

I know there are differences between the different flavors of Windows, but it certainly doesn't feel like it. I remember installing a 9i EE Database on XP Home 6 or 7 years ago, that was kind of fun.

I'll stop blathering on.
OBIEE: 10.1.3.4
Host: Ubuntu 9.04
Virtual stuff: VirtualBox
Guest OS: Windows Vista Ultimate

From what I understand, OBIEE was originally intended for Windows (Server) environments. All of the client software runs on Windows only. The Server software runs on both *nix and Windows.

So no matter what, I could not avoid a Windows installation. Part II of Installing on OEL would be "Installing the OBIEE Client Software", which is this post. I will not only be installing the Server components, I will be installing the Clients Applications too.

I'll stop blathering on...part II
I've already installed Java 6.

I've located my setup.exe file and start the installation



Next

Specifying the directories, I accept the defaults. I'm also using OC4J. Next.



Complete. Next.



Point to the SDK, enter in my oc4jadmin password...hopefully I'll remember it this time.



Accepting the default, you don't need to enter anything here.



I am setting all the services to start manually. This is a virtual machine and do use it for other things. Next.



English. Next.



Summary. Next.



It's now running.



Small side note, OBIEE installer reported 100% within minutes of starting. It reported 100% completion for about 30 minutes.

Yeah, done. Some notes on OC4J. Next.



Restart your computer. Finish.



Almost 32 minutes to complete.



I've restarted the machine. 0C4J is started automatically (you can turn this off, and I will...eventually)



Now, go into your Services applet. To get there, go to Control Panel --> Administrative Tasks. There you should see an icon that says Services. Scroll down until you see the services that begin with Oracle.



All of these are stopped (trust me).

First up, start the Oracle BI Java Host Service







Next is the Oracle BI Presentation Server







Now let's test them out. Go to http://localhost:9704/



Good.

Now let's login. On the right side of that page, click on Launch. Enter the oc4jadmin password you submitted during installation.



That should take you here



Now for BI Publisher



Check.

And Analytics?



Check.

Applications
Now I just want to make sure I have all the applications.

Administration Tool



Check.

Catalog Manager



Check.

I'll save all the connecting of all the parts for a different post.