From oracle-l-bounce@freelists.org Mon Mar 22 19:31:32 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2N1VTl23370 for ; Mon, 22 Mar 2004 19:31:29 -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 i2N1V2o23334 for ; Mon, 22 Mar 2004 19:31:03 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1AFBA3911F0; Mon, 22 Mar 2004 20:13:39 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04542-92; Mon, 22 Mar 2004 20:13:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E3D393926A7; Mon, 22 Mar 2004 20:01:43 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 22 Mar 2004 20:00:31 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 800DD392B84 for ; Mon, 22 Mar 2004 19:54:02 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02545-84 for ; Mon, 22 Mar 2004 19:54:02 -0500 (EST) Received: from ddbcinc.com (unknown [216.222.6.50]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EEDC73933C2 for ; Mon, 22 Mar 2004 19:51:21 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: ORA-32004: obsolete and/or deprecated parameter(s) specified Date: Mon, 22 Mar 2004 18:01:40 -0700 Message-ID: <87E9F113CEF1D211A4C3009027301874272DC7@ddbcinc.ddbc.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ORA-32004: obsolete and/or deprecated parameter(s) specified thread-index: AcQQYlwqACnCAPl5TceR9UwHKU+L4QADyIKg From: "Justin Cave (DDBC)" To: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1496 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jcave@ddbcinc.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org My understanding from an Oracle TAR we had a while ago was that this parameter doesn't do anything any longer and was supposed to have been deprecated in 9i. I days gone by, this parameter specified that the database wasn't allowed to send the password in clear text. I believe this started to be the default in 7.3.4 and by 8i you couldn't pass in the plain text password. Thus, by 8i, this parameter was pretty useless. Now, it is completely useless. Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Michael Fontana Sent: Monday, March 22, 2004 2:48 PM To: oracle-l@freelists.org Subject: RE: ORA-32004: obsolete and/or deprecated parameter(s) specified Very good idea, Tom, although of course quite tedious. I narrowed it down to the following: Dblink_encrypt_login This parameter is no longer supported in 9i. Does anyone know what it's functional replacement is? Michael Fontana Sr. DBA NTT/Verio -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mercadante, Thomas F Sent: Monday, March 22, 2004 10:57 AM To: 'oracle-l@freelists.org' Subject: RE: ORA-32004: obsolete and/or deprecated parameter(s) specified Michael, It should be in the alert log. That's where I found my errors. Check your init.ora BDUMP parameter to make sure you are looking in the correct place. You can always start commenting out various init.ora params to find the offending one. Tom Mercadante Oracle Certified Professional -----Original Message----- From: Michael Fontana [mailto:mfontana@verio.net] Sent: Monday, March 22, 2004 11:35 AM To: oracle-l@freelists.org Subject: ORA-32004: obsolete and/or deprecated parameter(s) specified Getting an ORA-32004 starting up an Oracle9i (9.2.0.4) database. Standard documentation says more info on this message, including the cause, is available in the alert log, but alas, nothing there. Several threads with this same issue on metalink are left dangling. Has anyone encountered the secret place where oracle might be hiding the info about the deprecated parameter? Michael Fontana Sr. DBA NTT/Verio -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Paul Drake Sent: Monday, March 22, 2004 10:08 AM To: oracle-l@freelists.org Subject: RE: first (production) bug 10.1 on win32? --- Pete Sharman wrote: > No actually I, like the iSQL*Plus service was stopping for the night. > Long day, sick kids and wife. That's my excuse and I'm sticking to > it! > > C:\Documents and Settings\psharman>net stop > OracleOraDb10g_homeiSQL*Plus .. > The OracleOraDb10g_homeiSQL*Plus service was stopped successfully. > > > Pete > Pete, I should have stated the OS version. That box is w2k Adv svr sp4. I can start and stop the service just fine from the gui. I would still contend that someone outside of marketing needs to be consulted in choosing syntax. This is simply a nuisuance, not a real bug. thanks for testing - what OS version did you test against? Paul C:\WINNT\system32>net helpmsg 2185 The service name is invalid. EXPLANATION You tried to start a service that is not configured on this system. ACTION Check the spelling of the service name or check the configuration information for the service using the Services option from Server Manager. > > -----Original Message----- > From: oracle-l-bounce@freelists.org > [mailto:oracle-l-bounce@freelists.org] On Behalf Of Carel-Jan Engel > Sent: Monday, 22 March 2004 9:11 PM > To: oracle-l@freelists.org > Subject: RE: first (production) bug 10.1 on win32? > > Starting works Pete, take another coffee and look in in the message. > Does your service stop? That was reported to be the problem. > > Regards, Carel-Jan > > === > If you think education is expensive, try ignorance. > (Derek Bok) > === > > > > > Zip. Sorry, mine likewise has the asterisk and > starts quite happily. > > Look for something else, Mr. Drake! :) > > > > > > Pete > > > > "Controlling developers is like herding cats." > > Kevin Loney, Oracle DBA Handbook > > > > "Oh no, it's not. It's much harder than that!" > > Bruce Pihlamae, long-term Oracle DBA > > > > -----Original Message----- > > From: oracle-l-bounce@freelists.org > [mailto:oracle-l-bounce@freelists.org] > > On Behalf Of Paul Drake > > Sent: Monday, 22 March 2004 6:27 PM > > To: oracle-l@freelists.org > > Subject: first (production) bug 10.1 on win32? > > > > D:\Oracle\ora101\BIN> net start > > > > (removed non-relevant rows) > > > > OracleCSService > > OracleOraHome101iSQL*Plus > > OracleOraHome101TNSListener > > > > D:\Oracle\ora101\BIN>net stop > > "OracleOraHome101iSQL*Plus" > > The service name is invalid. > > > > More help is available by typing NET HELPMSG 2185. > > > > Who let out into production the use of an asterisk > in > > an OS service name? Probably the same type of user that puts > > non-alpha numerics (including spaces) > into > > file names. > > Humans. > > > > bug. > > > > Pd > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Finance Tax Center - File online. File on > time. > > http://taxes.yahoo.com/filing.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 > > > ----------------------------------------------------------------- > > > > > > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------