the default location of the user_dump_dest
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: the default location of the user_dump_dest

Hybrid View

  1. #1
    Join Date
    Jul 2002
    Posts
    42
    Hi,

    I want to knwo the default location of the USER_DUMP_DEST.
    i can find out the user_dump_dest setted in the init.ora file or using sqlplus - show parameter.
    i am using HP-UNIX 11.0,oracle 8.1.7.3.
    since i have been facing some problem while connecting the database - ORA-12545/12547. So i went thru the metalink and found something. metalink doc asked me to check the default user_dump_dest directory for 1 cause. so i want this one. any one can help me.

    thanx in advance
    Oracle

  2. #2
    Join Date
    Dec 2001
    Posts
    320
    hi venkateskg,
    and what do you get when you use "show parameter" in SQL Plus?

  3. #3
    Join Date
    Jul 2002
    Posts
    42
    SQL*Plus: Release 9.0.1.0.1 - Production on Sat Jul 13 16:21:34 2002

    (c) Copyright 2001 Oracle Corporation. All rights reserved.


    Connected to:
    Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production
    With the Partitioning option
    JServer Release 8.1.7.3.0 - 64bit Production

    SQL> show parameter user_dump_dest

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    user_dump_dest string /oracle/admin/DMSC/udump
    SQL>

    The above is my sqlplus out put. this the path i setted in the init.ora file.
    Oracle

  4. #4
    Join Date
    Dec 2001
    Posts
    320
    so what you want now is the path that was used before you set this value in the user_dump_dest parameter?

  5. #5
    Join Date
    Dec 2001
    Posts
    320
    well venkateskg, as mentioned in
    http://otn.oracle.com/docs/products/...218.htm#945526

    User_dump_dest 's default value is an operating system dependent, so try to find trace files in a place other than the one set in the init.ora file, and this will be the default value (provided that you set that value once).

    Regards.

  6. #6
    Join Date
    Jul 2002
    Posts
    42
    thanx hany , i am going thru the document.
    Oracle

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width