Re: list of common ORA errors users get

From: Paul Drake <paled_at_home.com>
Date: Wed, 28 Feb 2001 00:19:40 -0800
Message-ID: <F001.002BF335.20010227231533@fatcity.com>

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: John.Dailey_at_concept-solutions.com
>
> 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: ListGuru_at_fatcity.com (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: paled_at_home.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Feb 28 2001 - 02:19:40 CST