TNS:PROTOCOL ADAPTER ERROR
hi,
i am preaty new to oracle. i installed oracle 11gr2 on my laptop . it worked well for a while but one morning i tried logging in as sysdba but it refused, giving the error
ORA-12560 : TNS:PROTOCOL ADAPTER ERROR. PLEASE what does this mean? i restarted the listener,and nothing changed. then i checked the alert log and found this: (the file is too lengthy so i copied the middle and the end.)
ALERT LOG (THIS IS THE MIDDLE OF THE FILE)
Tue Jun 07 08:14:43 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê³
] [0x00515CF3]
0
0
A7E18E4
06F3D484 CALLreg 00000000
D0204DC
ADF3890
D023694
1
4
5
9
9F
32
0
r()+173 rEx()
BackgroundThreadSt CALLrel sss_xcpt_EvalFilte
C0000005
C95E4DC
9F
art@4()+761 r()
___dyn_tls_init_cal CALLptr 00000000
8196A20
C95FFD4
77B0B3F5
lback()+130396404
8196A20
7B2DF0C2
0
___dyn_tls_init_cal CALLreg 00000000
8196A20
7B2DF0C2
0
0
8196A20
lback()+137515896
0
B0304DC
B033694
1
0
B029A04
B029A08
06F3EF65 CALLrel 06F3EFDE
B0304DC
074AC11C CALLrel 074AAACA
C5404DC
C539264
C543F5C
C538E10
1
0
06F3D484 CALLreg 00000000
0
B2504DC
B253694
1
2
C538E10
B249AA0
BE486D8
C75D2F8
2462
075F10B6 CALLrel 06FD00BA
BE486D8
C75D2F8
2462
0
2
06E40950 CALLrel 06E40976
CB704DC
0
0
9
ADF38DC
ADF393C
800
06E40990 CALLrel 06E409A2
AE104D8
32
ADF393C
800
___dyn_tls_init_cal CALLrel ___dyn_tls_init_cal
40171E
8196A20
0
0
0
0
lback()+137515848 lback()+137515859
B033694
1
B029AA0
B029F20
0
06F3D484 CALLreg 00000000
B0304DC
B033694
1
0
2
B029AA0
B029F20
0
202
dbktPri()+117 CALLrel dbgtfPutStr()
C747FF8
32
CB6373C
800
3
0
06E407B6 CALLrel 06E4092E
CB704DC
CB645B4
06E5726A CALLrel 06E40756
CB704DC
CB645B4
CB63F8C
1
CB76ED8
CB66CD4
06E581B5 CALLrel 06E57212
CB704DC
CB76ED8
CB645B4
06E18F55 CALLrel 06E5812E
CB704DC
CB76ED8
1
0
4
9
06E40950 CALLrel 06E40976
AE104D8
32
ADF393C
800
3
0
06E407B6 CALLrel 06E4092E
00000000 CALL??? 00000000
----- End of Call Stack Trace -----
AE104D8
ADF47B4
Tue Jun 07 08:14:43 2011
0
C21285C
C213690
06E5726A CALLrel 06E40756
C21285C
AE104D8
ADF47B4
ADF418C
1
A7E2718
A7E18E4
0
E08
06FCCA8D CALLrel 074B4DBE
A7E18D4
A7E0F9C
B0304DC
1
B029FA4
3C
ksdfmw()+318 CALLrel dbktPri()
B029FA4
3C
ksdwrf()+16 CALLrel ksdfmw()
1
0
599D9C0
B02B00C
ksdwrfns()+65 CALLrel ksdwrf()
599D9C0
B02B024
B02B024
1000
782CF9C
0
B02C024
074CAE92 CALLreg 00000000
9A74F38
782CF9C
0
074B4E03 CALLrel 074CAE26
0
B02C860
B02C304
B02C860
0
E08
CB704DC
CB76ED8
075C6050 CALLrel 06E18F2A
CB704DC
CB76ED8
0
1
0
dbkePostKGEkgsf() CALLrel _dbgePostErrorKGE()
BE9DA28
CB7D2FC
258
+56
06FD092C CALLreg 00000000
BE9DA28
CB7D2FC
258
06FD07A5 CALLrel 06FD0818
BE9DA28
CB7D2FC
0
258
Tue Jun 07 08:14:44 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x87C440C0] [PC:0x515CF3, ¤Ê³
]
Tue Jun 07 08:14:44 2011
D00D468
D00D8E8
9
1
6E581B6
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_3256.trc (incident=157433):
ORA-07445: exception encountered: core dump [PC:0x515CF3] [ACCESS_VIOLATION] [ADDR:0x87C440C0] [PC:0x515CF3] [UNABLE_TO_READ] []
Tue Jun 07 08:14:47 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê³
] [0x00515CF3]
sssxcpt_EvalFilte CALLrel _skgdstpcs()
B02C850
B02C350
1
0
1
rEx()+3306
sssxcpt_EvalFilte CALLrel sssxcpt_EvalFilte
C0000005
B02E5C4
9F
r()+173 rEx()
BackgroundThreadSt CALLrel sss_xcpt_EvalFilte
C0000005
B02E5C4
9F
art@4()+761 r()
___dyn_tls_init_cal CALLptr 00000000
7E2F2B8
B02FFD4
77B0B3F5
lback()+130396404
7E2F2B8
E08
06FCCA8D CALLrel 074B4DBE
C21284C
C211F14
1
Tue Jun 07 08:14:45 2011
C747FF8
074C9B75 CALLreg 00000000
Tue Jun 07 08:14:47 2011
Tue Jun 07 08:14:48 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x87C440C0] [PC:0x515CF3, ¤Ê³
06FCCF8E CALLrel 06FCCA42
C748014
]
2462
0
075F109C CALLrel 074C9B66
C7481F4
6FD0086
C748014
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_644.trc (incident=157441):
ORA-07445: exception encountered: core dump [PC:0x515CF3] [ACCESS_VIOLATION] [ADDR:0x87C440C0] [PC:0x515CF3] [UNABLE_TO_READ] []
Tue Jun 07 08:14:48 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê³
] [0x00515CF3]
Tue Jun 07 08:14:46 2011
AE16ED4
ADF6ED4
9
1
6E581B6
06FCCF8E CALLrel 06FCCA42
C21284C
C213690
0
C211F14
A7E18D4
A7E2718
0
A7E0F9C
19
9
06FCE64A CALLrel 06FCCD1E
BE486D8
C7481F4
074AB5D9 CALLrel 06FD0060
BE486D8
C75D2F8
C7481F4
076DB286 CALLrel 074AB51E
C7504D8
C748254
C754000
074AAB09 CALLrel 074AAD2E
C7504D8
C749598
C753F58
C749189
1BD
1
0
0
C749144
0
202
074AC11C CALLrel 074AAACA
C7504D8
C749598
C753F58
C749144
1
0
0
C749144
0
202
06F3F412 CALLrel 074AC076
C7504D8
C749598
C753F58
A
C754270
0
Tue Jun 07 08:14:47 2011
59AFB34
06F3F10D CALLrel 06F3F322
Tue Jun 07 08:14:50 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x87C440C0] [PC:0x515CF3, ¤Ê³
Tue Jun 07 08:14:48 2011
B249F20
0
_dbktPri()+117 CALLrel _dbgtfPutStr()
B2504DC
B249FA4
3C
0
_dbktPri()+117 CALLrel _dbgtfPutStr()
D0204DC
D00D96C
3C
_ksdfmw()+318 CALLrel _dbktPri()
D00D96C
19
9
06FCE64A CALLrel 06FCCD1E
C21284C
C213690
5
A7E18D4
A7E2718
5
32
32
0
0
0
0
06E40A70 CALLrel 06FCE62A
A7E18D4
A7E2718
5
32
06E40A70 CALLrel 06FCE62A
C21284C
C213690
0
0
5
0
9
A7E2764
A7E27C4
32
0
800
0
0
06E40990 CALLrel 06E409A2
9
8F004DC
C2136DC
32
C21373C
A7E27C4
800
4
800
06E40990 CALLrel 06E409A2
9
C3204DC
06E40950 CALLrel 06E40976
8F004DC
32
32
C21373C
800
A7E27C4
4
800
7CBAF0C2
0
0
C7504D8
C753690
___dyn_tls_init_cal CALLreg 00000000
7E2F2B8
1
7CBAF0C2
0
06F3F412 CALLrel 074AC076
C5404DC
C539264
C543F5C
A
0
C544274
0
C749A3C
C749A40
9
3
0
06E407B6 CALLrel 06E4092E
8F004DC
A7E363C
06E5726A CALLrel 06E40756
8F004DC
Tue Jun 07 08:14:51 2011
0
7E2F2B8
lback()+137515896
0
___dyn_tls_init_cal CALLrel ___dyn_tls_init_cal
40171E
7E2F2B8
0
0
0
0
lback()+137515848 lback()+137515859
00000000 CALL??? 00000000
----- End of Call Stack Trace -----
3C
_ksdwrf()+16 CALLrel _ksdfmw()
1
0
599D9C0
D00E9D4
_ksdwrfns()+65 CALLrel _ksdwrf()
Tue Jun 07 08:14:52 2011
599D9C0
06F3F10D CALLrel 06F3F322
D00E9EC
C5404DC
D00E9EC
C543694
1000
1
0
C539708
782CF9C
0
D00F9EC
C53970C
06E40950 CALLrel 06E40976
]
A7E363C
A7E3014
1
8F06ED8
A7E5D5C
06E581B5 CALLrel 06E57212
8F004DC
8F06ED8
A7E363C
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_1056.trc (incident=157449):
ORA-07445: exception encountered: core dump [PC:0x515CF3] [ACCESS_VIOLATION] [ADDR:0x87C440C0] [PC:0x515CF3] [UNABLE_TO_READ] []
06E18F55 CALLrel 06E5812E
8F004DC
Tue Jun 07 08:14:54 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê³
] [0x00515CF3]
8F06ED8
1
0
8F004DC
8F06ED8
075C6050 CALLrel 06E18F2A
8F004DC
8F06ED8
0
1
0
dbkePostKGEkgsf() CALLrel _dbgePostErrorKGE()
9A213D0
8F0D2FC
258
+56
06FD092C CALLreg 00000000
9A213D0
8F0D2FC
258
06FD07A5 CALLrel 06FD0818
9A213D0
8F0D2FC
258
59AFB34
0
3
A7E6EF8
06FD0758 CALLrel 06FD0772
9A213D0
C3204DC
8F0D2FC
32
59AFB34
06E581B5 CALLrel 06E57212
AE104D8
AE16ED4
ADF47B4
258
06E18F55 CALLrel 06E5812E
0
3
A7E6EF8
06FCFE57 CALLrel 06FD0732
9A213D0
8F0D2FC
Tue Jun 07 08:14:55 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x87C440C0] [PC:0x515CF3, ¤Ê³
]
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_3988.trc (incident=157457):
ORA-07445: exception encountered: core dump [PC:0x515CF3] [ACCESS_VIOLATION] [ADDR:0x87C440C0] [PC:0x515CF3] [UNABLE_TO_READ] []
Tue Jun 07 08:14:55 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê³
] [0x00515CF3]
06F3EF65 CALLrel 06F3EFDE
C5404DC
074CAE92 CALLreg 00000000
BEC9148
782CF9C
0
C21373C
ksdfmw()+318 CALLrel dbktPri()
800
B249FA4
3
3C
0
ksdwrf()+16 CALLrel ksdfmw()
06E407B6 CALLrel 06E4092E
1
C3204DC
0
C2145B4
599D9C0
B24B00C
AE104D8
ksdwrfns()+65 CALLrel ksdwrf()
AE16ED4
599D9C0
B24B024
B24B024
1
0
AE104D8
AE16ED4
075C6050 CALLrel 06E18F2A
AE104D8
AE16ED4
0
1
59AFB34
0
3
dbkePostKGEkgsf() CALLrel _dbgePostErrorKGE()
Tue Jun 07 08:14:56 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x87C440C0] [PC:0x515CF3, ¤Ê³
]
9A60380
AF00020
258
+56
06FD092C CALLreg 00000000
9A60380
AF00020
258
06FD07A5 CALLrel 06FD0818
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_2796.trc (incident=157465):
ORA-07445: exception encountered: core dump [PC:0x515CF3] [ACCESS_VIOLATION] [ADDR:0x87C440C0] [PC:0x515CF3] [UNABLE_TO_READ] []
Tue Jun 07 08:14:56 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê³
] [0x00515CF3]
C543694
06F3EF65 CALLrel 06F3EFDE
3
CB67E70
074B4E03 CALLrel 074CAE26
0
06FD0758 CALLrel 06FD0772
D010578
D0113AC
BE9DA28
CB7D2FC
D010578
Tue Jun 07 08:14:55 2011
06E5726A CALLrel 06E40756
C3204DC
C2145B4
C213F8C
1
C326ED8
C216CD4
1000
06E581B5 CALLrel 06E57212
782CF9C
0
B24C024
074CAE92 CALLreg 00000000
9A898E0
782CF9C
0
074B4E03 CALLrel 074CAE26
0
B24C860
B24C304
B24C860
0
A7E6EF8
kslwlflux()+90 CALLrel kgeasnmierr()
9A213D0
E08
8F0D2FC
sssxcpt_EvalFilte CALLrel _skgdstpcs()
B24C850
B24C350
1
9A60380
AF00020
258
59AFB34
0
0
1
3
rEx()+3306
sssxcpt_EvalFilte CALLrel sssxcpt_EvalFilte
ADF8070
C0000005
B24E5C4
9F
06FD0758 CALLrel 06FD0772
9A60380
AF00020
59AFB34
r()+173 rEx()
258
0
3
BackgroundThreadSt CALLrel sss_xcpt_EvalFilte
C0000005
B24E5C4
9F
art@4()+761 r()
___dyn_tls_init_cal CALLptr 00000000
7E2FFC8
B24FFD4
77B0B3F5
lback()+130396404
7E2FFC8
59AFB34
7C9CF0C2
Tue Jun 07 08:14:57 2011
0
0
___dyn_tls_init_cal CALLreg 00000000
7E2FFC8
7C9CF0C2
0
0
7E2FFC8
lback()+137515896
0
C3204DC
C326ED8
C2145B4
06E18F55 CALLrel 06E5812E
C3204DC
C326ED8
1
0
C3204DC
C326ED8
075C6050 CALLrel 06E18F2A
C3204DC
C326ED8
0
1
0
59AFB34
3
2
28941EA4
2
1F60
0
2
0
__VInfreq__ksl_clea CALLrel _kslwlflux()
28941EA4
2
4
7
9A21884
nup()+363
Tue Jun 07 08:14:58 2011
A7E6F38
ksepop()+170 CALLrel ksl_cleanup()
28941EA4
2
7
2894211C
1
C5397A4
C539C24
0
06F3D484 CALLreg 00000000
C5404DC
C543694
1
2
258
0
3
CB67E70
06FCFE57 CALLrel 06FD0732
BE9DA28
CB7D2FC
59AFB34
3
___dyn_tls_init_cal CALLrel ___dyn_tls_init_cal
40171E
7E2FFC8
0
0
0
0
lback()+137515848 lback()+137515859
00000000 CALL??? 00000000
----- End of Call Stack Trace -----
dbkePostKGEkgsf() CALLrel _dbgePostErrorKGE()
BE1A388
C410020
258
+56
06FD092C CALLreg 00000000
BE1A388
C410020
258
06FD07A5 CALLrel 06FD0818
BE1A388
C410020
258
59AFB34
0
3
C217E70
06FD0758 CALLrel 06FD0772
7
BE1A388
C410020
59AFB34
9A213D0
258
0
3
06FD0B9C CALLreg 00000000
C217E70
06FCFE57 CALLrel 06FD0732
C5397A4
C539C24
0
dbktPri()+117 CALLrel dbgtfPutStr()
C5404DC
E08
06FCCA8D CALLrel 074B4DBE
D010568
CB67E70
kslwlflux()+90 CALLrel kgeasnmierr()
BE9DA28
C539CA8
CB7D2FC
3C
59AFB34
ksdfmw()+318 CALLrel dbktPri()
3
C539CA8
2
3C
ALERT LOG (THIS IS THE END OF THE FILE)
Tue Jun 07 15:52:45 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê ] [0x00515CF3]
Tue Jun 07 15:57:46 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê ] [0x00515CF3]
Tue Jun 07 16:02:45 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê ] [0x00515CF3]
Tue Jun 07 16:07:46 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê ] [0x00515CF3]
Tue Jun 07 16:12:45 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê ] [0x00515CF3]
Tue Jun 07 16:17:46 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê ] [0x00515CF3]
Tue Jun 07 16:22:45 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê ] [0x00515CF3]
Tue Jun 07 16:27:46 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê ] [0x00515CF3]
Tue Jun 07 16:32:45 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê ] [0x00515CF3]
Tue Jun 07 16:37:45 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\cdump\orclcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [¤Ê ] [0x00515CF3]
I also checked in the ORCLCORE .LOG file and found this:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
Process Id: 0x0000079c Thread Id : 0x000009f0 Time : Fri Jun 03 22:16:59
Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000
------------------- Memory Map of process ----------------
Start Addr-End Addr Type Size ModuleName
Unable to acquire mutex, skipping memory map
------------------- Registers ----------------------------
eip = 00b5aa48 esp = 0ba8ebb8 ebp = 0ba8ebf8 edi = 0be36fc0 esi = 1e7e200c
eax = ffffffc4 ebx = 0be36f50 ecx = c0e42000 edx = 00010000
ecs = 0000001b eds = 00000023 ees = 00000023 ess = 00000023
egs = 00000000 efs = 0000003b
eflags = 00010246
------------------- End of Registers ---------------------
------------------- Instruction Disassembly --------------
------------------- End of Disassembly -------------------
------------------- Call Stack Trace ---------------------
Frameptr RetAddr Param#1 Param#2 Param#3 Param#4 Function Name
0x0ba8ebf8 00b539f6 0bb022dc 00000000 08210590 10000000
0x0ba8ef50 004ed12e 0ba8f1c0 0000000c 00001004 00000000
0x0ba8f24c 004f38e1 06985a60 00000018 00000000 07ec67b0
0x0ba8f374 00540257 00000000 00000000 00000000 00000000
0x0ba8fc4c 004218f4 00000032 00000004 0ba8fe44 00000000
0x0ba8fd00 004227fa 00000032 00000004 0ba8fe44 00000000
0x0ba8fe2c 004011a0 0ba8fe54 00000032 00000004 0ba8fe44
0x0ba8fe6c 00401088 00000003 0ba8fe7c 0ba90030 0ba90048
0x0ba8fedc 00401949 00000003 0ba8ff18 c0000005 00000000
0x0ba8ff88 77751174 080c6a88 0ba8ffd4 7761b3f5 080c6a88
0x0ba8ff94 7761b3f5 080c6a88 7cc1fa8e 00000000 00000000
0x0ba8ffd4 7761b3c8 0040171e 080c6a88 00000000 00000000
0x0ba8ffec 00000000 0040171e 080c6a88 00000000 00bc614e
---------------- End of Call Stack Trace -----------------
------------------- Raw Stack Dump -----------------------
Address Dump of bytes
0BA8EBB8 30 5a 66 0b 00 00 00 00 - 00 00 00 00 30 5a 66 0b 0Zf.........0Zf.
0BA8EBC8 dc 22 b0 0b 00 00 00 00 - 00 00 00 00 30 ef a8 0b ."..........0...
0BA8EBD8 30 5a 66 0b 08 23 b0 0b - 00 00 00 00 18 0d ed 27 0Zf..#.........'
0BA8EBE8 00 00 00 00 00 00 00 00 - 00 00 00 00 60 5a 98 06 ............`Z..
PLEASE what does this mean and how do you think i can get my database back up. thank u.