ORA-07445 and ORA-03113: end-of-file on communication channel in oracle 10g
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: ORA-07445 and ORA-03113: end-of-file on communication channel in oracle 10g

Hybrid View

  1. #1
    Join Date
    Nov 2005
    Posts
    11

    Thumbs up ORA-07445 and ORA-03113: end-of-file on communication channel in oracle 10g

    Hi DBAs,

    I required you expertise here....

    I am facing below problem in oracle 10g on linux.

    After enabling the JAVA in the database, when I try to export the database, I am getting the below error:

    ORA-03113: end-of-file on communication channel[FONT=Verdana][SIZE=1]

    This error also comming when I run the utlrp.sql to validate objects.
    I checked the alert log file and trace files, and I found the below error....

    ORA-07445: exception encountered: core dump [joe_well_known_internal()+102] [SIGSEGV] [Address not
    mapped to object] [0x1FA7C878] [] []

    I gone through the various posts and I found some body saying classpath issue or incomplete installation of java.

    I taken care of both the above issue. I have properly set the classpath in profile file and reinstalled the java two times. But this didn't help me....

    Can any body give there valuable openion on this issue......

    Your help will be greatly appreciated......

    Thanks

    Asharam

  2. #2
    Join Date
    Apr 2003
    Posts
    353
    Have you applied all os level pathces?
    What is your os version

  3. #3
    Join Date
    Nov 2005
    Posts
    11
    Below is "uname -a" output
    All the patches required by the oracle has been applied already.


    #uname -a

    Linux 2.4.21-27.ELsmp #1 SMP Wed Dec 1 21:59:02 EST 2004 i686 i686 i386 GNU/Linux

    its a RedHat Linux 3

  4. #4
    Join Date
    Apr 2003
    Posts
    353
    After java reinstallation, have you relinked oracle?
    Check your oracle installation log for any errors.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Quote Originally Posted by engiri
    After java reinstallation, have you relinked oracle?
    Check your oracle installation log for any errors.
    why you need to relink the software??!!

  6. #6
    Join Date
    Apr 2003
    Posts
    353
    """Address not
    mapped to object"""

    This error should have been reported already at the time of installation.
    Relinking will report again this error..? Java has been reinstalled. It is a good practice to relink at this juncture as we have been adviced.

  7. #7
    Join Date
    Nov 2005
    Posts
    11
    Anyhow to take a chance I am relinking the Oracle S/w........

    And time of Enabling the JVM This error was not reported.

    I am little doubt here......

    I have enabled the JVM (which i mean enabling java in database) in oracle database. Why Should I reliank oracle Software.

    and I will elaborate problems little more:

    When I will restart the database and then run the utlrp and export backup. For the first time it goes fine. But the if I re-run the same again... it will start giving the above mentioned errors. This will then Continue till I restart the database again......

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you can ignore the joe_well_known_internal error.

    Does your export actually stop ?

    And relinking totally isnt necessary as the binaries arent running

  9. #9
    Join Date
    Nov 2005
    Posts
    11
    Yes ...

    Below is the Full database export error log:

    Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
    With the Partitioning, OLAP and Data Mining options
    Export done in US7ASCII character set and AL16UTF16 NCHAR character set
    server uses AL32UTF8 character set (possible charset conversion)

    About to export the entire database ...
    . exporting tablespace definitions
    . exporting profiles
    . exporting user definitions
    . exporting roles
    . exporting resource costs
    . exporting rollback segment definitions
    . exporting database links
    . exporting sequence numbers
    . exporting directory aliases
    . exporting context namespaces
    . exporting foreign function library names
    . exporting PUBLIC type synonyms
    EXP-00008: ORACLE error 3113 encountered
    ORA-03113: end-of-file on communication channel
    EXP-00000: Export terminated unsuccessfully

    in In alert log, it reports ORA-7445 ...............

  10. #10
    Join Date
    Nov 2005
    Posts
    11
    Hi All,

    it would be great if any one can suggest some Solution .......

    Thank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width