RE: weird user_dump_dest issue

  • From: <Paula_Stankus@xxxxxxxxxxxxxxx>
  • To: <spikey.mcmarbles@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 11 Apr 2005 13:02:58 -0400

Are you sure that you are using an init file versus an spfile?  That
immediately comes to mind.  =20

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Greg Norris
Sent: Monday, April 11, 2005 1:00 PM
To: ORACLE-L
Subject: weird user_dump_dest issue

I've got kind of a weird issue with a 9.2.0.5 (64-bit) database on
HP-UX.  Basically, it seems to be forgetting the "user_dump_dest"
setting for some reason... it's putting trace files under
$ORACLE_HOME/rdbms/log even though the parameter is properly set, and
"show parameter user_dump_dest" indicates the expected location.

I can reset it dynamically with no apparent trouble, but for some reason
it seems to revert back after writing the first tracefile (see below).
The directory permissions seem to be OK (mode 750, owned by oracle:dba),
and the alert log doesn't show anything out of the ordinary.

Anyone else run into this sort of behaviour?  Any suggestions on what to
look at?


$ pwd
/oracle/u01/admin/P1CTM1/udump

$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.5.0 - Production on Mon Apr 11 11:40:15 2005
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production With
the Partitioning option JServer Release 9.2.0.5.0 - Production

SQL> show parameter user_dump_dest

NAME           TYPE   VALUE
-------------- ------ ------------------------------ user_dump_dest
string /oracle/u01/admin/P1CTM1/udump

SQL> alter database backup controlfile to trace;

Database altered.

SQL> !ls -l
total 0

SQL> alter system set user_dump_dest=3D'/oracle/u01/admin/P1CTM1/udump'
scope=3Dboth;

System altered.

SQL> alter database backup controlfile to trace;

Database altered.

SQL> !ls -l
total 15
-rw-r-----   1 oracle   dba         12272 Apr 11 11:41
p1ctm1_ora_12535.trc

SQL> /

Database altered.

SQL> !ls -l
total 15
-rw-r-----   1 oracle   dba         12272 Apr 11 11:41
p1ctm1_ora_12535.trc

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit
Production With the Partitioning option JServer Release 9.2.0.5.0 -
Production

--
"I'm too sexy for my code." - Awk Sed Fred.
--
//www.freelists.org/webpage/oracle-l


BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 29315755) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D29315755&m=3Dadae=
ed515
ba6
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D29315755&m=3Dadae=
ed515
ba6
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D29315755&m=3Dadae=
ed515
ba6
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

--
//www.freelists.org/webpage/oracle-l

Other related posts: