Error map

ORA-12505 ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

SQL · layer 5, Data

Open the full error page →

Centre: this error. First ring: errors it is linked with (7). Outer ring: what those are linked with. Colours show the layer of a request each error belongs to. Click any dot to re-centre the map on it; hover to follow its connections. The centre dot opens the error page.

5 · Data
ORA-12505 — ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (SQL)ORA-12505Network-related error — SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. (provider: Named Pipes Provider, error: 40 / TCP Provider, error: 26) (SQL)Network-related err…ORA-00054 — ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired (SQL)ORA-00054ORA-00001 — ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-00001ORA-12154 — ORA-12154: TNS:could not resolve the connect identifier specified (SQL)ORA-12154ORA-00904 — ORA-00904: "X": invalid identifier (SQL)ORA-00904ORA-12514 — ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (SQL)ORA-12514ORA-12541 — ORA-12541: TNS:no listener (SQL)ORA-125412003 — MySQL ERROR 2003 (HY000): Can't connect to MySQL server on 'host:3306' (111) (MySQL)2003245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)2458115 — SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115) (SQL)8115Deadlock — Deadlock found when trying to get lock; try restarting transaction (SQL)DeadlockLock wait timeout — Lock wait timeout exceeded; try restarting transaction (MySQL 1205) (SQL)Lock wait timeout1213 — MySQL ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction (MySQL)12131062 — MySQL ERROR 1062 (23000): Duplicate entry for key (MySQL)1062SQLite UNIQUE failed — sqlite3.IntegrityError: UNIQUE constraint failed: users.email (SQL)SQLite UNIQUE failedSQLite NOT NULL failed — sqlite3.IntegrityError: NOT NULL constraint failed: table.column (SQL)SQLite NOT NULL fai…1054 — MySQL ERROR 1054 (42S22): Unknown column in 'field list' (MySQL)1054SQLite no such column — sqlite3.OperationalError: no such column: x (SQL)SQLite no such colu…208 — SQL Server: Invalid object name 'x'. (Msg 208) (SQL)208

Directly related (7)

Network-related errorSQL

SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. (provider: Named Pipes Provider, error: 40 / TCP Provider, error: 26)

The client couldn’t reach the SQL Server instance — wrong server name/instance, TCP disabled, firewall, or SQL Browser not runnin…

ORA-00054SQL

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

DDL or a NOWAIT lock couldn’t get the lock because another session holds it.

ORA-00001SQL

ORA-00001: unique constraint (SCHEMA.PK_X) violated

An insert/update duplicated a value in a unique or primary key constraint.

ORA-12154SQL

ORA-12154: TNS:could not resolve the connect identifier specified

The Oracle client couldn’t find the alias in tnsnames.ora (or the naming method can’t resolve it).

ORA-00904SQL

ORA-00904: "X": invalid identifier

A column name in the statement doesn’t exist (or is misquoted).

ORA-12514SQL

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

The listener is up but doesn’t know the service name you requested.

ORA-12541SQL

ORA-12541: TNS:no listener

Nothing listens on the Oracle host/port — the listener is down or you have the wrong port.

Two steps away (12)

2003MySQL

MySQL ERROR 2003 (HY000): Can't connect to MySQL server on 'host:3306' (111)

The client couldn’t reach MySQL over TCP — server down, wrong host/port, firewall, or MySQL bound to localhost only.

245SQL

SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245)

SQL Server tried to convert text to a number (often implicitly) and hit a non-numeric value.

8115SQL

SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115)

A value or calculation exceeds the target data type’s range.

DeadlockSQL

Deadlock found when trying to get lock; try restarting transaction

Two transactions waited on each other’s locks; the database killed one so the other could continue.

Lock wait timeoutSQL

Lock wait timeout exceeded; try restarting transaction (MySQL 1205)

A query waited too long for a row lock held by another transaction and gave up.

1213MySQL

MySQL ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction

MySQL detected a deadlock between two transactions and rolled one back.

1062MySQL

MySQL ERROR 1062 (23000): Duplicate entry for key

An INSERT/UPDATE would create a duplicate value in a PRIMARY or UNIQUE key.

SQLite UNIQUE failedSQL

sqlite3.IntegrityError: UNIQUE constraint failed: users.email

An insert/update duplicated a value in a UNIQUE or PRIMARY KEY column in SQLite.

SQLite NOT NULL failedSQL

sqlite3.IntegrityError: NOT NULL constraint failed: table.column

A NULL went into a NOT NULL column in SQLite.

1054MySQL

MySQL ERROR 1054 (42S22): Unknown column in 'field list'

The query references a column that doesn’t exist in the table (or an unquoted string being read as a column).

SQLite no such columnSQL

sqlite3.OperationalError: no such column: x

SQLite can’t find the column — missing migration, typo, or a string written in double quotes.

208SQL

SQL Server: Invalid object name 'x'. (Msg 208)

The table/view doesn’t exist in the current database or schema.

Map another error

Popular: 403500400TypeErrorCritical error0xC000007BNullPointerException404