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
ORA-13291conversion error between the specified unit and standard unit
IMP-00097STREAMS_CONFIGURATION=Y ignored, only valid with FULL=Y
ORA-36714(XSMXALLOC03) TARGETLOG variable workspace object must have the same data type as TARGET variable workspace object.
RMAN-04008WARNING from target database: string
ORA-06433ssaio: LSEEK error, unable to seek to requested block.
KUP-04068internal error fetching attribute string
ORA-13373invalid line segment in geodetic data
ORA-06956Failed to get local host name
ORA-06438ssaio: the asynchronous read was unable to read from the database file.
ORA-19194XQDY0026: It is a dynamic error if the result of the content expression of a computed processing instruction constructor contains the string "?>"
PROC-00032Cluster Ready Services on the local node is not running
QSM-02045START WITH clause in mv
ORA-02723osnpui: cannot send break signal
LPX-01034[XQST0034] Repeated function declaration
ORA-25262agent name cannot be NULL if address is a multi-consumer queue
ORA-56609Usage not supported with DRCP
RMAN-06721could not normalize path for file: "string"
ORA-07471snclrd: name translation error of sgadef.dbf file name.
ORA-09953scggc: unexpected return of a lock convert
ORA-06549PL/SQL: failed to dynamically open shared object (DLL): string:string




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
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
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