DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Where is the file configDB.ora

  1. #1
    Join Date
    Mar 2001
    Posts
    109
    I red a Oracle doc which updated in MAR 2001. Based on this doc, I need to set control_files path in the file configDB.ora.
    But it seems to me that we set control_files path in the file initDB.ora.

    Does anyone know the file configDB.ora and where it is located? I am running Oracle 8.1.7 EE on UINIX.

    Thanks.
    zm

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Yes your assumption of setting the control file path in the initSID.ora is a correct way to do. For how to create a database, please refer the createdb.sql script normally found under $ORACLE_HOME/rdbms/admin

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Normally all the static parmaters are kept in config.ora file.We can also set the control_files parameter in init.ora file but since we dont change this parameter most often we set this in config.ora
    Normally the config.ora file is found in $ORACLE_HOME/dbs sirectory.
    In case of any help please be free to ask me at rohitsn@altavista.com

    regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  4. #4
    Join Date
    Apr 2001
    Posts
    14
    I think we can define path of config.ora file with
    'ifile' parameter in init.ora in Unix.

    So you can set path for config.ora thru ifile para. Normally
    it is kept under 'dbs' dir.

    Pl. friends, correct me if i am wrong.

    deval

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