Thanx it solved our developers problem

Doing what is written:
cd plsql/jlib
loadjava -user sys/password plsql.jar

This command is giving me
ORA-00406 error- COMPATIBLE parameter needs to be 8.1.0.0.0. or greater.

I am having 8.1.6.0.0 on my machine

Please advice

I tried to load java and got the following errors

Error while retrieving errors for oracle/plsql/net/TCPConnection
ORA-00904: invalid column name

Error while retrieving errors for oracle/plsql/net/InternetAddress
ORA-00904: invalid column name

Error while creating resource META-INF/MANIFEST.MF
ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler

loadjava: 3 errors

thanks,

I am Getting this error

any thing is wrong?

[GIB_UAT7-8.1.7] {oracle} : loadjava -f -v -r -u sys/eric plsql.jar
Unable to initialize threads: cannot find class java/lang/Thread
Could not create Java VM

Thx
Ashok

loadjava
Unable to initialize threads: cannot find class java/lang/Thread
Could not create Java VM


Pls Advice

Thx for Quick Response

I checked the class path

This is what i did

set env classpath /etc/..../lib/
(Setting the classpath for classes111.zip file

I tried ECHO $classpath i was able to see the classpath

But still i am getting this error

Pls Advice

Thx
Ashok

Thx for ur Quick Response

Yes rt.jar exist.

Checked the loadjava script and we found that path for .jar files & classes111.zip files are wrong,so changed to correct path

But now we r Getting a different Error Msg:

Version not compatibale with the Java Version in system classes check ur Classpath

Pls Advice

Ashok

Hi Tom,

Running the load java i got the following errors.....
the log file is below:

Please advice


ORA-04030: out of process memory when trying to allocate 554648 bytes (joxcx callheap,ioc_allocate ufree)
ORA-04030: out of process memory when trying to allocate 65036 bytes (callheap,KQL tmpbuf)
COUNT(*)
----------
6600
1 row selected.
Statement processed.
JVMRMACTION
------------
FULL_REMOVAL
Statement processed.
DBMS_JAVA.LONGNAME(NAME)
--------------------------------------------------------------------------------
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","oracle/aurora/rdbms/DbmsJavaSYS","joxlod: in ehe","ioc_allocate_pal")
DBMS_JAVA.LONGNAME(O.NAME) TEXT
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","oracle/aurora/rdbms/DbmsJavaSYS","joxlod: in ehe","ioc_allocate_pal")
Statement processed.
Statement processed.
drop public synonym get_error$
*
ORA-01432: public synonym to be dropped does not exist
Statement processed.
Statement processed.
Statement processed.
JVMRMACTION
------------
FULL_REMOVAL
Statement processed.
Statement processed.
Statement processed.
Statement processed.
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","java/lang/ObjectSYS","joxlod: in ehe","ioc_allocate_pal")
Statement processed.
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","java/lang/ObjectSYS","joxlod: in ehe","ioc_allocate_pal")
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","java/lang/ObjectSYS","joxlod: in ehe","ioc_allocate_pal")
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","java/lang/ObjectSYS","joxlod: in ehe","ioc_allocate_pal")
------------
FULL_REMOVAL
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
drop table aurora$startup$classes$
*
ORA-00942: table or view does not exist
drop table aurora$shutdown$classes$
*
ORA-00942: table or view does not exist
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
JVMRMACTION
------------
FULL_REMOVAL
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
JVMRMACTION
------------
FULL_REMOVAL
Statement processed.
Statement processed.
Statement processed.
JVMRMACTION
------------
FULL_REMOVAL
Statement processed.
Statement processed.
JVMRMACTION
------------
FULL_REMOVAL
Statement processed.
JVMRMACTION
------------
FULL_REMOVAL
Statement processed.
ORA-04021: timeout occurred while waiting to lock object SYS.INITJVMAUX
ORA-06512: at line 4

Hi Tom,

I was facing the problem in one of our development servers, for a long time. By loading the plsql.jar file, my mail procedure started working fine.

Thanks,
krishna

tom,
i want to use utl_smtp, but i am also getting the same error. only our dba can run that loadjava command given below.

where exactely is this directory present?

>>Simply:

>>cd plsql/jlib
>>loadjava -user sys/password plsql.jar

and, how do we ensure java server stuff is installed or not?

my oracel version is 8.1.6

this is what appears when i log in

Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
With the Partitioning option
JServer Release 8.1.6.3.0 - Production


now is that enough if i run that
"loadjava" command or anything else i have to do?

Hope that Mr. Tom has much more patience to respond all type of questions. The questioner can try out the problem with all posibilites themselves before raising questions. So that Tom becomes cool ;-).

when I was executing

loadjava -user sys/pass plsql.jar I faced following error

Error while computing shortname of oracle/plsql/net/TCPConnection
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DBMS_JAVA.SHORTNAME' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Error while computing shortname of oracle/plsql/net/InternetAddress
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DBMS_JAVA.SHORTNAME' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Error while creating resource META-INF/MANIFEST.MF
ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler

loadjava: 3 errors

What could be the reason

Pervious error which I mentioned was due to dbms_java. This Package was not installed in my DB. After installing when I used following code for sending mail

create or replace
PROCEDURE send_mail (p_sender IN VARCHAR2,
p_recipient IN VARCHAR2,
p_message IN VARCHAR2)
as
l_mailhost VARCHAR2(255) := 'aa.bb.com';
l_mail_conn utl_smtp.connection;
BEGIN
l_mail_conn := utl_smtp.open_connection(l_mailhost, 25);
utl_smtp.helo(l_mail_conn, l_mailhost);
utl_smtp.mail(l_mail_conn, p_sender);
utl_smtp.rcpt(l_mail_conn, p_recipient);
utl_smtp.open_data(l_mail_conn );
utl_smtp.write_data(l_mail_conn, p_message);
utl_smtp.close_data(l_mail_conn );
utl_smtp.quit(l_mail_conn);
end;
/


begin
send_mail( 'yogeshb@bb.com', 'matty@bb.com', 'Test mail from DB' );
end;
/

Mail was sent, but mail was not having any info like, from /to as well text.

From : Sender Unspecified
To :none
subject : (No subject)

Why this is so ?

Thanks a lot Tom, got solution. Sorry for trouble.

tom,
after running "loadjava -user sys/password plsql.jar"
I get:
/export/vol/oracle.8.1.6/product/dbms/8.1.6/bin/loadjava[16]: /app/oracle/product/dbms/8.1.6/JRE/bin/jre: not found

please help

Thanks a million, Tom, for all I have gleaned from this site.

I need some assistance with what you wrote above:
"loadjava -user sys/password plsql.jar"

I tried that and I get the error:
"SQL error while connecting with oci8 driver to default database: ORA 12560: TNS: Protocol adapter error
could not open error
loadjava: 2 errors"

I am a developer and not a DBA so I have limited access to the database. What am I missing here?

Thanks,

Leora

Hi Tom,
I'm using Oracle 8.1.7 (Windows NT 4.0). I did:
cd plsql/jlib
loadjava -user sys/password plsql.jar

withou problem.
The script send_mail was compiled without errors

create or replace procedure send_mail ( p_sender in varchar2, p_recipient in varchar2, p_message in varchar2 ) as
l_mailhost varchar2(255) := '40.10.1.18' ;
l_mail_conn utl_smtp.connection ;
begin
l_mail_conn := utl_smtp.open_connection(l_mailhost, 25) ;
utl_smtp.helo(l_mail_conn, l_mailhost) ;
utl_smtp.mail(l_mail_conn, p_sender) ;
utl_smtp.rcpt(l_mail_conn, p_recipient ) ;
utl_smtp.open_data(l_mail_conn) ;
utl_smtp.write_data(l_mail_conn, p_message ) ;
utl_smtp.close_data(l_mail_conn) ;
utl_smtp.quit(l_mail_conn );
dbms_output.put_line('Message send to the user successfully') ;
end ;

However, when I execute send_mail, it returns:
ORA-29541: class SYS.oracle/plsql/net/TCPConnection could not be resolved
ORA-06512: at "SYS.UTL_TCP", line 537
ORA-06512: at "SYS.UTL_TCP", line 199
ORA-06512: at "SYS.UTL_SMTP", line 99
ORA-06512: at "SYS.UTL_SMTP", line 121
ORA-06512: at "SYS.SEND_MAIL", line 6
ORA-06512: at line 2

Please help!!

I found a TAR on MetaLink that suggests loading as:

loadjava -resolve -force -user sys/password $ORACLE_HOME/plsql/jlib/plsql.jar

HTH,

Mark

Tom,
thanks for your quick response!!
My server machine has various Oracle version(8.1.5, 8.1.7, 9i-rel2).
V.8.1.7 isn't a upgrade (it is a new installation), and on this version I am working:
I executed loadjava -user sys/pwd plsql.jar and I've got error Ora-00406 .Then I modified init.ora, compatible= 8.1.7 (it was 8.0.5).

I tried loadjava -resolve -force -user sys/password $ORACLE_HOME/plsql/jlib/plsql.jar (thanks Mark) but the problem persists (executing send_mail(), I've got the error ORA-29541: class SYS.oracle/plsql/net/TCPConnection could not be resolved)

Obs: I execute send_mail() in Oracle 9i and got success

Thanks !!

> compatible= 8.1.7 (it was 8.0.5)

From the readme.txt file in the javavm directory:


1.5 Compatibility Mode

To use Java in the Oracle8i server, you must set

compatibility = 8.1.0

or higher.


I have not used this package, but if compatible must be 8.1.0 or higher and yours was set to 8.0.5 when the javavm was installed, I would suggest reloading the javavm now that compatible is set correctly.

HTH,

Mark

Unfortunately utl_smtp even if working 99% of the time on 9.2 quite often hangs without generating any error. Just indefinitely active session. Terrible thing to have, I believe such “not rugged “ behavior make oracle marketing talk about java virtual machine less and less.

So far I have found that such session are not “killable”. The only solution is to recycle database via shutdown abort. Any suggestions on how to kill session involving java hang up are greatly appreciated

Tom,
Where can I find the plsql.jar file to be loaded using loadjava,
I can't find the jlib directory under pl/sql; and I can't find the plsql.jar under jlib.

Thanks,

Sorry, I didn't mention that we have Oracle9.2.0.5 (Solaris 5.8)

Ho Tom,

I am encountering the following error.
 
ORA-04031: unable to allocate 8196 bytes of shared memory ("large pool","unknown object","hash-join subh","QERHJ list array")

What does the error really mean?
 
Problem is with the shared pool or the large pool?

I tried the following but to no help...

SQL> alter system flush shared_pool;

Is there any quick fix to it without bouncing the Instance?
 

Yes we are using shared server connections.

Thanks for the very good informations. Kindly help me use utl_smtp.vrfy function

Tom,

All the answer about loading this jar files seems to be for UNIX/SOLARIS environment. Mine in Windows environment then where do I find this file and how to load this.

Please help..

Hi Tom,
We are using standard package CES.email_files to send emails with attachments.
CES.email_files(from_name => lc_from_email_id
,to_names => l_email_id
,subject => lc_subject
,message => lc_message
,cc_names => lc_cc_email_id
,filename1 => lc_directory||'/'||l_file_name
);
It is working fine if all the emails are correct. Lets say we have 5 email recepients
1) abc@gmail.com
2) xyz@yahoo.com
3) pqr@@gmai.com
4) mnq@hotmail.com
5) srt@yahoo.com
The third email recepient has 2 @ in the id which is invalid, so the program send mails to the first 2 and ignoring the rest. How do we skip the third email and continue sending to the rest of the recepients.

Thanks in advance

Hi Tom,

Quite not sure if this is a silly question.My oracle version is 8.1.7.4 and we have an web application. when i try to access the web page it is throwing
"ORA-29540: class oracle/plsql/net/InternetAddress does not exist ORA-06512: at "SYS.UTL_INADDR", line 21 ORA-06512: at "SYS.UTL_INADDR", line 21 ORA-06512: at line 1"

I tried
cd plsql/jlib
loadjava -user sys/password plsql.jar

but it is giving pirm/u01/app/oracle/product/8.1.7/bin/loadjava[16]: /u01/app/oracle/product/8.1.7/JRE/bin/jre: not found

can you please help

I will get into my application web page after verfiy the hostname of the server. The query used in the package to get the hostname is "select hostname into v_host from host_par where host_name=upper(utl_inaddr.get_host_name);" but this query is returing error ORA-29540: class oracle/plsql/net/InternetAddress does not exist
ORA-06512: at "SYS.UTL_INADDR", line 21 ORA-06512: at "SYS.UTL_INADDR", line 21

I've tried your adivce i.e loadjava -user sys/password plsql.jar but it giving error /u01/app/oracle/product/8.1.7/bin/loadjava[16]: /u01/app/oracle/product/8.1.7/JRE/bin/jre: not found

I've also tried a query on JAVA CLASS i.e "select * from dba_objects where object_type = 'JAVA CLASS' and upper(object_name) like upper('%internet%')"i could not find the "InternetAddress" java calss and the all the fetched JAVA CLASS are in invalid state.
Not sure where to go and how to slove. Your advice can help me out!!

Tom,

Sorry about the delay. As you suspected the JVM was corrected. We have re-installed the JVM and now OK