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
Session Killed...!!

Session Killed...!!

2005-09-15       - By Yongping Yao

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

Q2hlbiwgSSBhZ3JlZSB3aXRoIHlvdS4gSSByZWFkIGl0IG15c2VsZiBiZWZvcmUuCkJyeWFuIFdl
bGxzLCBXZSB1c2UgVE9BRCBhIGxvdCB0b28uIFdoZW4gd2Uga2lsbCBhIGxvbmctcnVuIHN0YXRl
bWVudCwKVE9BRCBhbHdheXMgaGFuZ3MgZm9yIGEgd2hpbGUgYW5kIHRoZW4gdGVsbCBtZSB0aGF0
IGl0J3MgbWFya2VkCmtpbGxlZC4KCtTaIDA1LTktMTWjrENoZW4sIFNhcmFoPFNhcmFoX0NoZW5A
YnVkY28uY29tPiDQtLXAo7oKPiBJIGRpZCBzb21lIHJlc2VhcmNoIGFjY29yZGluZyB0byB0aGlz
IGlzc3VlIGJlZm9yZS4gSGVyZSBpcyBmcm9tIG15IG5vdGVzKEkKPiBkb24ndCBrbm93IHdoZXJl
IEkgZ290IGl0LCBidXQgbXVzdCBmcm9tIG9uZSBvZiB0aGUgT3JhY2xlIGV4cGVydHMpOgo+IAo+
IHdoZW4gYSBzZXNzaW9uIGlzIGtpbGxlZCwgb3JhY2xlIG5lZWRzIHRvIHJvbGxiYWNrIHdoYXRl
dmVyIHdvcmsgaXQgaGFkIGJlZW4KPiBkb2luZyAtIHRoYXQncyB3aHkgaXQgd2FpdHMuCj4gCj4g
Z29pbmcgdG8gdGhlIG8vcyBhbmQga2lsbGluZyB0aGUgcHJvY2Vzc2VzIHdvbid0IHNwZWVkIHRo
aXMgdXAuIEhvd2V2ZXIsCj4gd2hlbiB5b3UgdXNlICJhbHRlciBzeXN0ZW0ga2lsbCBzZXNzaW9u
IiwgdGhlIHNlc3Npb24gZG9lc24ndCBrbm93IGl0J3MKPiBraWxsZWQgdW50aWwgaXQgbWFrZXMg
YW5vdGhlciByZXF1ZXN0IHRvIHRoZSBkYXRhYmFzZSAtIGlmIGl0IHdhcyB3YWl0aW5nCj4gZm9y
IGEgcmVzcG9uc2UgKHBhcnRpY3VsYXJseSB0byBhIHJlbW90ZSBvcGVyYXRpb24pLCBpdCBtYXkg
bm90IG1ha2UgYQo+IHJlcXVlc3QgZm9yIGEgbG9uZyB0aW1lLCBpbiB3aGljaCBjYXNlIGtpbGxp
bmcgdGhlIHByb2Nlc3MgZnJvbSB0aGUgby9zIG1heQo+IGhlbHAgdG8gc3RvcCB0aGUgc2Vzc2lv
bi4gYXQgdGhhdCB0aW1lLCB0aGUgZGF0YWJhc2Ugc3RpbGwgbmVlZHMgdG8gcm9sbGJhY2sKPiB3
aGF0ZXZlciBoYWQgaGFwcGVuZWQgYWxyZWFkeS4KPiAKPiAKPiBTYXJhaAo+IAo+IAo+IC0tLS0t
T3JpZ2luYWwgTWVzc2FnZS0tLS0tCj4gRnJvbTogWW9uZ3BpbmcgWWFvIFttYWlsdG86eWFveW9u
Z3BpbmdAZ21haWwuY29tXQo+IFNlbnQ6IFRodXJzZGF5LCBTZXB0ZW1iZXIgMTUsIDIwMDUgMTE6
MDYgQU0KPiBUbzogQ2hlbiwgU2FyYWgKPiBDYzogVGhvbWFzLk1lcmNhZGFudGVAbGFib3Iuc3Rh
dGUubnkudXM7IGNoaXJhZ2RiYUBnbWFpbC5jb207IE9yYWNsZS1MCj4gRnJlZWxpc3RzCj4gU3Vi
amVjdDogUmU6IFNlc3Npb24gS2lsbGVkLi4uISEKPiAKPiAKPiBJIGFncmVlIHRoYXQgaXQncyB2
ZXJ5IHN0cmFuZ2UgdG8ga2lsbCBhIHNlc3Npb24gaW4gT3JhY2xlLiBBcyBJCj4gZXhwZXJpZW5j
ZWQsIFNFTEVDVHMgYXJlIG1vcmUgZWFzaWVyIHRvIGtpbGwgdGhhbiBETUxzIGFuZCBTRUxFQ1Rz
Cj4gcnVubmluZyBhZnRlciBhIGxvbmcgdGltZSBhcmUgbW9yZSBkaWZmaWN1bHQgdG8ga2lsbC4g
VVBEQVRFIGlzIHRoZQo+IG1vc3QgZGlmZmljdWx0IHRvIGtpbGwuIE9yYWNsZSBhbHdheXMgcmVw
b25kcyBhcyAid2UgaGF2ZSBtYXJrZWQgdGhlCj4gc2Vzc2lvbiBraWxsZWQiIGJ1dCB0aGUgc2Vz
c2lvbiBpcyBzdGlsbCB0aGVyZSBhbmQgdGhlIGxvY2sgcmVtYWluZWQKPiBob2xkLiBBbnlvbmUg
d2l0aCBnb29kIHJlY29tbWVuZGF0aW9ucz8KPiAKPiAyMDA1LzkvMTUsIENoZW4sIFNhcmFoIDxT
YXJhaF9DaGVuQGJ1ZGNvLmNvbT46Cj4gPgo+ID4gSSBhbHdheXMgY2hlY2sgcHJvY2VzcyBpZCBh
cyB3ZWxsIGFzIHNpZCBhbmQgc2VyaWFsIyB3aGlsZSBraWxsaW5nIGEKPiBzZXNzaW9uCj4gPiBm
cm9tIE9yYWNsZS4KPiA+Cj4gPiBJIHdpbGwgYWx3YXlzIHF1ZXJ5IHYkc2Vzc2lvbiBiZWZvcmUg
YW5kIGFmdGVyLCBhbmQgaWYgdGhlIHN0YXR1cyBvZgo+ID4gdiRzZXNzaW9uIG1hcmtlZCAia2ls
bGVkIiwgYW5kIHRoZW4gSSB3aWxsIGdvIGFoZWFkIGtpbGwgT1MgcHJvY2VzcyB0bwo+IGNsZWFu
Cj4gPiB0aGlzIHNlc3Npb24uIEl0IGFsd2F5cyB3b3JrcyBvbiBTb2xhcmlzLgo+ID4KPiA+IFNh
cmFoCj4gPgo+ID4KPiA+IC0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tCj4gPiBGcm9tOiBvcmFj
bGUtbC1ib3VuY2VAZnJlZWxpc3RzLm9yZwo+IFttYWlsdG86b3JhY2xlLWwtYm91bmNlQGZyZWVs
aXN0cy5vcmddT24KPiA+IEJlaGFsZiBPZiBNZXJjYWRhbnRlLCBUaG9tYXMgRiAoTEFCT1IpCj4g
PiBTZW50OiBUaHVyc2RheSwgU2VwdGVtYmVyIDE1LCAyMDA1IDEwOjQ3IEFNCj4gPiBUbzogY2hp
cmFnZGJhQGdtYWlsLmNvbTsgT3JhY2xlLUwgRnJlZWxpc3RzCj4gPiBTdWJqZWN0OiBSRTogU2Vz
c2lvbiBLaWxsZWQuLi4hIQo+ID4KPiA+Cj4gPgo+ID4KPiA+IElmIHlvdSBraWxsIHRoZSB1bml4
IHByb2Nlc3MgYXNzb2NpYXRlZCB3aXRoIHRoaXMgc2Vzc2lvbiBmaXJzdCwgYW5kIHRoZW4KPiA+
IHRoZSBzZXNzaW9uIGl0IHdpbGwgZ28gYXdheS4KPiA+Cj4gPgo+ID4KPiA+IEtpbGxpbmcgc2Vz
c2lvbnMgaW4gT3JhY2xlIGhhcyBhbHdheXMgYmVlbiB3ZWlyZC4gIFNvbWV0aW1lcyB0aGV5IGdv
IGF3YXkKPiA+IGFuZCBzb21ldGltZXMgbm90LCBkZXBlbmRpbmcgb24gT1MuICBJbiBXaW5kb3dz
LCB1c2Ugb3Jha2lsbCB0byBraWxsIHRoZQo+ID4gc2Vzc2lvbiChp0MgdGhpcyBhbHdheXMgc2Vl
bXMgdG8gd29yayBpbiB3aW5kb3dzLiAgQW5kIGtpbGxpbmcgdGhlIHVuaXgKPiA+IHNlc3Npb24g
dGhlbiB0aGUgT3JhY2xlIHNlc3Npb24gc2VlbXMgdG8gd29yayBqdXN0IGZpbmUgaW4gQUlYLgo+
ID4KPiA+Cj4gPgo+ID4gIF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCj4gPgo+ID4K
PiA+IEZyb206IG9yYWNsZS1sLWJvdW5jZUBmcmVlbGlzdHMub3JnIFttYWlsdG86b3JhY2xlLWwt
Ym91bmNlQGZyZWVsaXN0cy5vcmddCj4gPiBPbiBCZWhhbGYgT2YgQ2hpcmFnIERCQQo+ID4gU2Vu
dDogVGh1cnNkYXksIFNlcHRlbWJlciAxNSwgMjAwNSAxMDozNiBBTQo+ID4gVG86IGFza2RiYUBm
cmVlbGlzdHMub3JnOyBPcmFjbGUtTCBGcmVlbGlzdHMKPiA+IFN1YmplY3Q6IFNlc3Npb24gS2ls
bGVkLi4uISEKPiA+Cj4gPgo+ID4KPiA+Cj4gPiBIaSAsCj4gPgo+ID4KPiA+Cj4gPgo+ID4KPiA+
IEkgc2F3IG1hbnkgdXNlcnMgb24gbXkgZGF0YWJhc2UgY29ubmVjdGVkIGZvciBtb3JlIHRoYW4g
NiBkYXlzIHdpdGhvdXQgYW55Cj4gPiBhY3Rpdml0eS4KPiA+Cj4gPgo+ID4KPiA+Cj4gPgo+ID4g
SSBraWxsZWQgMSB1c2VyIGFuZCBzdGlsbCB0aGUgc3RhdHVzIGluIHYkc2Vzc2lvbiBpcyBzaG93
aW5nIGFzIGtpbGxlZC4KPiA+Cj4gPgo+ID4KPiA+Cj4gPgo+ID4gYnV0IGl0IGl0IG5vdCBnZXR0
aW5nIHJlbW92ZWQgZnJvbSB0aGUgdiRzZXNzaW9uLgo+ID4KPiA+Cj4gPgo+ID4KPiA+Cj4gPiBJ
IGFtIHJ1bm5pbmcgOS4wLjEuMyBvbiBzb2xhcmlzLgo+ID4KPiA+Cj4gPgo+ID4KPiA+Cj4gPiBh
bnkgaWRlYT8gV2UgYWxyZWFkeSBoaXQgdGhlIGJ1ZyBvcmEtMDc0NDIuCj4gPgo+ID4KPiA+Cj4g
Pgo+ID4KPiA+IHJlZ2FyZHMgLSBjaGlyYWcKPiAKPiAKPiAtLQo+IFlhbyBZb25ncGluZwo+IExl
YXJuaW5nIE9yYWNsZSwgVU5JWC9MaW51eC4uLgo+IExvdmUgUmVhZGluZywgQ2xhc3NpY2FsIE11
c2ljLCBQaGlsb3NvcGh5LCBFY29ub21pY3MgZXRjLgo+IEJsb2c6IGh0dHA6Ly9ibG9nLmNzZG4u
bmV0L2Vybgo+ICAgICAgICAgIGh0dHA6Ly9zcGFjZXMubXNuLmNvbS9tZW1iZXJzL3lhb3lwLwo+
IAoKCi0tIApZYW8gWW9uZ3BpbmcKTGVhcm5pbmcgT3JhY2xlLCBVTklYL0xpbnV4Li4uCkxvdmUg
UmVhZGluZywgQ2xhc3NpY2FsIE11c2ljLCBQaGlsb3NvcGh5LCBFY29ub21pY3MgZXRjLgpCbG9n
OiBodHRwOi8vYmxvZy5jc2RuLm5ldC9lcm4KICAgICAgICAgaHR0cDovL3NwYWNlcy5tc24uY29t
L21lbWJlcnMveWFveXAvCg==
--
http://www.freelists.org/webpage/oracle-l