Blog

How to fix the Oracle error CRS-10043: DNS daemon is not listening on port number at address string?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorCRS-10043: DNS daemon is not listening on port number at address string with the details on why you receive this error and the possible solution to fix it. Oracle Error Description CRS-10043: DNS daemon is not listening on port number at address string Reason for the Error CRS-10043: DNS daemon is not listening on port number…

How to fix the Oracle error ORA-38727: FLASHBACK DATABASE requires a current control file.?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-38727: FLASHBACK DATABASE requires a current control file. with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-38727: FLASHBACK DATABASE requires a current control file. Reason for the Error ORA-38727: FLASHBACK DATABASE requires a current control file. The control file being used is a backup control…

How to fix the Oracle error ORA-13707: Either the start snapshot string or the end snapshot string is incomplete or...

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-13707: Either the start snapshot string or the end snapshot string is incomplete or missing key statistics. with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-13707: Either the start snapshot string or the end snapshot string is incomplete or missing key statistics. Reason for the…

How to fix the Oracle error ORA-13505: SYSAUX tablespace can not be made read only?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-13505: SYSAUX tablespace can not be made read only with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-13505: SYSAUX tablespace can not be made read only Reason for the Error ORA-13505: SYSAUX tablespace can not be made read only Attempting to set the SYSAUX tablespace…

How to fix the Oracle error ORA-12434: invalid audit type: string?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-12434: invalid audit type: string with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-12434: invalid audit type: string Reason for the Error ORA-12434: invalid audit type: string The audit type must be BY ACCESS or BY SESSION. How to fix the Error ORA-12434: invalid audit…

How to fix the Oracle error ORA-02430: cannot enable constraint (string) – no such constraint?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-02430: cannot enable constraint (string) – no such constraint with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-02430: cannot enable constraint (string) – no such constraint Reason for the Error ORA-02430: cannot enable constraint (string) – no such constraint the named constraint does not exist…

SQL Server Error Code – 41138 cannot accept always on availability gro

AbundantCode 1 year ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 41138 and the error message description that is shown SQL Server Error Code 41138 SQL Server Error Description for the Code :41138 Cannot accept Always On Availability Groups operation operation on database ‘%.*ls’ of availability group ‘%.*ls’.  The database is currently processing another operation that might change the database state. Retry the…

SQL Server Error Code – 22995 a value for the parameter @retention can

AbundantCode 1 year ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 22995 and the error message description that is shown SQL Server Error Code 22995 SQL Server Error Description for the Code :22995 A value for the parameter @retention cannot be specified when the job type is ‘capture’. Specify NULL for the parameter, or omit the parameter from the statement.

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…