DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Send an email notification when Database down/startup

  1. #1
    Join Date
    Feb 2002
    Posts
    70
    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

  2. #2
    Join Date
    Feb 2002
    Posts
    54
    Can u post ur trigger?

    Tnx.

    èDó
    =======================
    Manifest plainness,
    embrace simplicity,
    reduce selfishness,
    have few desires. LAO TZU
    =======================

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  4. #4
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    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


  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
  •  


Click Here to Expand Forum to Full Width