Several of these errors you could read on Metalink - without logging in
;)
unable to resolve service_name
unable to connect to destination
so here is a start.
Mostly, I see 904 and 942 in untested code.
ORA-00000 normal, successful completion - not an error - but appears
that way when creating JAVA SYSTEM
ORA-00001 unique constraint (string.string) violated - RI is good.
ORA-00018 maximum number of sessions exceeded - send more $$$ to Redwood
Shores
ORA-00028 your session has been killed - this is usually accompanied by
the sound of a BOFH's evil laugh.
ORA-00054 resource busy and acquire with NOWAIT specified - I hear you
knocking but you can't come in.
ORA-00060 deadlock detected while waiting for resource - most likely
seen in the Alert log.
ORA-00257 archiver error. Connect internal only, until freed. - larger
hard drives tend to delay this problem
ORA-00600 internal error code, arguments: [string], [string], [string],
[string], [string], [string], [string], [string]
ORA-00904 Invalid column name
ORA-00942 Table or View does not exist
ORA-01001 invalid cursor - usually due to a lost dial-up connection
ORA-01014 ORACLE shutdown in progress - someone decided to press the red
button that says "DO NOT TOUCH"
ORA-01017 invalid username/password; logon denied
ORA-01019 unable to allocate memory in the user side - typical for Mac
SQL*Net Clients
ORA-01031 insufficient privileges - tried to connect as internal with
the wrong password
ORA-01033 ORACLE initialization or shutdown in progress
ORA-01034 ORACLE not available
ORA-01035 ORACLE only available to users with RESTRICTED SESSION
privilege - DB is likely being exported
ORA-01041 internal error. hostdef extension doesn't exist - can get this
over bad WAN connection
ORA-01045: user <username> lacks CREATE SESSION privilege; logon denied
ORA-01078 failure in processing system parameters - rookie DBA tried a
new parameter without success - revert to old init.ora
ORA-01400 cannot insert NULL into (string) - NOT NULL constraint up -
column value is NULL
ORA-01401 inserted value too large for column - front end accepts
unbounded data. The solution is not to use type LONG.
ORA-01552 cannot use system rollback segment for non-system tablespace
'string' - need public rollback segs.
ORA-01650 unable to extend rollback segment string by string in
tablespace string - datafile size is bounded, either by size or extents
ORA-01652 unable to extend temp segment by string in tablespace string -
datafile size is bounded, either by size or extents
ORA-12154: TNS:could not resolve service name
ORA-12560 TNS Protocol Adapter error
ORA-03113 end of file on communication channel - many manifestations
Paul
John Dailey wrote:
>
> Hi again List... hope everyone is having a pleasant
> afternoon/evening/morning:
>
> I'm looking for a list of common questions about Oracle errors that
> end-users might encounter. For example, basic stuff like "no listener",
> "Archiver error", "Oracle not available", "max # of extents reached", etc,
> etc. What I'm looking for is a decent list I can use to help me set up a
> help desk support site for my client. We are pretty much building the DBA
> group from the ground up here. If I had a nice list, I could put that in
> their current help desk support software so the users could route their
> specific requests and error messages to the DBA group (So we can ignore them
> properly) :-) . Does anyone know of or can point me to such a list? I know
> I could put on my thinking cap and make a list, but I'm really pressed for
> time (who isn't) and don't want to re-invent the wheel if I don't have to.
> Besides, I'm enjoying the hilarious commentary on Metalink's woes too much.
>
> I'd eventually like to have an auto-response email that says:
>
> "don't bother me, I'm busy...
> open up FDISK in a DOS Window and delete all your partitions"
>
> sent out to answer each request, but I'll save that functionality for
> later....
>
> :-)
>
> TIA
>
> John Dailey, MCSE/MCP+I
> Consultant
> Concept Solutions, LLC
> *Your Business Intelligence Partner*
> www.concept-solutions.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dailey
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
