Active SQL Statements on Oracle

October 2, 2018

This query can be used to show the active SQL statements, and their elapsed time, on an Oracle database.

SELECT nvl(ses.username,'ORACLE PROC')||' ('||ses.sid||')' USERNAME,
   SID,   
   MACHINE, 
   REPLACE(SQL.SQL_TEXT,CHR(10),'') STMT, 
  ltrim(to_char(floor(SES.LAST_CALL_ET/3600), '09')) || ':'
   || ltrim(to_char(floor(mod(SES.LAST_CALL_ET, 3600 ...

Buzz Controllers on Windows 7

September 30, 2018

I've been playing with Playstation Buzz controllers on Windows 7. The first set I tried had black buttons with coloured borders, and this device worked fine. The second set had solid coloured buttons and these didn't work out of the box, I needed to do some messing. Both ...

Puppet Reference

August 3, 2018

Applying configuration

  • sudo puppet agent -t --noop - Pull config from puppet master, pretend to make changes
  • sudo puppet agent -t - Pull config from puppet master, make changes

Modules

  • puppet module list - list modules
  • puppet module install puppetlabs-postgresql --version 4.9.0 - install forge module into local puppet master
  • puppet job ...

Security Group not found in VPC

July 24, 2018

I got the following error whilst creating an EC2 machine using terraform:

* aws_instance.drumcoder-web: Error launching source instance: InvalidGroup.NotFound: 
The security group 'admin-access-security-group' does not exist in VPC 'vpc-0d12345'
    status code: 400, request id: abc123

Looking at the AWS console, the security group did exist and was in the ...

Terraform: run script on new server

July 22, 2018

I'm provisioning a new machine on AWS using terraform, and I want to use puppet to configure it. I don't need to have a puppet server, I just want to put a puppet file onto the machine and then execute it with puppet.

Terraform

The initial terraform script ...