Skip to content
TheSQLReport.com

TheSQLReport.com

Resolutions found with SQL Server and other types of databases

Primary menu

  • Home
  • SQL Server
  • Oracle
  • Teradata
  • AIX
  • Linux
  • Windows
  • SQL Saturday Presentations
  • About Me

Category: Oracle

Oracle database system

Upgrading Oracle errors out with ORA-04031: unable to allocate ## bytes of shared memory (“shared pool”

  • By BlogAdmin
  • 25 May, 2019
  • No Comments

While working to get my Oracle database upgraded to a supported version, using the DBUA I was getting the following errors: ORA-04031: unable to allocate 704 bytes of shared memory … Continue Reading →

ORA-00600: internal error code, arguments: [723], [140432], [960048], [memory leak]

  • By BlogAdmin
  • 16 August, 2018
  • No Comments

Recently, I was notified of this error in the alert log of one of my Oracle 12.1.0.2 databases: ORA-00600: internal error code, arguments: [723], [140432], [960048], [memory leak], [], [], … Continue Reading →

After Cloning a 12c Oracle Home – SQLPLUS error exec(): 0509-036

  • By BlogAdmin
  • 26 June, 2015
  • 10 Comments

Problem: After cloning a 12c Oracle Home to another AIX 7.1 server, I received the following error when I started SQLPLUS. $  ./sqlplus /nolog exec(): 0509-036 Cannot load program sqlplus … Continue Reading →

REPVFY INSTALL Error: ORA-12545

  • By BlogAdmin
  • 2 April, 2015
  • No Comments

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 →

Run Level Requirement for Oracle on AIX

  • By BlogAdmin
  • 1 December, 2014
  • No Comments

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

  • By BlogAdmin
  • 15 November, 2014
  • No Comments

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

  • By BlogAdmin
  • 18 October, 2014
  • No Comments

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

  • By BlogAdmin
  • 1 October, 2014
  • No Comments

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

  • By BlogAdmin
  • 9 September, 2014
  • No Comments

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

  • By BlogAdmin
  • 21 August, 2014
  • 4 Comments

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 →

Posts navigation

Page 1 Page 2 Next

Recommended Blogs

  • James Serra’s Blog Big Data and Data Warehousing
  • TF3604 Blog — Probing the internals of SQL Server
  • SQL Server World
  • Rottengeek?
  • Frugal Fixes
  • Ray Kim’s Blog
  • ClevelandDotNet

Recent Posts

  • Query – Percentage of Physical Memory SQL Server is Currently Using
  • Using Microsoft’s TroubleShootingScript Version 2 (TSSv2) Toolset to Collect Support Information
  • Error: 18452 – login is from an untrusted domain and cannot be used with Windows authentication
  • Excel Error: SSL Provider, error: 0 – The certificate chain was issued…
  • SQL Server – List of All Databases with Compatibility Levels

Archives

  • March 2023
  • February 2023
  • January 2023
  • July 2022
  • February 2022
  • December 2021
  • December 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • June 2013
  • April 2013
  • March 2013
  • January 2013
  • December 2012

Categories

  • AIX
  • Linux
  • Oracle
  • SQL Server
  • Teradata
  • Windows
TheSQLReport.com Copyright © 2023 TheSQLReport.com . All Rights Reserved.
Powered by: WordPress | Theme: Simple Catch