-
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
-
Have you applied all os level pathces?
What is your os version
-
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
-
After java reinstallation, have you relinked oracle?
Check your oracle installation log for any errors.
-
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??!!
-
"""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.
-
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......
-
you can ignore the joe_well_known_internal error.
Does your export actually stop ?
And relinking totally isnt necessary as the binaries arent running
-
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 ...............
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|