Linux RHEL3 & Oracle 10gR2 (java operating system call problem)
I wasn't quite sure where to post this, so if this is the wrong forum, please let me know so I can post it elsewhere.
My problem is with RHEL3 and Oracle 10gr2 database.
I am having problems with java calls to the operating system and getting end-of-file on communication channel with core dump and trace files being generated on an upgraded/new 10gr2 database.
I have performed 2 types of upgrades, for the Oracle database, to see where the problem is. I upgraded my database from 9i to 10gR2 via Database Upgrade Assistant (DBUA). I have also created a new database and ran a full import from the 9i database to new database.
My application server is 9iAS, on another machine.
The application runs java calls to the operating system to execute a .ksh script which retrieves reports generated on the application server and moves them to the database server (this is just one of the problems). All this worked just fine in 9i.
I can run the java call (i.e. exec java.call('parameter','parameter'); from sqlplus in 9i and it runs just fine.
In the 10g database if I run the java call from sqlplus I get end-of-file on communcation channel and core dump files and trace files are generated each time the call is performed. The connection to the operating system is not completed.
All permissions in dba_java_policy have been checked. This happens on both the DBUA database and the newly created database.
I have an SR started with Oracle, but it seems they can't find the problem either. They have had me remove and re-install JVM in the database, but that didn't change anything. Same problem.
Since I have to install the 10gR2 application server, I began getting the Linux environment ready.
I downloaded and upgraded Linux packages per the Application Server installation guide.
Since I have upgraded these packages, I have found that the core dump files are 1/2 the size they were before.
Could it be there is a package version discrepancy?
Wanted to know if anyone else might have run into this problem, or if anyone might know the reason or correction.
Thank you in advance.