Links
• Home
• 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
data dictionary view with all oracle errors in it?

data dictionary view with all oracle errors in it?

2004-07-27       - By J.Velikanovs@(protected)

Reply:     1     2     3     4     5     6     7     8     9     10     >>  

Enjoy.
I have used Tanel posted code. Thanks Tanel again.


SYS:POL01 > select * from edu_oerr where rownum < 11;

ERR_MSG
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
ORA-0000 (See ORA-0000.ora-code.com): normal, successful completion
ORA-00001 (See ORA-00001.ora-code.com): unique constraint (.) violated
ORA-00017 (See ORA-00017.ora-code.com): session requested to set trace event
ORA-00018 (See ORA-00018.ora-code.com): maximum number of sessions exceeded
ORA-00019 (See ORA-00019.ora-code.com): maximum number of session licenses exceeded
ORA-00020 (See ORA-00020.ora-code.com): maximum number of processes () exceeded
ORA-00021 (See ORA-00021.ora-code.com): session attached to some other process; cannot switch session
ORA-00022 (See ORA-00022.ora-code.com): invalid session ID; access denied
ORA-00023 (See ORA-00023.ora-code.com): session references process private memory; cannot detach
session
ORA-00024 (See ORA-00024.ora-code.com): logins from more than one process not allowed in single-process
mode

10 rows selected.

SYS:POL01 >




drop type edu_text;
drop function edu_oerr_f;
drop view edu_oerr;

CREATE OR REPLACE type edu_text as table of varchar2(4000);
/


create or replace function edu_oerr_f
return edu_text pipelined
as
err_msg VARCHAR2(1000);
BEGIN
FOR err_num IN 0..11005
LOOP
err_msg := SQLERRM (-err_num);
IF err_msg NOT LIKE '%Message '||err_num|| ' not found% ' THEN
pipe row (err_msg);
END IF;
END LOOP;
return;
END;
/

create or replace view edu_oerr as select COLUMN_VALUE err_msg from
table(edu_oerr_f);
select * from edu_oerr;




Jurijs
9268222
===========================================http://otn.oracle.com/ocm/jvelikanovs.html






Tanel P�der <tanel.poder.003@(protected) >
Sent by: oracle-l-bounce@(protected)
27.07.2004 18:43
Please respond to oracle-l

To: <oracle-l@(protected) >
cc:
Subject: Re: data dictionary view with all oracle errors in
it?


Someone once posted here a cool script to retrieve the Oracle errors (also
event descriptions) in PL/SQL:

SET SERVEROUTPUT ON
DECLARE
err_msg VARCHAR2(1000);
BEGIN
dbms_output.enable (1000000);
FOR err_num IN 10000..11005
-- FOR err_num IN 38001..39000
LOOP
err_msg := SQLERRM (-err_num);
IF err_msg NOT LIKE '%Message '||err_num|| ' not found% ' THEN
dbms_output.put_line (err_msg);
END IF;
END LOOP;
END;
/

Tanel.

-- -- Original Message -- --
From: <J.Velikanovs@(protected) >
To: <oracle-l@(protected) >
Sent: Tuesday, July 27, 2004 6:24 PM
Subject: Re: data dictionary view with all oracle errors in it?


> Unix
> oerr ora 903
> vi $ORACLE_HOME/rdbms/mesg/oraus.msg
>
> Jurijs
> 9268222
> =========================================== > http://otn.oracle.com/ocm/jvelikanovs.html
>
>
>
>
>
>
> ryan.gaffuri@(protected)
> Sent by: oracle-l-bounce@(protected)
> 27.07.2004 18:26
> Please respond to oracle-l
>
> To: oracle-l@(protected)
> cc:
> Subject: data dictionary view with all oracle errors in
it?
>
>
> I believe there is a view that will have all of the oracle errors listed
> in it. I am not talking about dba_errors which has all the current
errors.
> Just a lookup of Oracle errors.
> One of the guys here says there is one, but can 't remember which one it
> is. Anyone know?


-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --


-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --