blog.oracle-ninja.comAndy Colvin's Oracle Blog

Me Presentations Scripts OJVM and DBA_REGISTRY_SQLPATCH I woke up this morning and did what I do most days – doomscroll through twitter. One of the benefits of being in the US is that there are usually some interesting discussions going on with people I follow in Europe. I saw an interesting question from Martin Berger: I’ve had my fights with datapatch… Read More » Category: Oracle Tags: datapatch , Exadata Critical Patch , OJVM , opatch , Patching RAC, Data Guard, and Password Files When moving from one system to another, one of my favorite migration methods is using data guard. It has its restrictions – the destination should be the same platform (exceptions noted in MOS note #413484.1), same version unless you’re performing an upgrade, and that a block-for-block copy of the database is acceptable. Utilizing data guard… Read More » Category: Exadata Oracle Tags: data guard , Exadata , RAC Oracle Cloud Infrastructure – Unusual Activity Announcements When logging in to an OCI tenancy, I noticed something interesting – there was a message bar at the top of the console reporting Unusual traffic detected.” It turns out that there were a couple of instances in a compartment that were showing signs of potential compromise. Here’s the alert that we received when we… Read More » Category: OCI Tags: OCI , Oracle Cloud , security SCAN Hostname Resolution and Domain Names I spoke with a customer that mentioned they were moving an Exadata rack from one datacenter to another and they had a few questions about what needed to change in order to complete the move. The customer wanted to make the move as much of a lift and shift” as possible, avoiding the need to… Read More » Category: Exadata Oracle Tags: Exadata , networking , RAC , SCAN Restarting Autoupgrade Jobs When the Instance Won’t Restart When upgrading databases, my preferred method of late has been the autoupgrade tool. Autoupgrade gives DBAs the ability to upgrade databases in batches, automatically performing prechecks, postchecks, and custom database tasks during the upgrade process. Autoupgrade can be downloaded from MOS note #2485457.1, and tests shown here used the most current version at the time… Read More » Category: Oracle Tags: 19c , autoupgrade , autoupgrade.jar , database , upgrade Server-Side SSH Timeout Settings with host_access_control As part of the process to get an Exadata rack ready for running 19c databases, many clusters have to go through an upgrade from Oracle Linux 6 to Oracle Linux 7. As part of that upgrade, Oracle took the opportunity to make several configuration changes for security purposes. One of those changes relates to the… Read More » Category: Exadata Linux Oracle Tags: configuration , Exadata , security , SSH , Upgrades 19c Grid Infrastructure Upgrade Failures with OEDACLI As part of an ongoing project, I’ve been performing a fair amount of upgrades to 19c on Exadata systems. Several of those systems are virtualized, running Oracle VM (based on Xen). I’ve previously mentioned Oracle’s oedacli tool that can be used to make upgrades easier, and it’s been very useful once you are familiar with… Read More » Category: Exadata Tags: 19c , Exadata , GI , Grid Infrastructure , Patching , Upgrades Slow Exadata Compute Node Upgrades to Oracle Linux 7 One of the cool things that Oracle has done with Exadata is give users the ability to upgrade from Oracle Linux 6 to Oracle Linux 7 with an in-place upgrade process. This comes automatically when you upgrade the Exadata compute image from 18c to 19c. Upgrading the compute nodes to 19c give you the ability… Read More » Category: Exadata Tags: Exadata , ol7 , Oracle Linux , Patching , Upgrades OEDA Virtualized Cluster Discovery With SSH Keys As part of the Oracle Exadata Deployment Assistant (OEDA”), Oracle includes a command line utility to read and modify the XML files used for deployment of an Exadata cluster. Typical use cases are to install additional Oracle database versions, or to create multiple databases before deployment. There are several additional features included for virtualized clusters,… Read More » Category: Exadata Tags: Discovery , Exadata , Installation , OEDA , Patching , Upgrades OEM SSL Cipher Hardening Reset After Securing OMS I have recently been installing Oracle Enterprise Manager at several sites, and one of the key requirements has been to ensure that the installation isn’t using insecure HTTPS protocols. Securing the OMS and agents typically consists of two components – ensuring that only secure SSL ciphers are being used, and shutting down protocols that have… Read More » Category: Oracle Tags: 13c , OEM , security , SSL Post navigation ← Older posts Search for: Recent Posts OJVM and DBA_REGISTRY_SQLPATCH RAC, Data Guard, and Password Files Oracle Cloud Infrastructure – Unusual Activity Announcements SCAN Hostname Resolution and Domain Names Restarting Autoupgrade Jobs When the Instance Won’t Restart Recent Comments Martin J S on OJVM and DBA_REGISTRY_SQLPATCH Arun Yadav on SCAN Hostname Resolution and Domain Names acolvin on OEM SSL Cipher Hardening Reset After Securing OMS Johan on OEM SSL Cipher Hardening Reset After Securing OMS acolvin on Slow Exadata Compute Node Upgrades to Oracle Linux 7 Archives February 2022 April 2021 November 2020 May 2020 September 2019 August 2019 May 2019 February 2019 October 2017 March 2017 February 2017 October 2016 August 2016 February 2016 September 2015 July 2015 September 2014 May 2014 April 2014 March 2014 December 2013 September 2013 August 2013 June 2013 May 2013 March 2013 February 2013 October 2012 September 2012 August 2012 June 2012 May 2012 March 2012 January 2012 December 2011 November 2011 October 2011 September 2011 July 2011 June 2011 Categories Database Appliance Exadata Linux OCI Off Topic Oracle Uncategorized Meta Log in Entries feed Comments feed WordPress.org Copyright 2016 Iconic One Theme | Powered by...