by Sean Scott | Feb 4, 2020 | Scripts and Tools
When automating things on database hosts you may want to run something against all the databases in the oratab file, all the instances running on the host, or to capture that information for some purpose. Here are some one-liner scripts I use to generate a variety of...
by Sean Scott | Feb 4, 2020 | Scripts and Tools
When automating things on database hosts you may want to run something against all the databases in the oratab file, all the instances running on the host, or to capture that information for some purpose. Here are some one-liner scripts I use to generate a variety of...
by Viscosity North America | Jan 22, 2020 | News
January 22, 2020, Dallas TX – Viscosity, a leading Oracle-centric IT solution consulting firm, is proud to announce and welcome Gary Gordhamer and Sean Scott. Gary will fulfill the role as Managing Principal Consultant and Sean as Principal Consultant. Both...
by Sean Scott | Jan 11, 2020 | Oracle Cloud
Oracle introduced rpm installation of database software with version 18c. It’s a fast, easy way to install an Oracle home and even configuring a database. These instructions describe the method for the rpm install on Oracle on Oracle Linux or Red Hat Enterprise....
by jczuprynski | Dec 21, 2019 | #OOW19, #OOW20, #ThinkAutonomous, ADW, ATP, Automatic Indexing, AutoML, Oracle 19c, Oracle 20c
Dude … Where’s My Decade? If anything sums up my IT career’s arc since 2010, I’d say it’s that phrase. Somehow, I’ve managed to keep my head above water through the transition from HDD to SSD, from custom-built servers to Exadata...
by Sean Scott | Dec 19, 2019 | Scripts and Tools
In RAC, services can be “pinned” to specific nodes. This allows DBAs to control activity on individual nodes and even force different types of activity to run on a particular node. For example, in a three node cluster I might configure a transactional service to hit...
by Sean Scott | Dec 12, 2019 | Oracle Cloud
I encountered a situation that may be a bit of an edge case, but it’s worth mentioning and monitoring for since it resulted in failure of a database node.tldr;We encountered the error “cannot create temp file for here-document: No space left on device” on a filesystem...
by Sean Scott | Nov 13, 2019 | Uncategorized
If you’ve new to Oracle Cloud Infrastructure, one of the first tasks is to connect to the hosts you’ve created in OCI. In this post I’ll cover two methods for connecting via SSH, and how to create a VNC connection.I’ll also discuss how to solve issues I encountered...
by jczuprynski | Oct 10, 2019 | Uncategorized
Yes, I know I’m late … but I’d like to take a brief break between testing out Autonomous Database intensely to shout out a big thank you to all the folks at Oracle and within the Oracle GroundBreakers community – ACEs, Java Champions, and...
by jczuprynski | Sep 1, 2019 | Uncategorized
I’m getting excited for the chance to present at and engage with my fellow professionals at the upcoming 2019 East Coast Oracle Users Conference (ECO2019) in Raleigh, NC during the week of October 28, 2019. ECO2019 is jam-packed with four pre-conference...
