location of init.ora ,control file and alert file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: location of init.ora ,control file and alert file

  1. #1
    Join Date
    Jan 2001
    Posts
    60
    Hi
    I want to know were we can locate these files init.ora,control file and alert in NT and in unix installation .
    what are the purposes of all these files exactly since i am learning dba at present

    Thanks
    lnr
    html code is off

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    init.ora - Usually located in $ORACLE_HOME/dbs. In some unix installations, this entry is a link to $ORACLE_BASE/admin/$ORACLE_SID/pfile. The init.ora file contains parameters that specify memory, database defaults, etc. that the database uses at startup.

    control files - These files are specified in the init.ora file by the CONTROL_FILES parameter. There are usually multiple copies of the control file on multiple disks. The control files are binary files that keep track of the files that compose the database and which SCN (transaction) is current.

    alert.log - This file location is specified in the init.ora file by the backround_dump_dest parameter. This file is usually in $ORACLE_BASE/admin/$ORACLE_SID/bdump. The alert.log file is a log of database level events that should be monitored by a human.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2001
    Posts
    60

    Thanks for that

    Hi

    I have some doubts on ckpt ,smon ,pmon ,dba buffer and so on can u give a clear picture of complete structure

    Thanks
    lnr
    html code is off

  4. #4
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    Hi,
    ckpt - related with logfiles used for performing checkpoints
    smon - for coelacing the disk fragmentations
    pmon - for resolving dead locks and freeing up process
    dba buffer - related with ckpt & dbwr holding the actual content of the data
    Pls refer to the Oracle Manual or Kevin Looney's Oracle DBA Handbook

    Rgds
    Ganesh .R
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

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