Enabling Java in Oracle 8.1.7 – ORA-29540

0 pts.
Tags:
Oracle
Windows
I got the error below while trying to UTL_SMTP package to send e-mail: ORA-29540: class oracle/plsql/net/TCPConnection does not exist Apparently my Oracle 8.1.7. db is missing some Java classes. Can someone tell me how to enable Java in 8.1.7?
ASKED: September 23, 2005  8:55 AM
UPDATED: September 26, 2005  5:36 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I had the exact same problem.
What version of 8.1.7 do you have? The problem may be that the plsql.jar file, provided in the 8.1.7.1 patchset,
contains an invalid TCPConnection class. The invalid class was fixed in 8.1.7.2. This does not automatically get loaded back into the database when doing an upgrade. You will need to do the following to reload the class
call dbms_java.loadjava(‘-resolve -force plsql/jlib/plsql.jar’);
Then you need to reload the tcp and smtp modules as follows
@?/rdbms/admin/utltcp.sql
@?/rdbms/admin/prvttcp.plb
@?/rdbms/admin/utlsmtp.sql
@?/rdbms/admin/prvtsmtp.plb
This needs to be done as SYSDBA on the machine local to the database using the correct 8.1.7 Oracle Home.
HTH
Luke

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Oadegoke
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/enabling-java-in-oracle-817-ora-29540/ (0) Comments Read [...]
    0 pointsBadges:
    report
  • Oadegoke
    [...] Original Address: http://itknowledgeexchange.techtarget.com/itanswers/enabling-java-in-oracle-817-ora-29540/ [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following