Results 1 to 3 of 3

Thread: init.ora

  1. #1
    Join Date
    Feb 2004
    Location
    inida
    Posts
    62

    Unanswered: init.ora

    hi,

    Is the init.ora file exists in server?

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    It will be in $ORACLE_HOME/dbs and it will be called init<dbname>.ora
    Regards
    Dbabren

  3. #3
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    The first reply is correct for Unix servers. My reply is only for Windows.

    The default location of an init.ora file is %ORACLE_HOME%\database. For example, your database might use file c:\oracle\ora920\database\initSID.ora.

    I keep the init.ora files in the same folder tree as my other admin files. For example, under folder "c:\oracle\admin\SID" I would create a minimum of four folders bdump, pfile, pwfile, and udump. The location of folders bdump and udump is identified in your initSID.ora file. The location of the pfile and pwfile folders is managed by the Windows registry. For example, I create registry entry HKLM/software/oracle/home0/ora_SID_pfile with a value of c:\oracle\admin\SID\pfile\initSID.ora and I create registry entry HKLM/software/oracle/home0/ora_SID_pwfile with a value of c:\oracle\admin\SID\pwfile\pwdSID.ora

    SQL*Plus from the DOS command line behaves differently from the SQL*Plus GUI, when it comes to issuing the startup commands. Try both ways of starting the database before and after adding the pfile registry entry. Neat stuff.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

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