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     >>  

SSBhZ3JlZSB0aGF0IGl0J3MgdmVyeSBzdHJhbmdlIHRvIGtpbGwgYSBzZXNzaW9uIGluIE9yYWNs
ZS4gQXMgSQpleHBlcmllbmNlZCwgU0VMRUNUcyBhcmUgbW9yZSBlYXNpZXIgdG8ga2lsbCB0aGFu
IERNTHMgYW5kIFNFTEVDVHMKcnVubmluZyBhZnRlciBhIGxvbmcgdGltZSBhcmUgbW9yZSBkaWZm
aWN1bHQgdG8ga2lsbC4gVVBEQVRFIGlzIHRoZQptb3N0IGRpZmZpY3VsdCB0byBraWxsLiBPcmFj
bGUgYWx3YXlzIHJlcG9uZHMgYXMgIndlIGhhdmUgbWFya2VkIHRoZQpzZXNzaW9uIGtpbGxlZCIg
YnV0IHRoZSBzZXNzaW9uIGlzIHN0aWxsIHRoZXJlIGFuZCB0aGUgbG9jayByZW1haW5lZApob2xk
LiBBbnlvbmUgd2l0aCBnb29kIHJlY29tbWVuZGF0aW9ucz8KCjIwMDUvOS8xNSwgQ2hlbiwgU2Fy
YWggPFNhcmFoX0NoZW5AYnVkY28uY29tPjoKPiAgCj4gSSBhbHdheXMgY2hlY2sgcHJvY2VzcyBp
ZCBhcyB3ZWxsIGFzIHNpZCBhbmQgc2VyaWFsIyB3aGlsZSBraWxsaW5nIGEgc2Vzc2lvbgo+IGZy
b20gT3JhY2xlLiAKPiAgIAo+IEkgd2lsbCBhbHdheXMgcXVlcnkgdiRzZXNzaW9uIGJlZm9yZSBh
bmQgYWZ0ZXIsIGFuZCBpZiB0aGUgc3RhdHVzIG9mCj4gdiRzZXNzaW9uIG1hcmtlZCAia2lsbGVk
IiwgYW5kIHRoZW4gSSB3aWxsIGdvIGFoZWFkIGtpbGwgT1MgcHJvY2VzcyB0byBjbGVhbgo+IHRo
aXMgc2Vzc2lvbi4gSXQgYWx3YXlzIHdvcmtzIG9uIFNvbGFyaXMuIAo+ICAgCj4gU2FyYWgKPiAg
Cj4gIAo+IC0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tCj4gRnJvbTogb3JhY2xlLWwtYm91bmNl
QGZyZWVsaXN0cy5vcmcgW21haWx0bzpvcmFjbGUtbC1ib3VuY2VAZnJlZWxpc3RzLm9yZ11Pbgo+
IEJlaGFsZiBPZiBNZXJjYWRhbnRlLCBUaG9tYXMgRiAoTEFCT1IpCj4gU2VudDogVGh1cnNkYXks
IFNlcHRlbWJlciAxNSwgMjAwNSAxMDo0NyBBTQo+IFRvOiBjaGlyYWdkYmFAZ21haWwuY29tOyBP
cmFjbGUtTCBGcmVlbGlzdHMKPiBTdWJqZWN0OiBSRTogU2Vzc2lvbiBLaWxsZWQuLi4hIQo+IAo+
ICAKPiAgCj4gCj4gSWYgeW91IGtpbGwgdGhlIHVuaXggcHJvY2VzcyBhc3NvY2lhdGVkIHdpdGgg
dGhpcyBzZXNzaW9uIGZpcnN0LCBhbmQgdGhlbgo+IHRoZSBzZXNzaW9uIGl0IHdpbGwgZ28gYXdh
eS4gCj4gCj4gICAKPiAKPiBLaWxsaW5nIHNlc3Npb25zIGluIE9yYWNsZSBoYXMgYWx3YXlzIGJl
ZW4gd2VpcmQuICBTb21ldGltZXMgdGhleSBnbyBhd2F5Cj4gYW5kIHNvbWV0aW1lcyBub3QsIGRl
cGVuZGluZyBvbiBPUy4gIEluIFdpbmRvd3MsIHVzZSBvcmFraWxsIHRvIGtpbGwgdGhlCj4gc2Vz
c2lvbiCoQyB0aGlzIGFsd2F5cyBzZWVtcyB0byB3b3JrIGluIHdpbmRvd3MuICBBbmQga2lsbGlu
ZyB0aGUgdW5peAo+IHNlc3Npb24gdGhlbiB0aGUgT3JhY2xlIHNlc3Npb24gc2VlbXMgdG8gd29y
ayBqdXN0IGZpbmUgaW4gQUlYLiAKPiAKPiAgIAo+ICAKPiAgX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX18KPiAgCj4gCj4gRnJvbTogb3JhY2xlLWwtYm91bmNlQGZyZWVsaXN0cy5vcmcg
W21haWx0bzpvcmFjbGUtbC1ib3VuY2VAZnJlZWxpc3RzLm9yZ10KPiBPbiBCZWhhbGYgT2YgQ2hp
cmFnIERCQQo+IFNlbnQ6IFRodXJzZGF5LCBTZXB0ZW1iZXIgMTUsIDIwMDUgMTA6MzYgQU0KPiBU
bzogYXNrZGJhQGZyZWVsaXN0cy5vcmc7IE9yYWNsZS1MIEZyZWVsaXN0cwo+IFN1YmplY3Q6IFNl
c3Npb24gS2lsbGVkLi4uISEgCj4gCj4gICAKPiAgCj4gCj4gSGkgLCAKPiAgCj4gCj4gICAKPiAg
Cj4gCj4gSSBzYXcgbWFueSB1c2VycyBvbiBteSBkYXRhYmFzZSBjb25uZWN0ZWQgZm9yIG1vcmUg
dGhhbiA2IGRheXMgd2l0aG91dCBhbnkKPiBhY3Rpdml0eS4gCj4gIAo+IAo+ICAgCj4gIAo+IAo+
IEkga2lsbGVkIDEgdXNlciBhbmQgc3RpbGwgdGhlIHN0YXR1cyBpbiB2JHNlc3Npb24gaXMgc2hv
d2luZyBhcyBraWxsZWQuIAo+ICAKPiAKPiAgIAo+ICAKPiAKPiBidXQgaXQgaXQgbm90IGdldHRp
bmcgcmVtb3ZlZCBmcm9tIHRoZSB2JHNlc3Npb24uIAo+ICAKPiAKPiAgIAo+ICAKPiAKPiBJIGFt
IHJ1bm5pbmcgOS4wLjEuMyBvbiBzb2xhcmlzLiAKPiAgCj4gCj4gICAKPiAgCj4gCj4gYW55IGlk
ZWE/IFdlIGFscmVhZHkgaGl0IHRoZSBidWcgb3JhLTA3NDQyLiAKPiAgCj4gCj4gICAKPiAgCj4g
Cj4gcmVnYXJkcyAtIGNoaXJhZyAKCgotLSAKWWFvIFlvbmdwaW5nCkxlYXJuaW5nIE9yYWNsZSwg
VU5JWC9MaW51eC4uLgpMb3ZlIFJlYWRpbmcsIENsYXNzaWNhbCBNdXNpYywgUGhpbG9zb3BoeSwg
RWNvbm9taWNzIGV0Yy4KQmxvZzogaHR0cDovL2Jsb2cuY3Nkbi5uZXQvZXJuCiAgICAgICAgIGh0
dHA6Ly9zcGFjZXMubXNuLmNvbS9tZW1iZXJzL3lhb3lwLwo=
--
http://www.freelists.org/webpage/oracle-l