Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

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

Mercadante, Thomas F

2004-03-22

Replies:
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@(protected)]
Sent: Monday, March 22, 2004 11:35 AM
To: oracle-l@(protected)
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@(protected)
[mailto:oracle-l-bounce@(protected)
Sent: Monday, March 22, 2004 10:08 AM
To: oracle-l@(protected)
Subject: RE: first (production) bug 10.1 on win32?


--- Pete Sharman <peter.sharman@(protected):
> 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@(protected)
> [mailto:oracle-l-bounce@(protected)
> Sent: Monday, 22 March 2004 9:11 PM
> To: oracle-l@(protected)
> 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@(protected)
> [mailto:oracle-l-bounce@(protected)]
> > On Behalf Of Paul Drake
> > Sent: Monday, 22 March 2004 6:27 PM
> > To: oracle-l@(protected)
> > 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@(protected)
> > 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@(protected)
> > 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@(protected)
> 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@(protected)
> 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@(protected)
'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@(protected)
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@(protected)
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
-----------------------------------------------------------------