Default location
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Default location

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    Default location

    In 9i,using DBCA i've created a database,the database structure looks exactly like Oracle optimal Flexible Architecture.My doubt is,if OFA is not followed,what will be the default location(in Windows as well as UNIX) for

    1. Datafiles(includes redo logs,tempfiles,control files)
    2. Dump files
    3. Init.ora file
    4. Archived log files

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    init.ota files are always oracle_home/dbs or database if windows

    ORACLE_BASE/oradata for database

    no such thing as dump files so therefore no default

    default for archive files is oracle_home/dbs unless you set it differently

    seriously, read the docs!!!!!!!!!!!!!!!!!

  3. #3
    Join Date
    Feb 2006
    Posts
    162
    Thanks davey23uk.

    Dump files in the sense,i mean to say the UDUMP,BDUMP & CDUMP locations.

    Thanks,
    Malru

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    there is no default, they go where they are told to go

  5. #5
    Join Date
    May 2006
    Posts
    10
    when install db,it set ,
    the parameter file
    background_dump_dest=E:\oracle\product\10.1.0\admin\dbatech\bdump
    core_dump_dest=E:\oracle\product\10.1.0\admin\dbatech\cdump
    user_dump_dest=E:\oracle\product\10.1.0\admin\dbatech\udump

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    they arent defaults, they are where they are told to go (just what I said)

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