Thursday Jun 07, 2012

AWS EC2 Oracle RDB connection to Oracle Database Instance

Provisioning my Oracle database instance to AWS EC2 RDB was easy. Just a few clicks! However, getting my connection to my Oracle cloud database was not as easy. A couple things that are not obvious (using Oracle SQL Developer):
1. Need to set up a database security group.
2. Need to use end point for the host name.
This video is the best one on the internet to explain both points:
Youtube video on Oracle AWS RDB

Oracle Cloud offering - What makes it unique ?

Three things that make Oracle cloud offering unique:
1. SaaS, PaaS and IaaS offerings
2. Private and Public cloud offerings
3. Ability to seamlessly move between private and public cloud

Tuesday May 29, 2012

Public Cloud, co-location and managed services ... what is the cloud?

Recently I have had conversation with a number of people that are selling and implementing 'cloud' solutions. I put cloud in quotes as implementations like co-location (aka co-lo) and managed services (sometimes referred to as 'your mess for less') have become popular options for companies moving to the cloud. These are obviously not pure public cloud offerings and probably more of hybrid cloud implementations as the infrastructure (PasS and IaaS)is dedicated to a specific customer. This eliminates the security, multi-tenancy, performance and other concerns that companies have regarding public cloud.

Are co-location and managed services cloud to you? Are they something your company is considering when you think about cloud ?

AWS secure FTP

I was looking for this information a couple we back. Should have just went to the Oracle web site:
AWS SFTP to upload files

Monday May 28, 2012

Hana Vs Oracle in memory databases

The debate continues:
Hana Vs Oracle

noSQL Hadoop addes ACID with HBase HDFS

noSQL / Hadoop gets ACID and random read access using HBase:
HBase on Apache
However, as this document notes:
1. Relational databases still have many features like typed columns, secondary indices and transactions.
2. Moving from an RDBMS to HBase is not simple. It is an application re-write for the most part.

Wednesday May 23, 2012

Oracle IT agility versus architecture podcast

Oracle OTN ArchBeat Agility Vs. Architecture Podcast discussion group podcast
Podcast discussion with 5 Oracle architects world wide

Tuesday May 22, 2012

The COBOL Brain Drain

Cover Story in this edition of Computerworld:
COBOL Brain Drain
Some notable things from article:
1. 48% of companies still use a lot of COBOL. The highest language usage beating even Java!
2. COBOL is being used in 53% of cases for new applications.
3. Move off mainframe / COBOL is not happening any time soon (this is my interpretation) as the article mentions this a couple times 5-10 years people will start
to retire...which means more like 10-15 years.
4. Thought this was funny but sad. US government had IBM look at a System/36 environment to see if should be migrated off this system. IBM concluded it would
be to complicated and costly. This is like hiring Microsoft to see if you should move from Window/SQL Server to Linux/Oracle.

Monday May 21, 2012

Oracle Fusion in the cloud

Great quote in this article, "Let somebody else have the headaches":
Oracle Fusion in the cloud

Friday May 18, 2012

Oracle OpenOffice ... career day name recognition

Interesting at the middle school career day. Only two kids out of fifty recognized the company name of Oracle. The reason why.....OpenOffice. Who would have thought?

Cloud Defined for grade school kids

Cloud Defined

"Cloud computing is the next stage in the Internet's evolution, providing the means through which everything — from computing power to computing infrastructure, applications, business processes to personal collaboration — can be delivered to you as a service wherever and whenever you need."

"When I can get access to all my files on all my different computers when I am at the coffee shop".

"Internet-based applications"

"Shared computer resources that can be accessed from anywhere, created by end users, be expanded and deleted as needed, and paid for as by how much you use (or free).

Example Cloud (consumer) Applications

1. Youtube -

2. Flickr -

3. Apple iCloud

4. Facetime

5. Zoho Writer -

6. Google, GMail -,

7. Skype -

8. MapMyRide -

9. Dropbox -

10. Blogs -

11. Twitter -!/migrating2cloud

12. LinkedIn -

13. Gaming

14. Gmail contacts -

What is migrating to the Cloud

Moving applications and/or information for local devices (iPads, PCs, laptops, smart phones, cell phones etc) to a location that is accessible through the internet.

Examples include:

1. Moving games that can only be played on a Wii, iPad etc. to allow them to be played by players all over the world.

2. Moving word processing applications like Microsoft Word to a browser environment like or Google Docs.

3. Moving all of you friends contact information from an address book, cell phone storage to Google contacts.

4. Moving you calendar from a daily calendar to Google contacts.

5. Moving your dairy from the 'book under your clothes in your dresser' to

Example Cloud (enterprise) Applications

1. -

2. Amazon Web Services -

3. Terremark -

Cloud Questions

1. What happened when the Internet/cloud went down ?

2. How can you continue to edit documents when the cloud is 'off line' ?

3. How can a file be shared with someone when the cloud is 'off line' ?

4. What are some ways to interact with someone (without video) using the cloud ?

5. What are some ways to share files and photos using the Cloud ?

6. How do you currently use cloud applications ?

7. How do you see yourself using the cloud after this session ?

8. What are some ways to interact with someone using video ?

9. How can you inexpensively interact with someone internationally using the c

Wednesday May 16, 2012

RISC to x86 migrations - Or CISC to RISC

Migrating from RISC based systems to x86 (CISC based systems) is another type of cloud migration along with application, database, and mainframe z/OS migrations. However, the steps, best
practices, process, methodology, and tools used are the same. The components of the current RISC based architecture that need to be migrated remain the same:
1. On line application
2. Batch application
3. Integration Infrastructure
4. BI and reporting
5. ETL processing
7. Operating System
Note on OS migration: Although an operating system migration is often assumed (UNIX to Windows/Linux) in a RISC to x86 migrations, this does not necessarily need to be the case as Solaris and HP-UX (announced) run on x86.
It may also be the case you are already running Linux on your RISC system so there is no need to migrate the OS. However, you will probably be upgrading to a
newer release of Linux.
8. Operating System scripts and tools
9. Application, network, database and operating system management and monitoring products and tools
10. Other infrastructure software such as DR, replication servers, gateways, back up and recovery ....
11. Hardware refresh - Of course, you will need to purchase, install, configure and test the x86 based hardware platform. This is a great opportunity to consider hardware infrastructure that is
better suited to the cloud such as blades (Dell, CISCO UCS, Sun/Oracle) or engineered systems (Exadata and Exalogic).
Ultimately the question is how long will it take, what are all the activities involved, and how much will it cost. The answer to these questions is based more on the OS migration that is being done
then the move from RISC to x86. Will the application language or 4GL product run on Linux/Windows? What is the impact of moving the database from one OS to another ? (this should be minimal as all major relational databases run on x86). The biggest impact (for the application migration) could be Unix specific KSH or CSH scripts. You may also be running management, monitoring, or older job scheduling tools that
only run on UNIX/RISC.
As you can see, nothing is different here from what I have blogged about regarding mainframe, client/server, and application cloud migrations.
Intel has a comprehensive RISC migration white paper here:
RISC Migration

Tuesday May 08, 2012

Who is making the decison to move to the cloud ?

Some evidence to support the business community and financial organization are deciding on when to move to the cloud:
Cloud migration decisions

Migrating legacy client/server and mainframe technologies to the Oracle cloud.


« June 2016