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.
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
Life is a journey, not a destination!
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 email@example.com
Rohit Nirkhe,Oracle DBA,OCP 8i
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.
Click Here to Expand Forum to Full Width