Connecting to your AWS Instance with SSH

If you're using our AMIs from the Amazon Marketplace you might need some guidance on connecting using ssh. We've put together the steps below as a guide to help.

How to SSH using Mac/Linux

1. In (more...)

clckwrk Design Blueprint: Oracle e-Business Suite on AWS

Moving to the Cloud Made Simple: A Framework for Oracle e-Business Suite in AWS 

We wouldn’t blame you if you’re not 100% ready to jump into the Cloud, just because that’s what everyone else seems to be doing. Making the right decision for your business means taking a careful look at what exactly the benefits are going to be. How will your systems work in the Cloud? Can Cloud providers like AWS actually meet your (more...)

Navigating the Oracle Licensing Policy Update: A Look at the Facts

If you’re like us, then you’re never far from the pulse when it comes to changes in software licensing. Keeping up to date with this is a safe way to be sure that you’re making the best decisions for your business when it comes to saving costs and operating efficiently. 

The change that we all seem to be struggling to digest is Oracle’s January 2017 update to its online policy document, “Licensing Oracle Software (more...)

Sharing your Files Securely – A How-to Guide for AWS S3


Whatever your industry, this is sure to be something you’ve come across before. You need to share a file with an external business – it might be a client, a partner or an agency. In the old days, we’d just fire it across as an email attachment. But more businesses working together closely means large volumes of confidential information being shared more frequently. 

It’s something that comes up for us pretty regularly. The files (more...)

Oracle Enterprise Linux 6.6 AMI Available on AWS

We've had a number of requests for versions of our OEL AMI. The version for 6.6 has been released to the AWS Marketplace now, you can access it at this link

We're also planning to align the updates to the AMIs with our own internal updates. This will mean that the AMIs will be updated to the latest security updates for the point release on a quarterly basis. We want to make sure this (more...)

Enterprise Workloads – what can the cloud do for me?

What exactly can the Cloud do for me? 

We wouldn’t blame you if you’re bored of hearing it: if it’s in the cloud, it must be better. But…why is it better? Before you go ahead with a decision like this one, you’ll want to look at specific, concrete examples of the practical benefits of cloud-based hosting. A solution that matches the needs of one business isn’t guaranteed to be the perfect match for another. (more...)

Oracle Enterprise Linux – Pre-Built for Enterprise

We've shared the AMI we use for running Oracle Enterprise Products like e-Business Suite. You'll find it on the AWS Marketplace pre-loaded with all the pre-requisites you need for your Oracle implementation on AWS.

Link to the Marketplace...


Optimising AWS for Oracle – Licenses


If you're keeping an eye on the Oracle license rules you'll know that you need to make sure that when you're designing in AWS you make the most of every CPU that has an Oracle license attached too it.

Here's our rundown of how to design and use AWS features to maximise those licenses.

  • Design for zero waste. In the past we might have Oracle nodes that didn't do very much. Those DR servers, or (more...)

NFRs are easy – what about your NFO’s?

You're used to working on your Non-Functional Requirements (NFR's) - we're used to worrying about how secure our systems are, how many users they will support, how resilient they are to the failure of a component. What we're not used to thinking about are Non-Functional Opportunities - (NFO's) what are the unforeseen benefits that the business will find when they use IT?

The cloud blows the non-functional requirement (NFR) out of the water. You want (more...)

G-Cloud – Moving Your Oracle System to Amazon Web Services

G-Cloud was awarded a few weeks ago and we're glad to say that clckwrk were selected as a supplier in the areas of Infrastructure as a Service and Specialist Services.

The services we have on G-Cloud are specifically curated for implementing, moving and managing Oracle systems to the cloud. This is a quick guide for how to combine those services to migrate to the cloud. For public sector users of Oracle technology and applications this is the set (more...)

clckwrk Design Blueprint: Peoplesoft Campus Solutions on AWS

Higher eduction establishments around the world use Peoplesoft Campus Solutions from Oracle to manage their key business processes. 

In this reference architecture we look at the key requirements for Campus Solutions and the technical solutions that can be deployed on the Amazon Web Services Cloud. 




Availability: Campus solutions needs a high availability infrastructure to ensure that both the administrative and student users can access data at all times. This solution uses multiple web and (more...)

Its what we do at clckwrk…

At clckwrk we have a pretty simple way of looking at what we do:
  • Discovery: Finding out about your IT and your plans for the cloud; what you have, what works, what doesn't, where you want to get too
  • Design: Working on the way things should be; what things will look like in the end, what steps will get us there, making sure everything continues to work along the way
  • Build: Getting it (more...)

Oracle Licensing Costs on AWS, Self Managed vs RDS

When you move your Oracle database to AWS there are a number of ways to handle licensing. You can either:

  1. Bring your own licenses for a self managed Oracle installation on an EC2 instance 
  2. Bring your own licenses for an Oracle Relational Databases Service instance
  3. Use pay as you go licensing for an Oracle Relational Database Service instance
Of course you need to be sure that you’re getting best value from your licenses - in (more...)

clckwrk Quick Guide: Oracle DBA – Managing the Alert Log on AWS

At clckwrk we managed Oracle on the AWS Cloud. First rule of being a DBA - check the alert log.

The database alert log is the file where the database logs core activity and any messages that the DBA needs to understand what the database is doing, any tuning that needs to happen at the database level and any errors that the database is producing. It's the errors that are critical for us as they (more...)

clckwrk Quick Guide: Run your DR solution for the cost of a backup – ERP in the AWS Cloud

In this blog we're looking at a cost effective method for disaster recovery in the AWS cloud. The key here is that the cloud gives you on-demand infrastructure so there is no need to have any servers, storage or networking kit patiently waiting for the DR button to be pushed, instead you can hold just the definition of the technology and a recent backup of your data and build the necessary infrastructure just when it is needed. 

(more...)

Slashing the costs of your databases … choosing your PaaS or Next Gen Database Platform

Do you want to lower the costs of your database estate? Are you trying to stay inside the license purchases you’ve made? Maybe looking to simplify the admin across servers, storage, networks and DBA?

It’s a question we get asked over and over in a world where there are great advantages in adopting the next generation of Platform as a Service (PaaS) and Next Generation database platforms. Seeing AWS park its tanks on Oracles lawn (more...)

clckwrk Quick Guide: Backing up Oracle databases on AWS using snapshots

Did you take a backup first? Of course you did.

In this post we look at one way to simply back up your Oracle database in the AWS cloud. We're planning on making this the first in a series of Quick Guides for working with Oracle and public cloud. We hope you like it, please follow, comment or like if we're hitting the spot!


This example uses a self managed database, rather than RDS, so (more...)

Protecting your data in Oracle – now you see it, now you don’t!

In this article Peter Berry from clckwrk shows how smart use of Oracle and AWS functionality can secure sensitive data in production and and automatically obfuscate when that data leaves the server.

Data security is a key concern for all businesses. Ensuring your data is secure in your production system and that data leakage is controlled is typically addressed by encryption and obfuscation respectively. Encryption can be difficult to deploy and costly while obfuscation can (more...)

When should you use Oracle RAC?

Over the past years we've worked on many Oracle projects, some with RAC, some without, some which intended to implement RAC and failed, and some which implemented poorly and ripped it out at the last minute. 

For those new to Oracle, RAC is the Real Application Cluster option for the database which lets you cluster the database servers. The main reason for using for RAC is that it brings resilience to a system, it (more...)

What DBAs need to know about Amazon RDS

We’re looking at many customers who are considering moving from on-premise  databases to cloud hosted  instances running Oracle. This is a pretty well trodden path in cloud terms and also in Oracle terms - you go through the same process with Oracle as you would have if you moved from one piece of hardware to another in the past - it’s a platform migration and sometimes you’ll upgrade the database as you go. After that (more...)