P. Forstmann wrote:Oops!! but i have done that already ! , and database is running .Thanks for a advice , but what it would effect on New database
You must not use the same PFILE or SPFILE that an existing database.
If you want to create a database manually you need to create a PFILE by hand and make sure that any file name in this PFILE like CONTROL_FILES parameter or directory name are distinct from any existing database on the same machine.from oracle docs , i found sample Pfile , and i changed only few parameters like DBname , and Oracle_home , Oracle_base ( i have put the same oracle_home & base)
It would be much easier if you use DBCA to create a new database because DBCA will do this automatically for you (including ORADIM steps).I knew about the DBCA , but i was trying to do with only command line interface !
newbieDBA wrote:while your goal is admirable, you lack the requisite basic knowledge to do so.
I knew about the DBCA , but i was trying to do with only command line interface !