All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

RE: OEM poll

Rich Jesse


This is kind of funny is a sick way, but I've been trying to get to
Grid in Winders (small shop -- can't justify Linux because of limits of
maintainability if I'm not around) for over a week now, but the
base install keeps failing because it isn't patched for DST 2K7.

Attempting to turn the clock forward, just as soon as the uninstall -- ahem,
"DEinstall", decides to work.

My off-the-top-of-my-head gripes with OEM 10gR1 *DB Control* so far:

-- I can't get the information I need where I need it. For example,
drilling down to job schedules doesn't allow one to go back to listing the
jobs without going to the top-level dashboard.

-- Can't see Top SQL from more than 1 hour ago via the web interface (must
manually use DBA_HIST views).

-- Can't see/manage DBMS_JOBs. (minor)

-- Can't modify or even *copy* existing backup jobs created through OEM.
That led to human error in recreating one job by the previous DBA. I'll be
rectifying that after an RMAN class...

-- Information in DBA_HIST_SEG_STAT appears to be flat out wrong (e.g.
SPACE_ALLOCATED_TOTAL for some tables is understated by as much as 300%).
Maybe that's not an EM thing, but the license to use the info is.

-- Graphing engine doesn't recognize that SVG is builtin to Firefox.

-- DST pre-patching scripts from Oracle Support explicitly exclude SYSMAN
objects, causing us DBAs new to OEM 10g to overlook it for patching! (OK,
that's not really OEM's fault)

-- Causes unexplainable ORA-1422 errors when notifying about a metric with
multiple thresholds.

-- Aggregated performance drilldowns (e.g. the "Wait Bottlenecks" metrics)
don't always appear to be inline with Oracle's more recent emphasis on the
wait interface, or at least at my level of understanding it from the
Millsap/Holt book. This one's much more highly subjective than the rest.
Perhaps I'm just more familiar with the way Quest's Spotlight presents the

-- No support for complex scheduling (e.g. can't find a way to set up a
schedule interval that includes "BYHOUR=12,17;").

My OTTOMH likes:

-- Ubiquitous web interface means I can more easily run the console remotely
and also from Linux.

-- Probably some that I can't think of.

These are just a sample, updated from my initial gripes when I tried using
OEM 10GR1 three years ago (in a previous life):


Sorry for jumping in late on the thread!  Enjoy!



  * From: "Alex Gorbachev" <gorbyx@(protected)>
  * To: oracle-l@(protected)
  * Date: Thu, 22 Mar 2007 19:51:22 -0500

Worth to mention that OEM upgrade was the first upgrade I had
installed without any tweaking - just like it should be. So it's getting
more and more stable.