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
ORA-00942:table or view does not exist
Cause:The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.
Action:Check each of the following:

  • the spelling of the table or view name.
  • that a view is not specified where a table is required.
  • that an existing table or view name exists.

Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.

Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted.

Posts about ORA-00942

10g Database Link DBA_DB_LINKS mystery

Hi guys Can you help me with this? SQL > select open_mode from v$database OPEN_MODE ---------- READ WRITE SQL > show user USER is "SYS " SQL > select table_name from dictionary where table_name lik

disable pk works differently in oracle 9 and oracle 10?

Hi all I have noticed that something that I was able to do in oracle9 can 't be done in oracle10. This is very annoying and I would appreciate any thoughts on this Oracle 9 SQL > select * from v$v

general sql select procedure

Hi all I 'm working with sql stored procedure and I created these one CREATE OR REPLACE PROCEDURE today (tbl_name IN VARCHAR2 old_key IN NUMBER) AS loop_count NUMBER BEGIN SELECT COUNT(*) INTO l

SV: How to get query to use an index

I would suggest a modified UNION-ALL version (a solution I have myself used on occasion (3VL may - as always - bite you though)) --- SQL > select * from v$version BANNER

oracle 10g and pear

On 04/12/2006 11 25 50 AM Simone Saravalli wrote > hi to everybody > I use Oracle 10g Express and I 'm dealing with the connection to the > database in php through the use of pear. In order to c

issue with wait on log buffer space. Oracle recommends enable write cache??

Hello I have a general issue with loading data into a Oracle database on solaris 8. I reduced it down to a simple statement which takes 1 second on my PC (oracle but takes 20 seco

materialized view ON COMMIT REFRESH - 942 error

Hi all I 've been reading this guide / that guide trying to get this problem fixed but have failed -( So I 've created a simple example to illustrate my error (lack of knowledge). My master tabl

ENDIAN_FORMAT - little or big of Solaris 8/9 (32/64 bit) & IBM AIX OS?

On my Oracle 8.1.7 & 9.2 databases - SQL > SELECT * FROM V$TRANSPORTABLE_PLATFORM Failing with the Error - SELECT * FROM V$TRANSPORTABLE_PLATFORM * ERROR at line 1 ORA-00942 table

non existing tables in packages

Frank If you code the table name in the package it will simply not compile. The only thing you can do IMHO is to use dynamic SQL and trap ORA-00942. HTH Stephane Faroult RoughSea Ltd http

Logical standby problem

A colleague is trying to create a logical standby database. During apply it is getting stuck on LOGSTDBY stmt grant select insert on sys.ora_temp_1_ds_24148 to "SYSTEM " LOGSTDBY status ORA-00942

ksh select value into variable from v$ view

Solaris 9 Oracle Hi! I 'm trying to grab a process id from the database and store it in a variable. This syntax works if I 'm not using a v$ view. If I use a v$ view it ignores what 's after

Privileges on directory object are failing

Hi list oracle SunOS 5.8 sun4u sparc SUNW Sun-Fire this is making me crazy I have 2 directories created CREATE OR REPLACE DIRECTORY "DIR_NB " AS '

OT moment of doubt

With 10g worry nomore Just find out this feature today...

DBMS_LOGMNR_LOGREP_DICT error during full export

Hi all I help administer a database which is exported each night. The ful l export process always receives the error below related to SYS.DBMS_LOGMNR_LOGREP_DICT.system_info_exp.

split partition (range partition) error

Could someone please tell me what is wrong here? 20 alter table dwo.part_tab split partition P20050601 at (TO_DATE( ' 2005-05-11 00 00 00 ' 'SYYYY-MM-DD HH24 MI SS ' 'NLS_CALENDAR 3DGREGORIAN '))

how can you protect read-only indexes?

On Thu 3 Mar 2005 12 49 24 -0400 Juan Carlos Reyes Pacheco <juancarlosreyesp@(protected) > wrote > Hi carmen move to a tablespace and make it read only. what like this? read only doesn 't necess

Poor performance while selecting or deleting from DR$WAITING

Hi All Firstly I have changed my Display name from New DBA to my original name. The reason I kept it as New DBA was to highlight the fact that I was just a novice and be treated likewise -)

DB Links management

" If the DBLink is created without a identified by the user must provide a 20 Password each time it is used. " Not true IF the user id exists on both servers (with of course the same password).

Export Error

I have Oracle 9.2.04 running on Win2K Box with one database ID05 on it .I have created one more database redi on same machine . I am trying to take full export of redi database i am getting fol

Export error ..

One of my frnd is trying to generate development DB from production. Production machine is 8.1.7 and development DB where he want to upload a DB is 9.2. He is taking export from his machine n gett

database problem migrating from 9i to 10g on Solaris

are there by chance materialized view logs on these tables? did you by chance migrate via import/export? -----Original Message----- From oracle-l-bounce@(protected) [mailto oracle-l-boun

Q: database problem migrating from 9i to 10g on Solaris

<preface - this is pre-coffee > I 've been fighting an issue which has me baffled. Basically i performed a database upgrade of Oracle on Solaris 8 migrating 3 instances from 9i to 10g. Every

max number of handles 9.2, win32, partitioning

Hi! > What is the largest number of user sessions * > datafiles filesystem handles that you 've encountered > in win32 land? Hm strange I always thought that due the single-process architec

AW: [suse-oracle] Performance testing

Hi Am Di den 13.07.2004 schrieb Anton Dischner um 10 36 > please take this for a very basic benchmark in SQL*Plus > please share your results > ... at first i would like to thank you a


SQL*Plus is probably passing 942 out as the return code. However unix can handle values from 0 to 255. Any return code in excess of 255 is returned as the modulus of (return_code 256). SQL > sele


As Daniel pointed out yesterday the Exit line can only accept up to 256. After that it uses the Mod of the number and 256. 942 Mod 256 is 174. Hence the reason you are getting 174 back. If you


Hi Qn 1 -------- Is there any way to pass both the SQL.SQLCODE & SQLERRM to the os back ?? Qn 2 ------- When I tried WHENEVER SQLERROR EXIT SQL.SQLCODE The actual oracle error code (ORA

RE: Oracle + Unix question , Error validation for SQL statements
   in co proces

I did not know that. Thats for this info as well as the rollback info. -----Original Message----- From Daniel Fink [mailto Daniel.Fink@(protected)] Sent Tuesday July 20 2004 1 12 PM To oracle

Re: Oracle + Unix question , Error validation for SQL statements in co

Inline Kevin Lange wrote > The thing is the ?$ will not give you anthing but a 0 when you use it after > the SQL statement because SQLPLUS finish correctly ... even if the SQL that > is ran do

errors from alert.log

Unfortunately error messages related to replication in version 8.0 hardly ever told it all ) Several years ago we were getting an ORA-00942 on a simple replication/snapshot setup the reason

quick pl/sql question

Got this simple proc SQL > create or replace procedure dave_test (p_user_id IN varchar2) as begin dbms_resource_manager_privs.grant_switch_consumer_group(p_user_id 'users 1 ' TRUE) dbms_re


Hi Listers I am trying to configure TG4DRDA to connect to AS400/DB2 system. When I am trying to bind the package GTW$_BIND_PKG I am getting the error ********************* ERROR START *********

Problem with export and mat view logs...

We have a production oltp that has logs build on tables necessary to reporting so that we and replicate them to the reporting database. I am trying to set up a valid test environment with exp/imp.
User Posts

No registration required.
Post Topic:
Oracle Database Server Error Codes
ORA-00020   ORA-00054   ORA-00119   ORA-00279   ORA-00381   ORA-00439   ORA-00600   ORA-00604   ORA-00904   ORA-00907   ORA-00911   ORA-00922   ORA-00923   ORA-00936   ORA-00942   ORA-01000   ORA-01017   ORA-01031   ORA-01033   ORA-01034   ORA-01078   ORA-01092   ORA-01113   ORA-01122   ORA-01161   ORA-01422   ORA-01501   ORA-01555   ORA-01562   ORA-01578   ORA-01650   ORA-01652   ORA-01658   ORA-01722   ORA-01756   ORA-01843   ORA-01925   ORA-01940   ORA-02019   ORA-02097   ORA-02143   ORA-03113   ORA-04030   ORA-04031   ORA-04068   ORA-06502   ORA-06512   ORA-06531   ORA-06550   ORA-07445   ORA-12154   ORA-12203   ORA-12500   ORA-12535   ORA-12540   ORA-12545   ORA-12560   ORA-12599   ORA-12638   ORA-12709   ORA-12838   ORA-12913   ORA-16038   ORA-20000   ORA-24324   ORA-27125   ORA-28575   ORA-28576   ORA-29283   ORA-29540   ORA-32004