RE: weird user_dump

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Mon, 11 Apr 2005 13:02:58 -0400
Message-ID: <E518A02B320C8D4E97D99A8C546480210C3EAD57@dohsmailhq01.doh.ad.state.fl.us>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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"

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.

--
http://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

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

Received on Mon Apr 11 2005 - 13:07:43 CDT

RE: weird user_dump_dest issue