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

Re: RMAN backup of archived log fails

Tony van Lingen


Thanks for the info. I've been away for the last week, that's why I did
not come back to you earlier.

I checked the catalog with the command you listed: unless the bplist
output is limited to a number of lines (I can't get a definitive answer
to that from our NB guys), we're basically stuffed. It seems that the NB
catalog is spread over a number of servers, so if RMAN queries one it
will not get the entire list of available files. We're getting Symantec
out to clean it up... I may have to can the entire RMAN catalog.

Sigh.... where have the days of tar and 'alter tablespace backup'
gone... things were so easy then....


Jared Still wrote:
> On 5/29/07, *Sweetser, Joe* <JSweetser@(protected)
> <mailto:JSweetser@(protected):
>   Plus, the crosscheck command uses/looks at the Netbackup *catalog*
>   so the files do not necessarily need to be directly
>   available/accessible at the time the command is issued. But they
>   do need to exist in the NB catalog - which you can check with some
>   form of the NB bplist command (before issuing the crosscheck
>   command), if I am not mistaken. If you need the exact syntax
>   shoot me a message and I will try to locate an old script I have.
> /usr/openv/netbackup/bin/bplist -C <client server> -S <NetBackup
> Server> -l -t 4 -R /
> I keep it in a script as I cannot remember the syntax.
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist

Tony van Lingen
Systems Administrator


WARNING: This e-mail (including any attachments) has originated from a Queensland Government department and may contain information that is confidential, private, or covered by legal professional privilege, and may be protected by copyright.

You may use this e-mail only if you are the person(s) it was intended to be sent to and if you use it in an authorised way. No one is allowed to use, review, alter, transmit, disclose, distribute, print or copy this e-mail without appropriate authority. If you have received this e-mail in error, please inform the sender immediately by phone or e-mail and delete this e-mail, including any copies, from your computer system network and destroy any hardcopies.

Unless otherwise stated, this e-mail represents the views of the sender and not the views of the Environmental Protection Agency.

Although this e-mail has been checked for the presence of computer viruses, the Environmental Protection Agency provides no warranty that all viruses have been detected and cleaned. Any use of this e-mail could harm your computer system. It is your responsibility to ensure that this e-mail does not contain and is not affected by computer viruses, defects or interference by third parties or replication problems (including incompatibility with your computer system).

E-mails sent to and from the Environmental Protection Agency will be electronically stored, managed and may be audited, in accordance with the law and Queensland Government Information Standards (IS31, IS38, IS40, IS41 and IS42) to the extent they are consistent with the law.