RE: alter system set user_dump_dest problem [SOLUTION]

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Thu, 31 Aug 2000 22:34:34 -0000
Message-Id: <10605.116026@fatcity.com>

Hi Mark & others,

To add an alternate view of 816 and NT

Running Oracle 8.1.6.1.2 under NT4 SP6a or SP5 I get IMMEDIATE.

I agree that under 8.1.5.0.5 on NT4 SP4 or 6a I get FALSE.

"

SQL> select * from v$version;

BANNER

---

Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production PL/SQL Release 8.1.6.1.0 - Production
CORE 8.1.6.0.0 Production
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production

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

NAME                 ISSYS_MOD
-------------------- ---------
user_dump_dest       IMMEDIATE

SQL>
"

I'd be interested to see the results of other 816 / NT users on this point.

Regards,
Bruce Reardon

Analyst / Programmer
Comalco Aluminium (Bell Bay)
mailto:bruce.reardon_at_comalco.riotinto.com.au

-----Original Message-----
From: Mark Leith [mailto:mark_at_cool-tools.co.uk] Sent: Friday, 1 September 2000 3:42
To: Multiple recipients of list ORACLE-L Subject: RE: alter system set user_dump_dest problem [SOLUTION]

On my NT4.0 sp6 machine running Oracle 8.0.4 I also get a FALSE.

To review all other input -

NT 4.0	7.3.4		FALSE
		8.0.4		FALSE
		8.0.5		FALSE
		8.1.5		FALSE
		8.1.6		FALSE

WIN2000	8.1.6		IMMEDIATE

LINUX		8.1.5		IMMEDIATE

SOLARIS	8.0.6		IMMEDIATE
		8.1.6		IMMEDIATE

AIX		8.1.5		IMMEDIATE
		8.1.6.2	IMMEDIATE

Now, I'm no guru but it seems pretty obvious that the problem is solely NT. Why this would change with WIN 2000 is beyond me??

I changed the init parameter on my machine and that did the trick Sean. Seems the only way that you can make it work. Another 'feature' for Oracle Received on Thu Aug 31 2000 - 17:34:34 CDT