7 Replies Latest reply on Jun 8, 2011 9:44 AM by Thierry H.

    TNS:PROTOCOL ADAPTER ERROR

    user13633999
      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.
        • 1. Re: TNS:PROTOCOL ADAPTER ERROR
          BPeaslandDBA
          What OS version?

          In your DOS window, set your ORACLE_SID and ORACLE_HOME env vars before starting SQL*Plus:

          set ORACLE_SID=orcl (or whatever your db name is)
          set ORACLE_HOME=c:\oracle\product\11.1.0 (or whatever the path is)

          Then try again.

          HTH,
          Brian
          • 2. Re: TNS:PROTOCOL ADAPTER ERROR
            Antonio Navarro
            Maybe time to open SR

            HTH
            Antonio NAVARRO
            • 3. Re: TNS:PROTOCOL ADAPTER ERROR
              EdStevens
              user13633999 wrote:
              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]
              the ora-07445 is probably not related to your ora-12560, but a 7445 is much like an ora-0600 -- you'll need a service agreement giving you access to My Oracle Support, where there is an ora-0600/ora-07445 lookup tool, and access to open a service request.

              The ora-12560 is most commonly caused by not setting ORACLE_HOME and ORACLE_SID.
              <snip>
              • 4. Re: TNS:PROTOCOL ADAPTER ERROR
                user13633999
                thanks for ur responses but i set the oracle_home and oracle_sid and tried it again but nothing changed. the oracle is installed on windows 7 altimate. and please what do you mean by "open SR".
                • 5. Re: TNS:PROTOCOL ADAPTER ERROR
                  Shivananda Rao
                  Please check whether the oracle database service OracleService<SID> is started or not in the services. (services.msc)
                  You may get TNS 12560 if the service is not started. Start the service and try connecting to your database.

                  Regards,
                  srp
                  • 6. Re: TNS:PROTOCOL ADAPTER ERROR
                    user13633999
                    the service oracleServiceORCL is started . i still restarted it and no change. please help
                    • 7. Re: TNS:PROTOCOL ADAPTER ERROR
                      Thierry H.
                      Hi,

                      Just a remark....
                      but i set the oracle_home and oracle_sid
                      you need to set ORACLE_HOME and ORACLE_SID .... in upper case.

                      And is your machine connected to any network? ... i mean, do you have a network adapter 'online' ?
                      If not, then connect to whatever netwok you can find, and try to restart your Windows service.

                      HTH,
                      Thierry