Install SQL Server Management Studio (SSMS) 2016 Without Internet Access: One of my frustrations with SQL Server 2016, is that the SQL Server Management Studio (SSMS) is no longer included with the database instance installation. It is now has its … Continue Reading →
REPVFY INSTALL Error: ORA-12545
While working on an issue with Oracle support for our Oracle Enterprise Manager 12c, I was asked to install the EMDIAG REPVFY Kit for Cloud Control 12c. When I attempted the … Continue Reading →
Upgrade SQL Server 2012 Standard to Enterprise with Different Service Packs
In October 2013, I wrote about how to “Upgrade SQL Server 2012 Standard to Enterprise“. Recently in the comments section, Leo asked “Is this impacted by service packing?”. This is … Continue Reading →
Error 0xc0204016: SSIS.Pipeline … The length must be between 0 and 8000.
About once a year, I am asked to import some text files into a table in a SQL Server database. To accomplish this, I am using the SQL Server 2008 … Continue Reading →
BCP with No Output & No xp_cmdshell
My problem was that I needed to create a cvs file with an older version of a SQL Server database. My plan was to use the BCP utility to create … Continue Reading →
Run Level Requirement for Oracle on AIX
While performing the preinstallation tasks for an Oracle database on the AIX operating system, one of the requirements in the documentation asked that I “Ensure that the system is started … Continue Reading →
DIA-49424: Directory outside ADR not allowed
Working with the Automatic Diagnostic Repository Command Interpreter (adrci), I wanted to add a trace file to an incident package. When attempted I received the following error: The Simple Answer: … Continue Reading →
“SQLPLUS /” – ORA-01017: invalid username/password; logon denied
While working on my shell scripts, I hit a snag when I want sqlplus to authenticate using my operating system account without entering the login credentials. When I tested “sqlplus … Continue Reading →
Checks if GVM Performance collection job is running
While upgrading to the Oracle Enterprise Manager 12c on a Linux virtual server, I encountered an error on the Database Connection Details screen. An error box popped up with the … Continue Reading →
OS Kernel Parameter: swappiness Warning
Recently I was installing the Oracle Grid Infrastructure – 11g2R on a virtual Linux server. When the install process came to the Perform Prerequisite Checks screen, I received a warning … Continue Reading →
Restoring to a Different ASM Diskgroup
Recently, I wanted to restore my Oracle database on a different server in a different ASM diskgroup. Sounds simple but I was tripped up on the syntax. Before I started … Continue Reading →