RE: alter system set user_dump

From: Linda Wang <lwang_at_messagemedia.com>
Date: Wed, 30 Aug 2000 13:13:20 -0600
Message-Id: <10604.115907@fatcity.com>

Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

SQL> select name, issys_modifiable from v$parameter where name like '%dump%';

NAME                                                             ISSYS_MOD
---------------------------------------------------------------- ---------
shadow_core_dump                                                 FALSE
background_core_dump                                             FALSE
background_dump_dest                                             IMMEDIATE
user_dump_dest                                                   IMMEDIATE
max_dump_file_size                                               IMMEDIATE
core_dump_dest                                                   IMMEDIATE

SQL> alter system set user_dump_dest='C:\temp';

System altered.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Shevtsov Eduard
Sent: Wednesday, August 30, 2000 1:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: alter system set user_dump_dest problem

Hi Sean and List

SQL> select * from v$version;

BANNER

Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.5.0.0 - Production
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production

SQL> col name format a20
SQL> select name, issys_modifiable
2 from v$parameter
3 where name like 'user_dump%';

NAME                 ISSYS_MOD
-------------------- ---------
user_dump_dest       FALSE

I don't think that behavior of the user_dump_dest was changed. Can anyone check this?

> SQL>alter system set user_dump_dest = 'e:\oradba\admin\tst';
> *
> ERROR at line 1:
> ORA-02095: specified initialization parameter cannot be modified
>
> This is Oracle 8.0.5 on NT4-SP4. According to
> Oracle8 Reference
> Release 8.0
> A58242-01
> ALTER SYSTEM SET can be used to change this initilization parameter.
> Pulling my hair (what's left of it that is) out on this one. Bethca' it's
> something simple. What am I doing wrong??? Aaaarrggggghhhhh.
>
>
> Sean :)
>
> ###### ###### ###### ######
> # # # # # # # # Rookie
> #### # # ###### ###### Data
> # # # # # # # # Base
> # # ####### ###### # # Adminstrator
> -------------------------------- ------------
> Organon (Ireland) Ltd.
> E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]
>
> The only man who never makes a mistake is the man who never does anything.
> - Theodore Roosevelt
>
>
>
>
>
>
>
> --
> Author: O'Neill, Sean
> INET: Sean.ONeill_at_organon.ie
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--
Author: Shevtsov Eduard
  INET: eshevtsov_at_flagship.ru

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Wed Aug 30 2000 - 14:13:20 CDT

RE: alter system set user_dump_dest problem