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-00904:string: invalid identifier
Cause:The column name entered is either missing or invalid.
Action:Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.
Posts about ORA-00904

about "Oracle recommends that unique indexes be created explicitly "

Intended to cc the list ---------- Forwarded message ---------- From Niall Litchfield <niall.litchfield@(protected) > Date Jun 30 2006 1 00 PM Subject Re about "Oracle recommends that unique indexe

error gathering statistics on less than 100 %

Hi I found a curious problem on 9.2 when trying to get less than 100% on a table SQL > EXEC DBMS_STATS.GATHER_TABLE_STATS( ownname > 'ADM ' TABNAME > 'DEFTRANSAC_M E ' ESTIMATE_PERCENT >50 CASCADE >T

WRH Data Collection complains of invalid identifier

RDBMS Version Operating System and Version RHEL 4.0 2.6.9-11.ELhugemem Database is throwing the tracefile below whenever it tries to update wrh. Searched through the bugs and forums. F or for AIX 5.3 (64 bit)

Be careful with It cannot export from lower versions of Oracle. I didn 't have any other problems but this one is a big one. The compatibility with the previous releases is broken. After clo


ORA-00904 as we know indicates an invalid or nonexistent column name. My guess is somebody has modified the table at one of your sites without using the appropriate replication package to distr

"Merge into " wierdness - solved

Well I 've made some progress on this... The source table had duplicate records in it based on the key structure mentioned in the ON clause. Once those duplicate records were removed the statemen

"Merge into " wierdness

I 'm doing a merge into command where I query a table that holds multiple scenario items in it. The objective is to transfer the selected scenario items from the "source scenario " to the "destinat

oracle apps migration import failing on wf_item_attribute_values

All We 're moving our Oracle Apps 11.5.6/ single-node environment from Tru64 5.1b to AIX 5.2. At one time it was 10.7 upgraded to 11.5.4 and then 11.5.6. We 're following the Oracle Apps/


-- Mladen Gogala A & E TV Network Ext. 1216 -----Original Message----- From Paula_Stankus@(protected) [mailto Paula_Stankus@(protected)] Sent Monday August 23 2004 1 31 PM To

fetch out of sequence

Rewriting into an update - I am testing a multiple column - join update 1 update 2 (select a.last_name b.last_name 3 from emp a person b 4 where a.emp_id 3D b.person_id)

Oracle + Unix question , Error validation for SQL statements in co process ?

Try using SQL.SQLCODE instead. sqlplus /nolog < < EOF connect / as sysdba whenever sqlerror exit sql.sqlcode select ddd from dual exit EOF RC $? echo Return Code $RC Executing the above

problem with dbms_stats 9204 on hp-ux 11i

I 'm analyzing a schema... exec dbms_stats.gather_schema_stats(ownname > 'XXX ' estimate_percent >20 casca de >true) and receiving the following error... * ERROR at line 1

to_number question

Something is not right here. Stephen. Here is your query SLDC > select /*+ NO_MERGE(Z) NO_PUSH_PRED(Z) PUSH_SUBQ(Z) */ distinct SLDC > nbr_cc_fop_name into v_fop from SLDC > (select nbr_cc

Parsing order (Was: "select ... connect by... " in the view)

Ok I see no takers on my original question (how to create a view based on "select . connect by. and prior. start with. " to get the hierarchy). May be this will spark some interest I guess it 's a
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