ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Cause: The listener was not configured with a default service and SERVICE_NAME was missing from the CONNECT_DATA received by the listener.
Action: Possible solutions are:

- Configure DEFAULT_SERVICE parameter in LISTENER.ORA with a valid service name. Reload the listener parameter file using reload [<listener_name>]. This should be done by the LISTENER administrator.

- If using a service name, Check that the connect descriptor corresponding to the service name in TNSNAMES.ORA has a SERVICE_NAME or SID component in the CONNECT_DATA.
ORA-12505
Custom Search


More Oracle errors
DIA-49433Incident not part of package [string]
ORA-29839failed to validate implementation type
ORA-40230invalid transformation expression
ORA-13190recursive SQL fetch failed
NNO-00334region load failure: ROS admin_region type number unsupported
ORA-01481invalid number format model
ORA-16801redo transport-related property is inconsistent with database setting
ORA-15241attribute string is read only
ORA-09820Conversion of class string to numeric representation failed.
ORA-32775cannot change size attributes of read only tablespace string
NCR-00003NCR: Initialization failure
NID-00303Datafile string - wrote new name
UDI-00052incorrect Data Pump client for operation: string
ORA-34059(MSEXECUT12) You cannot delete non session-only dimension values from unique concat dimension workspace object.
ORA-41017Session prepare failed for session number string, serial number string
KUP-11016database version in file string is not valid
LSX-00175a complex base within "simpleContent" must have simple content
PCC-00113Value of DBMS option invalid with given value of MODE option
RMAN-20280too many device types
ORA-09274szrfc: insufficient role name buffer space




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA