Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-32004: obsolete and/or deprecated parameter(s) specified

RE: ORA-32004: obsolete and/or deprecated parameter(s) specified

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Tue, 23 Mar 2004 10:58:50 -0500
Message-ID: <BAY99-F9tvOxToOxAZ10002d2f3@hotmail.com>


Steve,

Nice to see your responses, once again. You are really a master of Oracle. Knowledge is power and you are always sharing it. Next one is Tandel Poder, a young Steve Adam inline.

Best Regards,
Your old Fan,
Rafiq

From: "Steve Adams" <steve.adams_at_ixora.com.au> Reply-To: oracle-l_at_freelists.org
To: "'Michael Fontana'" <mfontana_at_verio.net>,<oracle-l_at_freelists.org> Subject: RE: ORA-32004: obsolete and/or deprecated parameter(s) specified Date: Tue, 23 Mar 2004 08:57:17 +1100

Hi Michael,

Consider ...

   select kspponm, ksppoflg from x$ksppo;

Flag value 1 means obsolete; 2 means deprecated.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/         - For DBAs
@   http://www.christianity.net.au/  - For all

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Fontana
Sent: Tuesday, 23 March 2004 3:35 AM
To: oracle-l_at_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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paul Drake Sent: Monday, March 22, 2004 10:08 AM
To: oracle-l_at_freelists.org
Subject: RE: first (production) bug 10.1 on win32?

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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Carel-Jan Engel
> Sent: Monday, 22 March 2004 9:11 PM
> To: oracle-l_at_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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> > On Behalf Of Paul Drake
> > Sent: Monday, 22 March 2004 6:27 PM
> > To: oracle-l_at_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_at_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_at_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_at_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_at_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_at_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_at_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_at_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
-----------------------------------------------------------------

_________________________________________________________________
Get rid of annoying pop-up ads with the new MSN Toolbar  FREE! 
http://clk.atdmt.com/AVE/go/onm00200414ave/direct/01/

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_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
-----------------------------------------------------------------
Received on Tue Mar 23 2004 - 11:08:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US