IdentifiantMot de passe
Loading...
Mot de passe oublié ?Je m'inscris ! (gratuit)
Navigation

Inscrivez-vous gratuitement
pour pouvoir participer, suivre les réponses en temps réel, voter pour les messages, poser vos propres questions et recevoir la newsletter

Oracle Discussion :

ora-3113 et ora-3114


Sujet :

Oracle

Vue hybride

Message précédent Message précédent   Message suivant Message suivant
  1. #1
    Membre à l'essai
    Profil pro
    Inscrit en
    Septembre 2006
    Messages
    5
    Détails du profil
    Informations personnelles :
    Localisation : France

    Informations forums :
    Inscription : Septembre 2006
    Messages : 5
    Par défaut ora-3113 et ora-3114
    à la fin d'un import on obtient l'erreur suivante :

    ora-3113 end of file on communication channel
    ora-3114

    PKOI ???

    Help!!!!!!

  2. #2
    Membre Expert
    Avatar de bouyao
    Inscrit en
    Janvier 2005
    Messages
    1 778
    Détails du profil
    Informations forums :
    Inscription : Janvier 2005
    Messages : 1 778
    Par défaut
    Version Oracle et OS ?
    plus de precision sur l'erreur

    par exemple
    Oracle : 9.2.0.7
    OS : TRU64

    Error stack from the Core file shows :- kwruipn kwrupnm kwriipg kwrigrs spefcmpa spefmccallstd
    pextproc peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrrun peicnt kkxexe
    opiexe opiosq0 opiosq opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai
    OracleThreadStart@4


    1. Imp.log shows errors below:
    IMP-00017: following statement failed with ORACLE error 3113
    "BEGIN "
    "SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"
    "N_CONTEXT_OBJ, 'SYS',TRUE);"

  3. #3
    Membre à l'essai
    Profil pro
    Inscrit en
    Septembre 2006
    Messages
    5
    Détails du profil
    Informations personnelles :
    Localisation : France

    Informations forums :
    Inscription : Septembre 2006
    Messages : 5
    Par défaut ora3113 ora3114
    Voici une partie du fichier trace

    Dump file /commun/oracle/product/9.2.0/admin/IAC2/udump/iac2_ora_13962.trc
    Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.4.0 - Production
    ORACLE_HOME = /commun/oracle/product/9.2.0
    System name: HP-UX
    Node name: samson
    Release: B.11.11
    Version: U
    Machine: 9000/800
    Instance name: IAC2
    Redo thread mounted by this instance: 1
    Oracle process number: 9
    Unix process pid: 13962, image: oracle@samson (TNS V1-V3)

    *** 2006-10-17 14:48:12.544
    *** SESSION ID8.19) 2006-10-17 14:48:12.494
    Exception signal: 11 (SIGSEGV), code: 0 (unknown code), addr: 0x800003fa40100000, PC: [0x4000000001585590, ph2opf_patter
    n_formals()+1408]
    Registers:
    r1: 800003fa400cfd30 r22: 800003fa400bca70 sr4: 96ed800
    rp: 800003fa400ffc50 arg3: 75 sr0: 8cc1400
    r3: 800003fa000b4c80 arg2: 9 sr1: 33d7400
    r4: 106c4 arg1: 48 sr2: 0
    r5: 2 arg0: 800003fa400ffff8 sr3: 0
    r6: 75 dp: 8000000100112638 sr5: 3897400
    r7: 76 ret0: 3d sr6: 231a400
    r8: 1 ret1: 800003ffc0000c70 sr7: 8cc1400
    r9: 8000000100120358 sp: 800003ffc0000ca0 cr0: 0
    r10: 0 r31: 8000000100089360 cr8: 1de8368
    r11: 75 sar: 3d cr9: 1de8378
    r12: 800003fa400cfce8 pcoqh: 4000000001585593 ccr: 0
    r13: 75 pcsqh: 3897400 cr12: 0
    r14: 9 pcoqt: 4000000001585597 cr13: 100000000
    r15: 800003fa400ce608 pcsqt: 3897400 cr24: 1de8130
    r16: 800003fa400ca970 eiem: ffffffffffffffff cr25: 0
    r17: 800003fa400ca5a8 iir: f403350 cr26: b25360
    r18: 800003fa400cad58 isr: 231a400 mpsfu_hi: 800000010012e0b0
    r19: c00000010ac26748 ior: 800003fa40100000 mpsfu_lo: b25368
    r20: 9 ipsw: ff0804ff1f mpsfu_ov: 41
    r21: 9 goto: 97464 pad: 0
    *** 2006-10-17 14:48:12.658
    ksedmp: internal or fatal error
    ORA-07445: exception encountered: core dump [ph2opf_pattern_formals()+1408] [SIGSEGV] [unknown code] [0x800003FA40100000
    ] [] []
    Current SQL statement for this session:
    ALTER FUNCTION "PSSACAPDAI" COMPILE REUSE SETTINGS TIMESTAMP '2005-03-27:09:33:56'
    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- -------------------- ----------------------------
    ksedmp()+184 ? ksedst() 000000075 ?
    800003FFC0000D00 ?
    2D8173B3D9A4D8 ?
    8000000100112638 ?
    ssexhd()+636 ? ksedmp() 000000000 ? 00000010F ?
    40000000014D64CB ?
    800003FFBFFFAEA8 ?
    _sigreturn()+0 ? ssexhd() 000000000 ? 000000000 ?
    00F403350 ?
    800003FFC0000CA0 ?
    ph2opf_pattern_form ? _sigreturn() 080000167 ? 000000081 ?
    als()+1408 800003FA000B4C80 ?
    800003FA400CA010 ?
    ph2ovx()+3060 ? ph2opf_pattern_form 0800017BB ?
    als() 800003FA400CA010 ?
    800003FFBFFFAEA8 ?
    800003FA400CA990 ?
    ph2ovv()+912 ? ph2ovx() 40000000014D1EA7 ?
    800003FFC000011A ?
    800003FA400CA990 ?
    8000000100120358 ?
    ph2orc()+1644 ? ph2ovv() 800000010008B9B8 ?
    000000000 ?
    800003FFBFFFAEA8 ?
    000000000 ?

  4. #4
    Membre chevronné

    Profil pro
    Inscrit en
    Juin 2004
    Messages
    487
    Détails du profil
    Informations personnelles :
    Localisation : France

    Informations forums :
    Inscription : Juin 2004
    Messages : 487
    Par défaut
    Voici la réponse de metalink:
    Code : Sélectionner tout - Visualiser dans une fenêtre à part
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    143
    144
    145
    146
    147
    148
    149
    150
    151
     
    Subject: 	ALERT: ORA-7445 Signalled from Different Functions on 64-bit HP-UX
      	Doc ID: 	Note:241160.1 	Type: 	ALERT
      	Last Revision Date: 	25-OCT-2005 	Status: 	PUBLISHED
     
     
    ALERT: ORA-7445 Signalled from Different Functions on 64-bit HP-UX
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     
    Versions Affected 
    ~~~~~~~~~~~~~~~~~ 
      Oracle RDBMS 9i release 2
     
     
    Platforms Affected 
    ~~~~~~~~~~~~~~~~~~ 
      64-bit HP-UX version B.11.00 or HP-UX B.11.11.
     
     
    Description 
    ~~~~~~~~~~~ 
      Errors may be found in the alert.log signalling an ORA-7445 in one of the 
      functions listed in the 'Symptoms' section below. It is possible that the
      instance may crash with these errors.
     
      This is a problem related to the HP compiler.
     
     
    Likelihood of Occurrence 
    ~~~~~~~~~~~~~~~~~~~~~~~~ 
      The likelihood of hitting this problem is high if you are using Oracle RDBMS
      version 9i release 2 on 64-bit HP-UX. The problem is resolved in Oracle RDBMS
      version 9.2.0.5, which was built using the fixed compiler.
     
     
    Possible Symptoms 
    ~~~~~~~~~~~~~~~~~ 
      The symptoms are core dumps in various functions. The following
      errors have been reported to date:
     
        ORA-7445: [kkobrak]
        ORA-7445: [kkofmx]
        ORA-7445: [kkeics]
        ORA-7445: [kkeits]
        ORA-7445: [qctstin]
        ORA-7445: [kdxd4ckf]
        ORA-7445: [pdtmsc]
        ORA-7445: [kxccsrw]
        ORA-7445: [kxfqopn]
        ORA-7445: [kkshlcu]
        ORA-7445: [updini]
        ORA-7445: [delexe]
        ORA-7445: [qksopcopyinlist]
        ORA-7445: [kprcrm0]
        ORA-7445: [ktbgcl1]
        ORA-7445: [kokacpc]
        ORA-7445: [kkwpovld]
        ORA-7445: [knpcdp2_ClearStats]
        ORA-7445: [ldxstdnew]
        ORA-7445: [koudcon]
        ORA-7445: [kxfrgradistalo]
        ORA-7445: [kudmpax]
        ORA-7445: [ldxeti]
        ORA-7445: [prsfsp]
        ORA-7445: [horsham_hoadaddmapping]
        ORA-7445: [ph2opf_pattern_formals]
        ORA-7445: [kokqoxinit]
        ORA-7445: [kxfpqrgeb]
     
      While the above errors are the most common, it is possible that the problem 
      will occur in other modules as well. Please contact Oracle Support Services
      if you believe that you are encountering this problem in a module other 
      than those listed.
     
     
    To identify whether an ORA-7445 might be a manifestation of this problem do:
     
         1. log onto an HP-UX 64bit machine.
         2. select a 9.2 instance
         3. cd $ORACLE_HOME/bin
         4. gdb oracle
         5. Take the argument to the ORA-7445, eg: kkeits and do:
            	gdb>disassemble kkeits
         6. Scroll through the output until you reach the offset indicated in the
                    argument. In this case it was ORA-7445 [kkeits+228]
     
       		Offset 228 shows:
     
    	      0x40000000018564c4 <kkeits+228>:        stdby,e %r0,1(%r26)
     
      If the line shows stdby (set double-byte), in versions up to and including 9.2.0.4, as 
      it does above then there is a strong possibility that this is an example of the compiler 
      problem. Please contact support who will log the problem with development.
     
      If you encounter an ORA-7445 in 9.2.0.5 onwards and a disassemble of the failing 
      function shows stdby this does not indicate a reoccurrence of this problem.
     
    Patches
    ~~~~~~~
      One-off patches have been created for 9.2.0.2, 9.2.0.3 and 9.2.0.4. The 
      affected Oracle code modules have been rebuilt to workaround the compiler 
      problem in 9.2.0.2 and 9.2.0.3. The patch for 9.2.0.4 has been rebuilt 
      using a fix to the HP-UX compiler. The patches address errors in 
      different functions so please read the information below to determine 
      which patch to apply. 
     
      9.2.0.4
      -------
      If you are seeing the errors signalled in kkeits, kkeics, updini, delexe, 
      qksopcopyinlist, kprcrm0, ktbgcl1, kokacpc, ldxstdnew, ldxeti, kkxpovld, koudcon,
      horsham_hoadadmapping, kxfrgradistalo, kudmpax, prsfsp, knpcdp2_ClearStats, kokqoxinit,
      ph2opf_pattern_formals or kxfpqrget then please download Patch 3065127 for 9.2.0.4.
     
      9.2.0.3
      -------
      If you are seeing the errors signalled in functions kdxd4ckf, qctstin, 
      pdtmsc, kkofmx, kkobrak, kkeits, kkeics, kxccsrw, kxfqopn, 
      kkshlcu, updini, delexe, qksopcopyinlist, ktbgcl1 or knpcdp2_ClearStats 
      then please download Patch 3065127 for 9.2.0.3. This incorporates the 
      modules included in the 9.2.0.3 version of 2925233. The fixes for 
      functions kdxd4ckf, qctstin, pdtmsc, kkofmx, kkobrak, kxccsrw, kxfqopn 
      and kkshlcu are also incorporated into patch set release 9.2.0.4.
     
      9.2.0.2
      -------
      If you are seeing the errors signalled in functions
      kdxd4ckf, qctstin or pdtmsc then please download Patch 2925233.
     
      Any future fixes will be on top of patch set release 9.2.0.4.
     
     
    Modification History
    ~~~~~~~~~~~~~~~~~~~~
     
      2003-12-22  Updated possible symptoms and patches section to include latest
                  fixes (ph2opf_pattern_formals, kokqoxinit)
      2003-12-10  Updated possible symptoms and patches section to include latest
                  fixes (koudcon, horsham_hoadaddmapping, kxfrgradistalo, kudmpax,
                  prsfsp, kkxpovld)
      2003-11-12  Updated patches section to include details of compiler fix and
    		  add ldxeti to list of possible arguments for 9.2.0.4
      2003-08-22  Updated to clarify the issue is fixed in 9.2.0.4
      2003-09-23  Updated to include errors encountered in 9.2.0.4 and details
                  of the patches to apply.
      2003-09-29  Updated to include new modules in latest version of
                  9.2.0.3 patch and to reflect revised 9.2.0.4 patch.
      2003-10-07  Updated to include modules ldxstdnew and knpcdp2_ClearStats
                  in 9.2.0.4 patch and knpcdp2_ClearStats in 9.2.0.3.
      2004-03-26  Updated to include module kxfpqrget and information on 9.2.0.5.
     
    KEYWORDS: ALERTINFO COREDUMP HP

  5. #5
    Membre Expert
    Avatar de bouyao
    Inscrit en
    Janvier 2005
    Messages
    1 778
    Détails du profil
    Informations forums :
    Inscription : Janvier 2005
    Messages : 1 778
    Par défaut
    C'est possible que ca vient d'un BUG. Le mieu est de patcher en 9.2.0.5
    pour être sûre :
    Code : Sélectionner tout - Visualiser dans une fenêtre à part
    1
    2
    3
     
    cd $ORACLE_HOME/bin
    gdb oracle
    C'est quoi l'argument de ORA-7445 ?

  6. #6
    Membre à l'essai
    Profil pro
    Inscrit en
    Septembre 2006
    Messages
    5
    Détails du profil
    Informations personnelles :
    Localisation : France

    Informations forums :
    Inscription : Septembre 2006
    Messages : 5
    Par défaut ora3113 ora3114
    Merci pour toutes vos réponses
    Nous allons tester l'import avec une version 9.2.0.7

Discussions similaires

  1. [Oracle 9i] Erreur de connexion : ORA-01157 et ORA-01033
    Par Elise78 dans le forum Connexions aux bases de données
    Réponses: 11
    Dernier message: 29/06/2011, 14h22
  2. ORA-3113 et 3114
    Par pascal47 dans le forum Administration
    Réponses: 1
    Dernier message: 27/07/2007, 11h06
  3. [ORA-03113]Erreur ORA-03113
    Par nkongolo.m dans le forum Oracle
    Réponses: 3
    Dernier message: 23/03/2006, 10h03
  4. Erreurs : ORA 01017 et ORA 02063
    Par claralavraie dans le forum Oracle
    Réponses: 2
    Dernier message: 06/01/2006, 11h10
  5. ORA 17410 et ORA 03113
    Par bchaz dans le forum Oracle
    Réponses: 4
    Dernier message: 28/10/2005, 17h06

Partager

Partager
  • Envoyer la discussion sur Viadeo
  • Envoyer la discussion sur Twitter
  • Envoyer la discussion sur Google
  • Envoyer la discussion sur Facebook
  • Envoyer la discussion sur Digg
  • Envoyer la discussion sur Delicious
  • Envoyer la discussion sur MySpace
  • Envoyer la discussion sur Yahoo