-
Hi All,
I am trying to send an email notification when Database shutdown or startup using UTL_SMTP package in Database Event triggers. But I am getting the below errors:
ORA-29540: class oracle/plsql/net/TCPConnection does not exist
ORA-06512: at "SYS.UTL_TCP", line 537
ORA-06512: at "SYS.UTL_TCP", line 199
ORA-06512: at "SYS.UTL_SMTP", line 102
ORA-06512: at "SYS.UTL_SMTP", line 121
My Oracle version is 8.1.7
OS - Sun Solaris
JServer is installed in Oracle - version 8.1.7
I tried to re-install JVM provided by Oracle, but it is giving me error that it cannot resolve the class path SYS.oracle\aurora\rdbms\.....
Can anyone suggest the solution!!
Thanks in advance
________________
ShanDJ
-
Can u post ur trigger?
Tnx.
èDó
=======================
Manifest plainness,
embrace simplicity,
reduce selfishness,
have few desires. LAO TZU
=======================
-
Hi,
The initjvm.sql script (located in the ORACLE_HOME/javavm/install directory)
is run automatically during normal installation of the database, except during custom installation. In any event, the script can be run manually (as SYS) at a later time. When this script is run, approximately 8000+ java classes are loaded into the database.
Unfortunately, there is another script, initplsj.sql (located in ORACLE_HOME/rdbms/admin) which is supposed to be called by the initjvm.sql script. This does not occur. To fix the problem, run the initplsj.sql script (as SYS). You will note that 200+ classes get loaded into the database as a result of this script. This should then allow you to use the
UTL_SMTP and UTL_TCP packages.
This script also needs to be run:
$ORACLE_HOME/javavm/install/init_security.sql
Regards,
Rohit Nirkhe.Oracle/APPS DBA,OCP 8i
oracle-support@indiatimes.com
-
Hi
This link has a description and solution to your problem
http://home.clara.net/dwotton/dba/oracle_smtp.htm
Hope it helps
Cheerio
Afshin
-
Originally posted by shandj
I tried to re-install JVM provided by Oracle, but it is giving me error that it cannot resolve the class path SYS.oracle\aurora\rdbms\.....
Important: first remove JVM and install it again. I've tried reinstallements with the same rate of success as you :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
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
|