Synopsis As a part of this project we would be upgrading the salt infrastructure in all our managed cloud platforms (mcp). Currently we have mixed versions of salt across board and one of the deliverables of this project is to have consistency in all mcps. Please look below for the list of deliverables of this project. Deliverables Upgrade all salt-master and salt-minions to...

Read More...

Puppet was used for configuration management. Puppetmaster is deployed on a CentOS server. Windows Servers on which Prognosis needs to be installed are Puppet Clients. Puppetmaster is listening on port 8140 via apache. Just for troubleshooting, once you've vpn'ed to the AF1 MCP cloud network, you can open a browser and visit https://10.192.117.11:8140 As of now, the automation involves the following. Note that...

Read More...

This is part one on how to install a Puppet Server using Passenger (mod_passenger) with MySQL (for stored configurations) on Red Hat Enterprise 5. In this first part we will get a Puppet/WEBrick server serving a single Puppet client. Firstly, ensure the FQDN (i.e. puppet.tomhayman.co.uk) is set up properly on the server otherwise your Puppet clients will not be able to connect. In...

Read More...

Creating Manual Reports for Exchange (Per Customer Basis) Log onto an Exchange server (bf-nrd-exd2-11 or -12). Open up Exchange Power Shell as you'll be running the below PowerShell scripts to reveal the following: As an example, I've used Phil Hoffman Travel to run the report. This gives your mailbox sizes of all users under the company get-mailbox -OrganizationalUnit "bluefire.bfms.local/Customers/Adam Internet(AI1)/Phil Hoffmann Travel(190102)" |...

Read More...

Swapping an SSL Certificate The following instructions will walk you through how to upload, install and bind and an SSL certificate to a virtual server hosted off a NetScaler. Things Required Icon Certificate file Key File As you can see from above this guide is assuming that you have a CRT file. Okay, let's begin; start by logging onto the NetScaler that you'll...

Read More...

This is a how-to focused on migrating from one LUN to another LUN where Oracle data is stored on ext3 or ocfs2 filesystems. This is not relevant to ASM filesystems. Once your new LUN has been provisioned by storage there are two ways to discover the new LUN(s)    1. Force a scan of the SCSI bus - this can be done uptime...

Read More...

What is Oracle_Path ? ORACLE_PATH is an environment variable (Linux and Windows) that specifies the path to look down when calling sql scripts from within, or calling, a database session. For example: ORACLE_PATH=.:/u01/oracle/admin/dba/sql; export ORACLE_PATH OS(/home/oracle): sqlplus @who.sql With ORACLE_PATH set it will look in the current directory, /home/oracle, and if not found then in /u01/oracle/admin/dba/sql. This is a very useful env variable...

Read More...

1) Install VNC, GNOME RPMs yum install gnome* vnc-server firefox 2) Create the dba Group groupadd -g 490 dba 3) Create the oracle User useradd -c "System - Oracle" -m -G dba -u 499 oracle 4) Set the oracle user's password passwd oracle **NOTE: provide the oracle user's password to the DBA so they can reset it to their standard. 5) Become the...

Read More...

Guide to Advanced Linux Command Mastery, Part 2 In Part 1 of the series, you learned some useful commands not so widely known and some of the often used commands but not-so-well-known parameters to do your job more efficiently. Continuing on the series, now you will learn some slightly more advanced Linux commands useful for Oracle users, whether developers or DBAs. alias and...

Read More...