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

-none-

2004-04-28       - By -not available-

Reply:     <<     61     62     63     64     65     66     67     68     69     70     >>  

PROCESS 23:
-- ---- ---- ---- ---- ---- ---- ---- --
SO: d9523624, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
(process) Oracle pid=3D23, calls cur/top: d960d7d4/d960d7d4, flag: (0) =
-
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 3648316968 0 1
last post received-location: kslfre
last process to post me: d9522cd0 4 0
last post sent: 2147544044 0 1
last post sent-location: kslfre
last process posted by me: d9525220 41 0
(latch info) wait_event=3D0 bits=3D90
holding 8000ebec shared pool level=3D7=20
Location from where latch is held: kghfrunp: alloc: clatch
nowait:=20
Context saved from call: 0
state=3Dbusy
holding 8000c114 row cache objects level=3D4=20
Location from where latch is held: kghfrunp: clatch: nowait:=20
Context saved from call: 0
state=3Dbusy
Process Group: DEFAULT, pseudo proc: d955952c
O/S info: user: oracle, term: UNKNOWN, ospid: 5345
OSD pid info: 5345
-- ---- ---- ---- ---- ---- ---- ---- --
SO: d95991a0, type: 3, owner: d9523624, pt: 0, flag: INIT/-/-/0x00
(session) trans: 0, creator: d9523624, flag: (41) USR/-
BSY/-/-/-/-/-
DID: 0000-0000-00000000, short-term DID:
0000-0000-00000000
txn branch: 0
oct: 47, prv: 0, user: 20/SYSADM
O/S info: user: dp943, term: PHSPSPAPP8, ospid: 2028:3424, machine:
PARTNERS\PHSPSPAPP8
program: PSAPPSRV.exe
client info: ,dp943,PHSPSPAPP8,,PSAPPSRV.exe,
last wait for 'latch free ' blocking sess=3D0x0 seq=3D14093 wait_time=3D=
-1
address=3Dd974e628, number=3D6a, tries=3D1
-- ---- ---- ---- ---- ---- ---- ---- --
SO: d97c6674, type: 36, owner: d95991a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=3Dd97c6674 handle=3Dda02bb1c mode=3DX
lock=3Dd97d5c84
user=3Dd95991a0 session=3Dd95991a0 count=3D0 mask=3D007d savepoint=3D=
68
flags=3D[00]
-- ---- ---- ---- ---- ---- ---- ---- --
SO: d97d5c84, type: 35, owner: d95991a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=3Dd97d5c84 handle=3Dda02bb1c mode=3DN
call pin=3D0 session pin=3Dd97c6674
user=3Dd95991a0 session=3Dd95991a0 count=3D1 flags=3DPNS/[08] savep=
oint=3D68
LIBRARY OBJECT HANDLE: handle=3Dda02bb1c
namespace=3DCRSR flags=3DRON/KGHP/PN0/[10010000]
kkkk-dddd-llll=3D0000-0000-0000 lock=3DN pin=3DX latch=3D2
lwt=3Dda02bb34[da02bb34,da02bb34] ltm=3Dda02bb3c[da02bb3c,da02bb3c]
pwt=3Dda02bb4c[da02bb4c,da02bb4c] ptm=3Dda02bba4[da02bba4,da02bba4]
ref=3Dda02bb24[cac6f6d8,cac6f6d8] lnd=3Dda02bbb0[da02bbb0,da02bbb0]
LIBRARY OBJECT: object=3Ddadfc344
type=3DCRSR flags=3DEXS/BCM[0001] pflags=3DNST [101] status=3DVAL=
D
load=3D0
DEPENDENCIES: count=3D4 size=3D16
ACCESSES: count=3D1 size=3D16
TRANSLATIONS: count=3D1 size=3D16
DATA BLOCKS:
data# heap pointer status pins change
-- -- -- ----- -- ----- -- --- ---- -- ---
0 c9cee16c dadfc1b4 I/P/A 0 NONE =20
2 dadfc3d8 c9c4bb3c I/P/A 1 NONE =20
3 dadfc438 0 -/P/- 1 NONE =20
4 dadfc498 cf49aef0 I/P/A 1 NONE =20
5 dadfc104 0 -/P/- 1 NONE =20
6 dadfc164 cb43e3e4 I/P/A 1 NONE =20
-- ---- ---- ---- ---- ---- ---- ---- --
SO: d97cc9cc, type: 35, owner: d95991a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=3Dd97cc9cc handle=3Dcac6f768 mode=3DN


Any ideas are welcome. If you made it this far, thanks for the
perseverance and time you already invested.

Henry


-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected) put
'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --



-- Attached file included as plaintext by Ecartis --
-- Desc: Signature

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.


-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --