Linux Oracle Database Connection Test Script

Database connection testing scripts are out there, but not all of them provide a one stop way to test more than 1 node of the RAC at the same time.  Sure you can do simple tests using “tnsping”, “nc -z” or even “telnet” to confirm the listener is up.  Actually testing a login is a […]

virtualbox

Compressing a Windows Guest Running In VirtualBox

VirtualBox is my favorite go to quick virtualization tool. Its versatile and can run on many host platforms as well as support many guest platforms (windows/linux/aix/solaris..). For those who can’t afford licensing for a VMware cluster, standing VirtualBox up on a beefy server and partitioning out its proc/mem is a perfect solution for a sandbox. […]

How to run a sosreport

Working with Oracle Support as much as I have you get asked to run a variety of commands to collect diagnostic data. I will have a series of posts describing the different tools used to collect data across a number of different platforms. Today we will start with SOSREPORT. sosreport – this tool captures important […]

EM12c EMCLI

Below is a snippet from a script that I have written and used. It has worked flawlessly for deleting assets using emcli from em12c.  It saves time and helps remove the sub targets that the agent has under it.  The script will be located on the DOWNLOADS page. *** UPDATE *** Script uploaded 12/8/2015 and […]

Downgrading ZFS Appliance Software

What is a ZFS appliance? Oracle ZFS Storage Appliance is a hybrid storage system based on a unique cache-centric architecture featuring massive DRAM plus Flash, and is powered by a multithreaded SMP operating system. As a result, 70 to 90 percent of I/Os are served from DRAM, enabling customers to use Oracle ZFS Storage Appliance […]

Upgrading ZFS Appliance Software

What is a ZFS appliance? Oracle ZFS Storage Appliance is a hybrid storage system based on a unique cache-centric architecture featuring massive DRAM plus Flash, and is powered by a multithreaded SMP operating system. As a result, 70 to 90 percent of I/Os are served from DRAM, enabling customers to use Oracle ZFS Storage Appliance […]

Uploading ZFS Appliance Software Patch

What is a ZFS appliance? Oracle ZFS Storage Appliance is a hybrid storage system based on a unique cache-centric architecture featuring massive DRAM plus Flash, and is powered by a multithreaded SMP operating system. As a result, 70 to 90 percent of I/Os are served from DRAM, enabling customers to use Oracle ZFS Storage Appliance […]

Setting up EMCLI for EM12C

The EMCLI tool provides the administrator a wide variety of commands and ways to manage the OMS, AGENTS and more.  Below are the steps to implement EMCLI.  Follow the BOLD statements with of course minor adjustments such as hostname/port…etc for your own environment. [oracle@mwlab01-lin01 scripts]$ wget https://mwlab01-em12c:7802/em/public_lib_download/emcli/kit/emclikit.jar –no-check-certificate –2014-09-15 13:24:31–  https://mwlab01-em12c:7802/em/public_lib_download/emcli/kit/emclikit.jar Resolving mwlab01-em12c… 192.168.1.110 Connecting […]

Resize Exadata /u01 Filesystem

For those of you whom have never performed this type of activity, please reference the Oracle Support document 1357457.1. 1) Grab the current sizing of /u01 filesystem [root@DM01DB01 ~]# df -h |grep -i u01 Filesystem Size Used Avail Use% Mounted on /dev/mapper/VGExaDb-LVDbOra1 99G 16G 78G 17% /u01 2) Stop your oracle databases, oracle crs, monitoring […]