OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » ORA-12560

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12560 [message #72686]

Wed, 03 September 2003 13:33

Shah
Messages: 36
Registered: June 2002

Member

Hi,
We have an application that uses crystal reports to run reports from an oracle database. The reports suddenly started taking a long time. We tried to run the report from several different machines. Every machine we put the client on had generated a SQLNET.log file. Every files had the same ORA-12560 TNS protocol adapter error. Any clues on why this would be haapening. We have tried everything possible but can't get the reports to run. Also the trace files and alert logs showed ora-12571. This application was running fine for the last 6 months.
Thanks

Report message to a moderator

Re: ORA-12560 [message #72687 is a reply to message #72686]

Thu, 04 September 2003 07:03

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

check your listener configuration and post it.
if possible please post the trace also.

Report message to a moderator

Re: ORA-12560 [message #72688 is a reply to message #72686]

Thu, 04 September 2003 09:37

Shah
Messages: 36
Registered: June 2002

Member

Hi,
Here is the trace file.

Dump file C:ORA817RDBMSTRACEORA01152.TRC
Tue Jul 08 14:51:32 2003
ORACLE V8.1.7.4.1 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
With the Partitioning option
JServer Release 8.1.7.4.1 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: ltan

Redo thread mounted by this instance: 1

Oracle process number: 17

Windows thread id: 1152, image: ORACLE.EXE

*** 2003-07-08 14:51:32.171
*** SESSION ID:(19.22912) 2003-07-08 14:51:32.140
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2003-07-08 14:51:32.171
ksedmp: internal or fatal error
ORA-12571: TNS:packet writer failure
Current SQL statement for this session:
SELECT "CP"."ORIGIN", "CP"."SOURCE", "CP"."CATEGORY", "CP"."EVENTNUMBER", "CP"."ERRORNUMBER", "CP"."USERNAME", "CP"."NODENAME", "CP"."SERVERNAME", "CP"."LOGDATE", "CP"."HOURS", "CP"."MINUTES", "CP"."SECONDS", "CP"."OBJECT1", "CP"."CLASS1", "CP"."ATTRIBUTE1", "CP"."VALUE1", "CP"."OBJECT2", "CP"."CLASS2", "CP"."ATTRIBUTE2", "CP"."GWREF", "CP"."INSERTDATETIME", "CP"."DESCRIPTION1", "CP"."DESCRIPTION2", "CP"."DESCRIPTION4" FROM "BLADMIN"."VIEW_LTA_REPORT_80_NEW" "CP" WHERE "CP"."ORIGIN" LIKE 'LT Auditor+ Processed Log' AND "CP"."SOURCE" LIKE 'NetWare' AND "CP"."CATEGORY" LIKE 'File' AND "CP"."EVENTNUMBER" = 3.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+a8 CALLrel _ksedst+0
A2E470
_opitsk+f4a CALLrel _ksedmp+0 2
_opiino+50c CALLrel _opitsk+0 0
_opiodr+507 CALLreg 00000000 3C 4
4A2FBF8
_opidrv+384 CALLrel _opiodr+0 3C 4
4A2FBF8
0
_sou2o+19 CALLrel _opidrv+0
_opimai+10c CALLrel _sou2o+0
_OracleThreadStart@4+4b8 CALLrel _opimai+0 2
4A2FE74
77E87587 CALLreg 00000000
----- Argument/Register Address Dump -----
Argument/Register addr=4a2e470.
Dump of memory from 0x4A2E430 to 0x4A2E570
4A2E430 00000003 00000000 65522100 00000033 [[.........!Re3...]]
4A2E440 00000000 00000003 04A2E405 00000000 [[................]]
4A2E450 00000000 00000000 1BB1CFF0 00000000 [[................]]
4A2E460 0000001D 04A2E47C 0041E0D4 00000001 [[....&#124.....A.....]]
4A2E470 00E2D194 00E2D194 00E2D194 00E2D19C [[................]]
4A2E480 00E2D194 00E2D194 00E2D194 00E2D194 [[................]]
4A2E490 00E2D19C 00000000 00000000 00000000 [[................]]
4A2E4A0 1BB1CFF0 04A2E558 0041EFE9 04A2E4BC [[....X.....A.....]]
4A2E4B0 0000001C 1BB1CFF0 00000002 2A2A2A0A [[.............***]]
4A2E4C0 30303220 37302D33 2038302D 353A3431 [[ 2003-07-08 14:5]]
4A2E4D0 32333A31 32332D25 2D252073 25207338 [[1:32%-32s %-8s %]]
4A2E4E0 7332332D 00000020 04A2E500 60B15218 [[-32s ........R.`]]
4A2E4F0 04A60030 32413420 34374546 25207300 [[0... 4A2FE74.s %]]
4A2E500 7332332D 342D2520 04000A73 0000311B [[-32s %-4s....1..]]
4A2E510 655221B4 1BB10033 00000000 00000000 [[.!Re3...........]]
4A2E520 00000000 00000000 00000000 00000000 [[................]]
4A2E530 04A2FFEC 00000000 04A2FE74 00000000 [[........t.......]]
4A2E540 00000001 00000001 00000000 04A2DCB8 [[................]]
4A2E550 00000003 04A2E57C 004834FD 04A2E494 [[....&#124....4H.....]]
4A2E560 00000000 0000311B 1BB1FC88 00000000 [[.....1..........]]
Argument/Register addr=4a2fbf8.
Dump of memory from 0x4A2FBB8 to 0x4A2FCF8
4A2FBB0 04A2FBEC 001F0003 [[........]]
4A2FBC0 04A2FBCC 04A64B1C 60840538 00000000 [[.....K..8..`....]]
4A2FBD0 00000000 04000000 00000000 00000000 [[................]]
4A2FBE0 00000000 00360034 00000000 00000BB0 [[....4.6.........]]
4A2FBF0 04A2FC10 77E8D7F4 04A2FD7F FFFFFFFF [[.......w........]]
4A2FC00 00000000 00000001 00000000 04A2FE88 [[................]]
4A2FC10 77E86AB4 04A2FFB4 0040318D 00000002 [[.j.w.....1@.....]]
4A2FC20 04A2FE74 014B8BF4 77D4EA27 014B9080 [[t.....K.'..w..K.]]
4A2FC30 1BB22A20 004000C8 74FD182C 04A2FC88 [[ *....@.,..t....]]
4A2FC40 77F8ABA4 00400000 00000001 00000009 [[...w..@.........]]
4A2FC50 00000000 44414853 00000000 74FD0000 [[....SHAD.......t]]
4A2FC60 00000002 011F4514 00000000 00000BBC [[.....E..........]]
4A2FC70 04A2FC54 000C4004 04A2FD0C 77FB9DA7 [[T....@.........w]]
4A2FC80 77F8ABE8 FFFFFFFF 04A2FD1C 77F8AD46 [[...w........F..w]]
4A2FC90 00400000 00000002 7FFDF000 7FFA8000 [[..@.............]]
4A2FCA0 77F86000 77FCF348 77F85FBA 04A2FD30 [[.`.wH..w._.w0...]]
4A2FCB0 77D4EA27 014B9080 00000000 00000000 [['..w..K.........]]
4A2FCC0 00000000 00000000 00000000 00000000 [[................]]
Repeat 2 times
4A2FCF0 00000000 7FFA8000 [[........]]
Argument/Register addr=4a2fe74.
Dump of memory from 0x4A2FE34 to 0x4A2FF74
4A2FE30 00000000 A5599B90 00000000 [[......Y.....]]
4A2FE40 E1003A78 00000000 A5599B58 A5599C28 [[x:......X.Y.(.Y.]]
4A2FE50 804FE8F9 A5599B90 804FB270 A5599B90 [[..O...Y.p.O...Y.]]
4A2FE60 885BBA68 804D950E A5599B74 00000001 [[h.[[...M.t.Y.....]]
4A2FE70 A54B6000 04A2FD74 04A2FD7F 00000002 [[.`K.t...........]]
4A2FE80 00000000 00000001 61726F2A 77617073 [[........*oraspaw]]
4A2FE90 65725F6E 5F796C70 6E61746C 3531315F [[n_reply_ltan_115]]
4A2FEA0 00002A32 00000000 A5599BE8 00000000 [[2*........Y.....]]
4A2FEB0 00000000 00000000 800651C1 800651C1 [[.........Q...Q..]]
4A2FEC0 00000000 00000000 00000000 00000000 [[................]]
Repeat 1 times
4A2FEE0 00000000 00000000 00000000 A5599BA8 [[..............Y.]]
4A2FEF0 00020048 80414C0B 00000000 00000000 [[H....LA.........]]
4A2FF00 00000000 00000000 FFFFFFFF FFFFFFFF [[................]]
4A2FF10 00000000 00000000 88827420 FFDFF000 [[........ t......]]
4A2FF20 802F5000 00000000 80064C3F 00000008 [[.P/.....?L......]]
4A2FF30 88654B80 88827420 00000000 8882748C [[.Ke. t.......t..]]
4A2FF40 88827420 888275B0 8042BD4D 88827420 [[ t...u..M.B. t..]]
4A2FF50 88827580 800654E0 A5599C78 A5599C78 [[.u...T..x.Y.x.Y.]]
4A2FF60 804D909A 00000003 00000000 A5599CB0 [[..M...........Y.]]
4A2FF70 00000000 [[....]]
----- End of Call Stack Trace -----
===================================================
Files currently opened by this process:
===================================================
PROCESS STATE
-------------
Process global information:
process: 140ba730, call: 0, xact: 0, curses: 0, usrses: 140cfc60
----------------------------------------
SO: 140ba730, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
(process) Oracle pid=17, calls cur/top: 0/140eaf8c, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 0
last post received-location: No post
last process to post me: none
last post sent: 0 0 0
last post sent-location: No post
last process posted by me: none
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 140c2bd4
O/S info: user: SYSTEM, term: TELEDB03, ospid: 1152
OSD pid info: 1152
----------------------------------------
SO: 140cfc60, type: 3, owner: 140ba730, pt: 0, flag: INIT/-/-/0x00
(session) trans: 0, creator: 140ba730, flag: (8000041) USR/- -/-/-/-/-/-
DID: 0000-0000-00000000, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, user: 19/BLADMIN
O/S info: user: ajhernan, term: PORT-8SD3ADJ1VK, ospid: 1072:132, machine: WORKGROUPPORT-8SD3ADJ1VK
program: RptCP.exe
last wait for 'SQL*Net break/reset to client' blocking sess=0x0 seq=17420 wait_time=-2
driver id=54435000, break?=1, =0
----------------------------------------
SO: 14533a90, type: 36, owner: 140cfc60, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=14533a90 handle=0 lock=145328cc
user=140cfc60 session=140cfc60 count=0 mask=0000 savepoint=103 flags=[[00]]
----------------------------------------
SO: 145328cc, type: 35, owner: 140cfc60, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=145328cc handle=137ff020 mode=N
call pin=0 session pin=14533a90
user=140cfc60 session=140cfc60 count=1 flags=[[00]] savepoint=103
LIBRARY OBJECT HANDLE: handle=137ff020
namespace=CRSR flags=RON/KGHP/PN0/[[10010000]]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=137ff038[[137ff038,137ff038]] ltm=137ff040[[137ff040,137ff040]]
pwt=137ff050[[137ff050,137ff050]] ptm=137ff0a8[[137ff0a8,137ff0a8]]
ref=137ff028[[13953970,13953970]] lnd=137ff0b4[[137ff0b4,137ff0b4]]
LIBRARY OBJECT: object=1395f768
type=CRSR flags=EXS[[0001]] pflags= [[00]] status=VALD load=0
DEPENDENCIES: count=2 size=16
ACCESSES: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 13960358 1386f4b4 I/P/A 0 NONE
6 1395f7fc 137d06ac I/-/A 0 NONE
----------------------------------------
SO: 14532494, type: 35, owner: 140cfc60, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=14532494 handle=137b5a40 mode=N
call pin=145339b8 session pin=0
user=140cfc60 session=140cfc60 count=1 flags=[[00]] savepoint=102
LIBRARY OBJECT HANDLE: handle=137b5a40
name=
SELECT "CP"."ORIGIN", "CP"."SOURCE", "CP"."CATEGORY", "CP"."EVENTNUMBER", "CP"."ERRORNUMBER", "CP"."USERNAME", "CP"."NODENAME", "CP"."SERVERNAME", "CP"."LOGDATE", "CP"."HOURS", "CP"."MINUTES", "CP"."SECONDS", "CP"."OBJECT1", "CP"."CLASS1", "CP"."ATTRIBUTE1", "CP"."VALUE1", "CP"."OBJECT2", "CP"."CLASS2", "CP"."ATTRIBUTE2", "CP"."GWREF", "CP"."INSERTDATETIME", "CP"."DESCRIPTION1", "CP"."DESCRIPTION2", "CP"."DESCRIPTION4" FROM "BLADMIN"."VIEW_LTA_REPORT_80_NEW" "CP" WHERE "CP"."ORIGIN" LIKE 'LT Auditor+ Proces
hash=77e4a63b timestamp=07-08-2003 10:26:52
namespace=CRSR flags=RON/KGHP/TIM/PN0/[[10010000]]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=137b5a58[[137b5a58,137b5a58]] ltm=137b5a60[[137b5a60,137b5a60]]
pwt=137b5a70[[137b5a70,137b5a70]] ptm=137b5ac8[[137b5ac8,137b5ac8]]
ref=137b5a48[[137b5a48,137b5a48]] lnd=137b5ad4[[137b5ad4,137b5ad4]]
LIBRARY OBJECT: object=139537e8
type=CRSR flags=EXS[[0001]] pflags= [[00]] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 139539a4 13953970 137ff020
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 139603b8 1395386c I/P/A 0 NONE
----------------------------------------
SO: 1452d7d8, type: 36, owner: 140cfc60, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1452d7d8 handle=137b985c mode=S lock=1452c5b4
user=140cfc60 session=140cfc60 count=1 mask=0041 savepoint=97 flags=[[00]]
----------------------------------------
SO: 1452c5b4, type: 35, owner: 140cfc60, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1452c5b4 handle=137b985c mode=N
call pin=0 session pin=1452d7d8
user=140cfc60 session=140cfc60 count=1 flags=PNS/[[08]] savepoint=97
LIBRARY OBJECT HANDLE: handle=137b985c
namespace=CRSR flags=RON/KGHP/PN0/[[10010000]]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch=3
lwt=137b9874[[137b9874,137b9874]] ltm=137b987c[[137b987c,137b987c]]
pwt=137b988c[[137b988c,137b988c]] ptm=137b98e4[[137b98e4,137b98e4]]
ref=137b9864[[154ea9b4,154ea9b4]] lnd=137b98f0[[137b98f0,137b98f0]]
LIBRARY OBJECT: object=154ea4e0
type=CRSR flags=EXS[[0001]] pflags= [[00]] status=VALD load=0
DEPENDENCIES: count=6 size=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 154ea6e8 137f4d88 I/P/A 0 NONE
6 154ea574 137bbf04 I/P/A 1 NONE
----------------------------------------
SO: 1452c320, type: 35, owner: 140cfc60, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1452c320 handle=132fbb0c mode=N
call pin=1452d748 session pin=0
user=140cfc60 session=140cfc60 count=1 flags=[[00]] savepoint=96
LIBRARY OBJECT HANDLE: handle=132fbb0c
name=select version from product_component_version where product like 'Ora%'
hash=86b4a5f3 timestamp=07-08-2003 10:26:52
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[[50010000]]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=3
lwt=132fbb24[[132fbb24,132fbb24]] ltm=132fbb2c[[132fbb2c,132fbb2c]]
pwt=132fbb3c[[132fbb3c,132fbb3c]] ptm=132fbb94[[132fbb94,132fbb94]]
ref=132fbb14[[132fbb14,132fbb14]] lnd=132fbba0[[132fbba0,132fbba0]]
LIBRARY OBJECT: object=154ea82c
type=CRSR flags=EXS[[0001]] pflags= [[00]] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 154ea9e8 154ea9b4 137b985c
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 154fd008 154ea8b0 I/P/A 0 NONE
----------------------------------------
SO: 145307d8, type: 35, owner: 140cfc60, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=145307d8 handle=13ad5cf0 mode=N
call pin=14531948 session pin=0
user=140cfc60 session=140cfc60 count=1 flags=CBB/[[02]] savepoint=81
LIBRARY OBJECT HANDLE: handle=13ad5cf0
name=SYS.DATABASE
hash=aea96fa0 timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[[02000000]]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=2
lwt=13ad5d08[[13ad5d08,13ad5d08]] ltm=13ad5d10[[13ad5d10,13ad5d10]]
pwt=13ad5d20[[13ad5d20,13ad5d20]] ptm=13ad5d78[[13ad5d78,13ad5d78]]
ref=13ad5cf8[[13ad5cf8,13ad5cf8]] lnd=13ad5d84[[13ad5d84,13ad5d84]]
LIBRARY OBJECT: object=106cc958
type=EVNT flags=EXS/LOC[[0005]] pflags= [[00]] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 106cca44 162e3c88 I/-/A 0 NONE
3 162e3c38 15b2a2b4 I/-/A 0 NONE
----------------------------------------
SO: 14537a44, type: 35, owner: 140cfc60, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=14537a44 handle=13a088d4 mode=N
call pin=145389f8 session pin=0
user=140cfc60 session=140cfc60 count=1 flags=CBB/[[02]] savepoint=81
LIBRARY OBJECT HANDLE: handle=13a088d4
name=BLADMIN.BLADMIN
hash=771e19af timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[[02000000]]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=0
lwt=13a088ec[[13a088ec,13a088ec]] ltm=13a088f4[[13a088f4,13a088f4]]
pwt=13a08904[[13a08904,13a08904]] ptm=13a0895c[[13a0895c,13a0895c]]
ref=13a088dc[[13a088dc,13a088dc]] lnd=13a08968[[13a08968,13a08968]]
LIBRARY OBJECT: object=1389d270
type=EVNT flags=EXS/LOC[[0005]] pflags= [[00]] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 1389d478 1389d354 I/-/A 0 NONE
3 1389d304 137ddd04 I/-/A 0 NONE
----------------------------------------
SO: 13afd710, type: 34, owner: 140cfc60, pt: 0, flag: INIT/-/-/0x00
user lock: lock=13afd710 mode=S
user resource: user=1453f178 uid=19 mode=S
----------------------------------------
SO: 1396c108, type: 34, owner: 140cfc60, pt: 0, flag: INIT/-/-/0x00
user lock: lock=1396c108 mode=S
user resource: user=1453f178 uid=19 mode=S
----------------------------------------
SO: 1412b6c4, type: 9, owner: 140ba730, pt: 0, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 140ba730,
event: 26, last message event: 26, messages read: 0
channel: (1412c494) system events broadcast channel
scope: 101, event: 26, last mesage event: 0,
publishers/subscribers: 0/16,
messages published: 0
----------------------------------------
SO: 140eaf8c, type: 2, owner: 140ba730, pt: 0, flag: INIT/-/-/0x00
(call) sess: cur 140cfc60, rec 0, usr 140cfc60; depth: 0
END OF PROCESS STATE
Dump file C:ORA817RDBMSTRACEORA01152.TRC
Tue Jul 08 16:08:32 2003
ORACLE V8.1.7.4.1 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
With the Partitioning option
JServer Release 8.1.7.4.1 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: ltan

Redo thread mounted by this instance: 1

Oracle process number: 17

Windows thread id: 1152, image: ORACLE.EXE

*** 2003-07-08 16:08:32.312
*** SESSION ID:(10.24172) 2003-07-08 16:08:32.296
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2003-07-08 16:08:32.312
ksedmp: internal or fatal error
ORA-12571: TNS:packet writer failure
Current SQL statement for this session:
SELECT "CP"."ORIGIN", "CP"."SOURCE", "CP"."CATEGORY", "CP"."EVENTNUMBER", "CP"."ERRORNUMBER", "CP"."USERNAME", "CP"."NODENAME", "CP"."SERVERNAME", "CP"."LOGDATE", "CP"."HOURS", "CP"."MINUTES", "CP"."SECONDS", "CP"."OBJECT1", "CP"."CLASS1", "CP"."ATTRIBUTE1", "CP"."VALUE1", "CP"."OBJECT2", "CP"."CLASS2", "CP"."ATTRIBUTE2", "CP"."GWREF", "CP"."INSERTDATETIME", "CP"."DESCRIPTION1", "CP"."DESCRIPTION2", "CP"."DESCRIPTION4" FROM "BLADMIN"."VIEW_LTA_REPORT_80_NEW" "CP" WHERE "CP"."ORIGIN" LIKE 'LT Auditor+ Processed Log' AND "CP"."SOURCE" LIKE 'NetWare' AND "CP"."CATEGORY" LIKE 'File' AND "CP"."EVENTNUMBER" = 3.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+a8 CALLrel _ksedst+0
A2E470
_opitsk+f4a CALLrel _ksedmp+0 2
_opiino+50c CALLrel _opitsk+0 0
_opiodr+507 CALLreg 00000000 3C 4
4A2FBF8
_opidrv+384 CALLrel _opiodr+0 3C 4
4A2FBF8
0
_sou2o+19 CALLrel _opidrv+0
_opimai+10c CALLrel _sou2o+0
_OracleThreadStart@4+4b8 CALLrel _opimai+0 2
4A2FE74
77E87587 CALLreg 00000000
----- Argument/Register Address Dump -----
Argument/Register addr=4a2e470.
Dump of memory from 0x4A2E430 to 0x4A2E570
4A2E430 00000003 00000000 65522100 00000033 [[.........!Re3...]]
4A2E440 00000000 00000003 04A2E405 00000000 [[................]]
4A2E450 00000000 00000000 1BB1CFF0 00000000 [[................]]
4A2E460 0000001D 04A2E47C 0041E0D4 00000001 [[....&#124.....A.....]]
4A2E470 00E2D194 00E2D194 00E2D194 00E2D19C [[................]]
4A2E480 00E2D194 00E2D194 00E2D194 00E2D194 [[................]]
4A2E490 00E2D19C 00000000 00000000 00000000 [[................]]
4A2E4A0 1BB1CFF0 04A2E558 0041EFE9 04A2E4BC [[....X.....A.....]]
4A2E4B0 0000001C 1BB1CFF0 00000002 2A2A2A0A [[.............***]]
4A2E4C0 30303220 37302D33 2038302D 303A3631 [[ 2003-07-08 16:0]]
4A2E4D0 32333A38 32332D25 2D252073 25207338 [[8:32%-32s %-8s %]]
4A2E4E0 7332332D 00000020 04A2E500 60B15218 [[-32s ........R.`]]
4A2E4F0 04A60030 32413420 34374546 25207300 [[0... 4A2FE74.s %]]
4A2E500 7332332D 342D2520 04000A73 0000311B [[-32s %-4s....1..]]
4A2E510 655221B4 1BB10033 00000000 00000000 [[.!Re3...........]]
4A2E520 00000000 00000000 00000000 00000000 [[................]]
4A2E530 04A2FFEC 00000000 04A2FE74 00000000 [[........t.......]]
4A2E540 00000001 00000001 00000000 04A2DCB8 [[................]]
4A2E550 00000003 04A2E57C 004834FD 04A2E494 [[....&#124....4H.....]]
4A2E560 00000000 0000311B 1BB1FC88 00000000 [[.....1..........]]
Argument/Register addr=4a2fbf8.
Dump of memory from 0x4A2FBB8 to 0x4A2FCF8
4A2FBB0 04A2FBEC 001F0003 [[........]]
4A2FBC0 04A2FBCC 04A64B1C 60840538 00000000 [[.....K..8..`....]]
4A2FBD0 00000000 04000000 00000000 00000000 [[................]]
4A2FBE0 00000000 00360034 00000000 00000BC8 [[....4.6.........]]
4A2FBF0 04A2FC10 77E8D7F4 04A2FD7F FFFFFFFF [[.......w........]]
4A2FC00 00000000 00000001 00000000 04A2FE88 [[................]]
4A2FC10 77E86AB4 04A2FFB4 0040318D 00000002 [[.j.w.....1@.....]]
4A2FC20 04A2FE74 014B8BF4 77D4EA27 014B9080 [[t.....K.'..w..K.]]
4A2FC30 1BB22A20 004000C8 74FD182C 04A2FC88 [[ *....@.,..t....]]
4A2FC40 77F8ABA4 00400000 00000001 00000009 [[...w..@.........]]
4A2FC50 00000000 44414853 00000000 74FD0000 [[....SHAD.......t]]
4A2FC60 00000002 011F4514 00000000 00000BE4 [[.....E..........]]
4A2FC70 04A2FC54 000C4004 04A2FD0C 77FB9DA7 [[T....@.........w]]
4A2FC80 77F8ABE8 FFFFFFFF 04A2FD1C 77F8AD46 [[...w........F..w]]
4A2FC90 00400000 00000002 7FFDF000 7FFA8000 [[..@.............]]
4A2FCA0 77F86000 77FCF348 77F85FBA 04A2FD30 [[.`.wH..w._.w0...]]
4A2FCB0 77D4EA27 014B9080 00000000 00000000 [['..w..K.........]]
4A2FCC0 00000000 00000000 00000000 00000000 [[................]]
Repeat 2 times
4A2FCF0 00000000 7FFA8000 [[........]]
Argument/Register addr=4a2fe74.
Dump of memory from 0x4A2FE34 to 0x4A2FF74
4A2FE30 896ED840 00000700 8044CA2E [[@.n.......D.]]
4A2FE40 00043858 896ED840 7FFA8201 000136F0 [[X8..@.n......6..]]
4A2FE50 7FFA8201 00000041 00000002 8042C0A4 [[....A.........B.]]
4A2FE60 00000001 A5599BA4 00000000 A5599B84 [[......Y.......Y.]]
4A2FE70 8044D739 04A2FD74 04A2FD7F 00000000 [[9.D.t...........]]
4A2FE80 C01FFEA0 00000000 61726F2A 77617073 [[........*oraspaw]]
4A2FE90 65725F6E 5F796C70 6E61746C 3531315F [[n_reply_ltan_115]]
4A2FEA0 00002A32 7FFA8000 88339DE8 88654C01 [[2*........3..Le.]]
4A2FEB0 00000000 C01FFEA0 00000001 800651C1 [[.............Q..]]
4A2FEC0 00000000 02599C44 00000001 80482E18 [[....D.Y.......H.]]
4A2FED0 8908F420 89051DA0 80432749 80482E10 [[ .......I'C...H.]]
4A2FEE0 89051DA0 804328B5 0000000A 0000000E [[.....(C.........]]
4A2FEF0 7FFA8000 88DCDB00 0000000A 00000000 [[................]]
4A2FF00 00000000 00000000 8905A4E4 FFFFFFFF [[................]]
4A2FF10 A5599D14 00000000 884CADA0 FFDFF000 [[..Y.......L.....]]
4A2FF20 802F5000 00000000 80064C3F 00000008 [[.P/.....?L......]]
4A2FF30 88654B80 884CADA0 00000000 884CAE0C [[.Ke...L.......L.]]
4A2FF40 884CADA0 884CAF30 8042BD4D 884CADA0 [[..L.0.L.M.B...L.]]
4A2FF50 884CAF00 800654E0 00000202 80469DC9 [[..L..T........F.]]
4A2FF60 A5599C70 00000000 00000000 A5599CB0 [[p.Y...........Y.]]
4A2FF70 00000000 [[....]]
----- End of Call Stack Trace -----
===================================================
Files currently opened by this process:
===================================================
PROCESS STATE
-------------
Process global information:
process: 140ba730, call: 0, xact: 0, curses: 0, usrses: 140cb094
----------------------------------------
SO: 140ba730, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
(process) Oracle pid=17, calls cur/top: 0/140eaf8c, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 0
last post received-location: No post
last process to post me: none
last post sent: 0 0 13
last post sent-location: ksasnd
last process posted by me: 140b7b00 1 2
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 140c2bd4
O/S info: user: SYSTEM, term: TELEDB03, ospid: 1152
OSD pid info: 1152
----------------------------------------
SO: 140cb094, type: 3, owner: 140ba730, pt: 0, flag: INIT/-/-/0x00
(session) trans: 0, creator: 140ba730, flag: (8000041) USR/- -/-/-/-/-/-
DID: 0000-0000-00000000, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, user: 19/BLADMIN
O/S info: user: ajhernan, term: PORT-8SD3ADJ1VK, ospid: 132:896, machine: WORKGROUPPORT-8SD3ADJ1VK
program: RptCP.exe
last wait for 'SQL*Net break/reset to client' blocking sess=0x0 seq=58889 wait_time=-2
driver id=54435000, break?=1, =0
----------------------------------------
SO: 145334a8, type: 36, owner: 140cb094, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=145334a8 handle=0 lock=14532aac
user=140cb094 session=140cb094 count=0 mask=0000 savepoint=103 flags=[[00]]
----------------------------------------
SO: 14532aac, type: 35, owner: 140cb094, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=14532aac handle=137ff020 mode=N
call pin=0 session pin=145334a8
user=140cb094 session=140cb094 count=1 flags=[[00]] savepoint=103
LIBRARY OBJECT HANDLE: handle=137ff020
namespace=CRSR flags=RON/KGHP/PN0/[[10010000]]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=137ff038[[137ff038,137ff038]] ltm=137ff040[[137ff040,137ff040]]
pwt=137ff050[[137ff050,137ff050]] ptm=137ff0a8[[137ff0a8,137ff0a8]]
ref=137ff028[[13953970,13953970]] lnd=137ff0b4[[137ff0b4,137ff0b4]]
LIBRARY OBJECT: object=1395f768
type=CRSR flags=EXS[[0001]] pflags= [[00]] status=VALD load=0
DEPENDENCIES: count=2 size=16
ACCESSES: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 13960358 1386f4b4 I/P/A 0 NONE
6 1395f7fc 137d06ac I/-/A 0 NONE
----------------------------------------
SO: 14532548, type: 35, owner: 140cb094, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=14532548 handle=137b5a40 mode=N
call pin=14533ad8 session pin=0
user=140cb094 session=140cb094 count=1 flags=[[00]] savepoint=102
LIBRARY OBJECT HANDLE: handle=137b5a40
name=
SELECT "CP"."ORIGIN", "CP"."SOURCE", "CP"."CATEGORY", "CP"."EVENTNUMBER", "CP"."ERRORNUMBER", "CP"."USERNAME", "CP"."NODENAME", "CP"."SERVERNAME", "CP"."LOGDATE", "CP"."HOURS", "CP"."MINUTES", "CP"."SECONDS", "CP"."OBJECT1", "CP"."CLASS1", "CP"."ATTRIBUTE1", "CP"."VALUE1", "CP"."OBJECT2", "CP"."CLASS2", "CP"."ATTRIBUTE2", "CP"."GWREF", "CP"."INSERTDATETIME", "CP"."DESCRIPTION1", "CP"."DESCRIPTION2", "CP"."DESCRIPTION4" FROM "BLADMIN"."VIEW_LTA_REPORT_80_NEW" "CP" WHERE "CP"."ORIGIN" LIKE 'LT Auditor+ Proces
hash=77e4a63b timestamp=07-08-2003 10:26:52
namespace=CRSR flags=RON/KGHP/TIM/PN0/[[10010000]]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=137b5a58[[137b5a58,137b5a58]] ltm=137b5a60[[137b5a60,137b5a60]]
pwt=137b5a70[[137b5a70,137b5a70]] ptm=137b5ac8[[137b5ac8,137b5ac8]]
ref=137b5a48[[137b5a48,137b5a48]] lnd=137b5ad4[[137b5ad4,137b5ad4]]
LIBRARY OBJECT: object=139537e8
type=CRSR flags=EXS[[0001]] pflags= [[00]] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 139539a4 13953970 137ff020
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 139603b8 1395386c I/P/A 0 NONE
----------------------------------------
SO: 1452d748, type: 36, owner: 140cb094, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1452d748 handle=137b985c mode=S lock=1452c320
user=140cb094 session=140cb094 count=1 mask=0041 savepoint=97 flags=[[00]]
----------------------------------------
SO: 1452c320, type: 35, owner: 140cb094, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1452c320 handle=137b985c mode=N
call pin=0 session pin=1452d748
user=140cb094 session=140cb094 count=1 flags=PNS/[[08]] savepoint=97
LIBRARY OBJECT HANDLE: handle=137b985c
namespace=CRSR flags=RON/KGHP/PN0/[[10010000]]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch=3
lwt=137b9874[[137b9874,137b9874]] ltm=137b987c[[137b987c,137b987c]]
pwt=137b988c[[137b988c,137b988c]] ptm=137b98e4[[137b98e4,137b98e4]]
ref=137b9864[[154ea9b4,154ea9b4]] lnd=137b98f0[[137b98f0,137b98f0]]
LIBRARY OBJECT: object=154ea4e0
type=CRSR flags=EXS[[0001]] pflags= [[00]] status=VALD load=0
DEPENDENCIES: count=6 size=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 154ea6e8 137f4d88 I/P/A 0 NONE
6 154ea574 137bbf04 I/P/A 1 NONE
----------------------------------------
SO: 1452c8c0, type: 35, owner: 140cb094, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1452c8c0 handle=132fbb0c mode=N
call pin=1452d358 session pin=0
user=140cb094 session=140cb094 count=1 flags=[[00]] savepoint=96
LIBRARY OBJECT HANDLE: handle=132fbb0c
name=select version from product_component_version where product like 'Ora%'
hash=86b4a5f3 timestamp=07-08-2003 10:26:52
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[[50010000]]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=3
lwt=132fbb24[[132fbb24,132fbb24]] ltm=132fbb2c[[132fbb2c,132fbb2c]]
pwt=132fbb3c[[132fbb3c,132fbb3c]] ptm=132fbb94[[132fbb94,132fbb94]]
ref=132fbb14[[132fbb14,132fbb14]] lnd=132fbba0[[132fbba0,132fbba0]]
LIBRARY OBJECT: object=154ea82c
type=CRSR flags=EXS[[0001]] pflags= [[00]] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 154ea9e8 154ea9b4 137b985c
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 154fd008 154ea8b0 I/P/A 0 NONE
----------------------------------------
SO: 14530940, type: 35, owner: 140cb094, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=14530940 handle=13ad5cf0 mode=N
call pin=14531990 session pin=0
user=140cb094 session=140cb094 count=1 flags=CBB/[[02]] savepoint=81
LIBRARY OBJECT HANDLE: handle=13ad5cf0
name=SYS.DATABASE
hash=aea96fa0 timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[[02000000]]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=2
lwt=13ad5d08[[13ad5d08,13ad5d08]] ltm=13ad5d10[[13ad5d10,13ad5d10]]
pwt=13ad5d20[[13ad5d20,13ad5d20]] ptm=13ad5d78[[13ad5d78,13ad5d78]]
ref=13ad5cf8[[13ad5cf8,13ad5cf8]] lnd=13ad5d84[[13ad5d84,13ad5d84]]
LIBRARY OBJECT: object=106cc958
type=EVNT flags=EXS/LOC[[0005]] pflags= [[00]] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 106cca44 162e3c88 I/-/A 0 NONE
3 162e3c38 15b2a2b4 I/-/A 0 NONE
----------------------------------------
SO: 14537a44, type: 35, owner: 140cb094, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=14537a44 handle=13a088d4 mode=N
call pin=145389f8 session pin=0
user=140cb094 session=140cb094 count=1 flags=CBB/[[02]] savepoint=81
LIBRARY OBJECT HANDLE: handle=13a088d4
name=BLADMIN.BLADMIN
hash=771e19af timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[[02000000]]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=0
lwt=13a088ec[[13a088ec,13a088ec]] ltm=13a088f4[[13a088f4,13a088f4]]
pwt=13a08904[[13a08904,13a08904]] ptm=13a0895c[[13a0895c,13a0895c]]
ref=13a088dc[[13a088dc,13a088dc]] lnd=13a08968[[13a08968,13a08968]]
LIBRARY OBJECT: object=1389d270
type=EVNT flags=EXS/LOC[[0005]] pflags= [[00]] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 1389d478 1389d354 I/-/A 0 NONE
3 1389d304 137ddd04 I/-/A 0 NONE
----------------------------------------
SO: 13afd710, type: 34, owner: 140cb094, pt: 0, flag: INIT/-/-/0x00
user lock: lock=13afd710 mode=S
user resource: user=1453f178 uid=19 mode=S
----------------------------------------
SO: 1396c108, type: 34, owner: 140cb094, pt: 0, flag: INIT/-/-/0x00
user lock: lock=1396c108 mode=S
user resource: user=1453f178 uid=19 mode=S
----------------------------------------
SO: 1412b6c4, type: 9, owner: 140ba730, pt: 0, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 140ba730,
event: 27, last message event: 27, messages read: 0
channel: (1412c494) system events broadcast channel
scope: 101, event: 28, last mesage event: 0,
publishers/subscribers: 0/16,
messages published: 0
----------------------------------------
SO: 140eaf8c, type: 2, owner: 140ba730, pt: 0, flag: INIT/-/-/0x00
(call) sess: cur 140cb094, rec 0, usr 140cb094; depth: 0
END OF PROCESS STATE

Report message to a moderator

Previous Topic:	importing data from oracle9i to oracle8i
Next Topic:	e- Mail Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 11:47:01 CDT 2024