Default location

[malru]

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

[davey23uk]

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!!!!!!!!!!!!!!!!!

[malru]

Thanks davey23uk.

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

Thanks,
Malru

[davey23uk]

there is no default, they go where they are told to go

[lakher]

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

[davey23uk]

they arent defaults, they are where they are told to go (just what I said)