Submitted by dmann on Thu, 10/04/2018 - 17:24
If you have clients connecting to a server and the clients don't specify a specific encryption algorithm in SQLNET.ENCRYPTION_TYPES_CLIENT, be aware that the order of the algorithms listed in SQLNET.ORA on the server side matters...
If you don't specify SQLNET.ENCRYPTION_TYPES_CLIENT from a 12.2 client configuration, a SQLNet client side trace shows the following possibilities, the choices are listed from most secure to least secure:
(3775811968) [04-OCT-2018 19:47:44:284] nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_CLIENT" parameter
Submitted by dmann on Thu, 06/28/2018 - 12:40
I've been diving into more OEM Automation and collecting information here.
While the Oracle example scripts are a great way to find out how to interact with OEM via the emcli and python/jython interface, there doesn't seem to be much info about how this all gets done. You feed a Python script to emcli and magic happens right?
Adeesh Fulay has a great intro article here.
Submitted by dmann on Fri, 02/24/2017 - 17:03
After 4 unexplained crashes and a stalled Sev 1 SR I was pulling my hair out. Particularly vexing was the fact that a user was running a distributed query which was crashing a remote database.
I isolated the 4 crash times for the remote database and I wanted to see what users and SQLs were running on the local database up until the crash time. So for a crash happening around 11:16 I would use the following query.
Submitted by dmann on Thu, 09/15/2016 - 17:49
To troubleshoot a problem I needed to copy a database's worth of files out of an ASM diskgroup and onto the filesystem. I searched around and checked help for ASMCMD assuming there was a recursive option. I found references to one in some places on the interwebs, even official Oracle references to it like Unable To Copy Directory Using ASMCMD Cp -r Command (Doc ID 829040.1) but struck out when trying to do this on 11g and 12c ASM installs.
Submitted by dmann on Wed, 04/27/2016 - 12:24
I recently came across a legacy database that was using Oracle FLOAT datatype for Primary and Foreign Keys. As the database needed some attention I was asked to get data types in order and get rid of the FLOATs in favor of NUMBER data types.
Submitted by dmann on Tue, 03/08/2016 - 11:23
I've gotten a lot of mileage out of my old SQL Developer Archive Log Count Heat Map report that I created in SQL Developer. I was recently asked to estimate the amount of redo that might be sent to a DataGuard standby. Searching The Google for this and I found some methods for calculating Network Bandwidth but I wanted to start with raw redo generated from an instance using information from v$archived_log.
Submitted by dmann on Mon, 02/08/2016 - 12:06
I was recently asked to update the EBS Plugin from 184.108.40.206.0 to 220.127.116.11.0 in my Cloud Control 12 setup. During the prereq steps I got an error: "EM-04050: The selected plug-ins cannot be deployed on the Management Server because there are some Management Agents on which incompatible versions of these plug-ins have been deployed."
Submitted by dmann on Fri, 03/06/2015 - 12:20
This second vizualization is more of a workflow proof of concept compared to some novel visualization but I can guarantee you haven't seen the SCOTT.EMP table like this before. I have wanted to combine my two favorite tools for a while. Here is how you can drive a d3.js visualization directly from a SQL Developer custom report.
Submitted by dmann on Thu, 03/05/2015 - 11:26
Submitted by dmann on Wed, 08/06/2014 - 00:58
The first visualization I will be working on is something I have been wanting for a while. I need a way to quickly show SQL Statement performance over time for 1 statement, especially to identify Execution Plan volatility. When researching performance problems I often need to quickly digest historical performance of a trouble statement - a statement that usually has run fine for years but now has started acting up.