All Oracle Error Codes
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


Goulet, Dick


    Your sane.  From Metalink:
  • fact: Oracle Application Object Library 11.5.4
  • fact: AIX 4.3.3 Based Systems (64-bit)
  • symptom: Patch fails with error ORA-01400: cannot insert NULL into ("APPLSYS"."AD_APPLIED_PATCHES"."PATCH_NAME")
  • symptom: Error while inserting into AD_APPLIED_PATCHES.
  • symptom: Error in calling adphistCreatePatchMastObj().
  • symptom: Error in calling adphistCreateAppliedPatch().
  • symptom: Error while uploading patches into the database
  • symptom: Encountered errors while uploading information from applptch.txt into the database!
  • symptom: Renaming file '/devtr11i/devtappl/admin/DEVT/applptch.txt' to '/devtr11i/devtappl/admin/DEVT/applptch_fail_101403081634.txt'...
  • change: Applying Patch 2408149.
  • cause: <Bug:2679427>. The version of adphist.lpc is lower than 115.77
  • cause: The corrupted applptch.txt. It contained the entry like "begin aru db", "alr_help" which is not in a standard format and it gave an error while inserting the patch history information in AD_APPLIED_PATCHES table.
At least now you know where he got the name from!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: April Wells [mailto:AWells@csedge.com]
Sent: Friday, June 04, 2004 9:21 AM
To: 'oracle-l@freelists.org'

It is a Oracle 11i table, and APPLSYS is an Oracle11i  schema.
Your auditor needs to read the documentation for Oracle8i and Oracle E-Business Suite 11i before he demands what you can't possibly deliver... or better yet, give him access to an id with select any table rights and have him find it.

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
“Few people really enjoy the simple pleasure of flying a kite”
Adam Wells age 11
"Imagination is the highest kite one can fly."
Lauren Bacall

-----Original Message-----
From: Mike Hennesy [mailto:orcl9ps8dba@yahoo.com]
Sent: Friday, June 04, 2004 7:53 AM
To: oracle-l@freelists.org

I am running an Oracle database and have an auditor who is requesting that I produce a listing of all the rows in the table APPLYSY.AD_APPLIED_PATCHES. The problem I have is that table doesn't exist. We do NOT have Oracle applications and I believe that this is a table that comes with Oracle Apps 11i.

The auditor is insistent that the table should be there and is wondering what I'm trying to hide. If you can confirm this is an Oracle Apps table for me or let me know what I should run if it is just a script that I should have run that I missed.

All replies will remain confidential; I'm just trying to verify my sanity.

Thanks - Mike

Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
The information contained in this communication,
including attachments, is strictly confidential
and for the intended use of the addressee only;
it may also contain proprietary, price sensitive,
or legally privileged information. Notice is hereby
given that any disclosure, distribution, dissemination,
use, or copying of the information by anyone other
than the intended recipient is strictly prohibited
and may be illegal. If you have received this communication
in error, please notify the sender immediately by
reply e-mail, delete this communication, and destroy
all copies.

Corporate Systems, Inc. has taken reasonable precautions
to ensure that any attachment to this e-mail has been
swept for viruses. We specifically disclaim all liability
and will accept no responsibility for damage sustained
as a result of software viruses and advise you to carry
out your own virus checks before opening any attachment.