Year: 2024

SQL Server 2014 Tutorial – List all the databases in SQL Server using Query

AbundantCode 1 year ago in SQL Server 1

Problem Statement You need to list all the databases that are present in the current SQL Server instance. Solution The list of all the databases from the SQL Server instance can be obtained from the sys.databases object as shown below. 1. Open SQL Management Studio and connect to the SQL Server instance with your login details. 2. Click the “New Query” button and enter the…

Raima RDM Error -13021 eTFS_NOTRANS

AbundantCode 1 year ago in Raima RDM 0

In this blog post, let’s learn about the error message “-13021 eTFS_NOTRANS” in Raima RDM and the description of the error message. Error Message -13021 – eTFS_NOTRANS Error Details Transaction not active

How to fix the Oracle error TNS-12515: TNS:listener could not find a handler for this presentation?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorTNS-12515: TNS:listener could not find a handler for this presentation with the details on why you receive this error and the possible solution to fix it. Oracle Error Description TNS-12515: TNS:listener could not find a handler for this presentation Reason for the Error TNS-12515: TNS:listener could not find a handler for this presentation Cause: None of…

How to fix the Oracle error TNS-12155: TNS:received bad datatype in NSWMARKER packet?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorTNS-12155: TNS:received bad datatype in NSWMARKER packet with the details on why you receive this error and the possible solution to fix it. Oracle Error Description TNS-12155: TNS:received bad datatype in NSWMARKER packet Reason for the Error TNS-12155: TNS:received bad datatype in NSWMARKER packet Cause: Internal error during break handling. How to fix the Error TNS-12155:…

How to fix the Oracle error PRVF-07593: CRS is not found to be installed on node “{0}”?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorPRVF-07593: CRS is not found to be installed on node “{0}” with the details on why you receive this error and the possible solution to fix it. Oracle Error Description PRVF-07593: CRS is not found to be installed on node “{0}” Reason for the Error PRVF-07593: CRS is not found to be installed on node “{0}”…

How to fix the Oracle error ORA-51193: invalid parameter value?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-51193: invalid parameter value with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-51193: invalid parameter value Reason for the Error ORA-51193: invalid parameter value An invalid parameter value was supplied in a call to the DBMS_IR package. How to fix the Error ORA-51193: invalid parameter…

How to fix the Oracle error ORA-32403: cannot use new values from mv log on “string”.”string”?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-32403: cannot use new values from mv log on “string”.”string” with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-32403: cannot use new values from mv log on “string”.”string” Reason for the Error ORA-32403: cannot use new values from mv log on “string”.”string” The materialized view…

How to fix the Oracle error ORA-29665: Java thread deadlock detected?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-29665: Java thread deadlock detected with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-29665: Java thread deadlock detected Reason for the Error ORA-29665: Java thread deadlock detected The Java VM has detected a thread deadlock. How to fix the Error ORA-29665: Java thread deadlock detected…

How to fix the Oracle error ORA-27547: Unable to query IPC OSD attribute string?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-27547: Unable to query IPC OSD attribute string with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-27547: Unable to query IPC OSD attribute string Reason for the Error ORA-27547: Unable to query IPC OSD attribute string This is an operating system-dependent IPC error. How to…

How to fix the Oracle error ORA-08102: index key not found, obj# string, file string, block string (string)?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-08102: index key not found, obj# string, file string, block string (string) with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-08102: index key not found, obj# string, file string, block string (string) Reason for the Error ORA-08102: index key not found, obj# string, file string,…