From oracle-l-bounce@freelists.org Mon Feb 23 14:00:15 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1NK0FU10772 for ; Mon, 23 Feb 2004 14:00:15 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1NK0Do10765 for ; Mon, 23 Feb 2004 14:00:13 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 620B1394FAA; Mon, 23 Feb 2004 15:01:58 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 23 Feb 2004 15:00:54 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from temmx.guidant.com (temmx.guidant.com [12.145.46.163]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BF40B394C82 for ; Mon, 23 Feb 2004 15:00:51 -0500 (EST) Received: from temvsc01.tem.guidant.com (temvsc01.tem.guidant.com [132.189.81.174]) by temmx.guidant.com (8.12.10/8.12.9) with SMTP id i1NJir8L016668 for ; Mon, 23 Feb 2004 11:44:53 -0800 (PST) Received: from temmse04.ad.guidant.com ([132.189.81.10]) by TEMMSE04.ad.guidant.com with Microsoft SMTPSVC(5.0.2195.5329); Mon, 23 Feb 2004 12:03:18 -0800 Received: from temmse06.ad.guidant.com ([132.189.81.16]) by temmse04.ad.guidant.com with Microsoft SMTPSVC(5.0.2195.5329); Mon, 23 Feb 2004 12:03:18 -0800 X-MimeOLE: Produced By Microsoft Exchange V6.0.6375.0 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: Slightly OT: Java in the DB Date: Mon, 23 Feb 2004 12:03:19 -0800 Message-ID: <791D0E1ECDECD04D89205F33806FC38701E91BF2@temmse06.tem.guidant.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Slightly OT: Java in the DB Thread-Index: AcP6PeoqdBnRwwqcTTWxoUDMV3hWnQACbKwA From: "Vergara, Michael (TEM)" To: X-OriginalArrivalTime: 23 Feb 2004 20:03:18.0025 (UTC) FILETIME=[14371790:01C3FA48] X-archive-position: 1632 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mvergara@guidant.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l More cogitating now prompts me to ask this question. Jared (et al), could this be done in Perl? I'd really like this utility to not have to plant a client procedure or something at the remote DB. That's why I was trying to use Java from inside a central admin DB. However, since that central admin DB runs on a central server, is=20 there a Perl ... um ... object that will connect and reset a password even if the user account has expired? If so, I'll dig into the Perl docs. This is an unexplored country to me. I can barely spell Perl! Cheers, Mike -----Original Message----- From: Jared.Still@radisys.com [mailto:Jared.Still@radisys.com] Sent: Monday, February 23, 2004 10:49 AM To: oracle-l@freelists.org Subject: Re: Slightly OT: Java in the DB Neither MetaLink nor Google have ever heard of ORa-21607, save the same stuff you saw from oerr. Time for an iTar Jared "Vergara, Michael (TEM)" Sent by: oracle-l-bounce@freelists.org 02/22/2004 01:13 PM Please respond to oracle-l =20 To: "Oracle-L (E-mail)" cc:=20 Subject: Slightly OT: Java in the DB Hi All...sorry for the semi-OT post, but I'm trying to do a DBA function using Java and have run into another problem. I'm trying to reset user's passwords. That's the whole goal. I have a 'administrative' database that has connections (TNS,=3D20 some DB links, etc) to other databases. I want to use the OCINewPassword function call in a stored Java procedure to execute the password changes on remote databases. I have=3D20 this neat code that I cobbled together from hints on MetalLink and other places, and it works...but. The Java source compiles. It Loads into the DB with loadjava. I build a PL/SQL function wrapper. It executes. It changes the password and exits the remote DB Great. This is good. But...when I enter 'exit' at the SQL prompt, the process hangs, spins up to taking 100% of the CPU, and throws various errors in the trace file. I have to kill the client process with a 'kill -9' command to get the process back. There is one error I cannot=3D20 figure out. It's an ORA-21607 error. It says "Initialize the=3D20 memory service handle". Huh? What in the blinking blue blazes=3D20 does that mean? Any suggestions? I'm gonna post a similar message on the Java list, but I thought that they'd not know about an ORA-21607. Help! Thanks, Mike ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------