2009/01/21

How to solve the LRM00109 and ORA01078

ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/opt/oracle/products/10.1.0.3/db...

when you use the pfile to startup the database, probably ora-01078 and lrm-00109 gonna catch you,how does this troubleshooting be well done

first all we need to figure out the location of the pfile folder, not pfile file, this folder probably was located at orcle_home\admin\orcl\pfile\,
there is pfile file named init.ora in this folder.when we create a pfile from spfile, this pfile will be located at orcle_home\db_1\database\, not in the pfile folder. so when we startup database firstly by using this pfile , it is failed

Solution ; we can copy the original pfile from pfile folder located at orcle_home\admin\orcl\pfile\, and paste this copy at orcle_home\db_1\database\, at last rename this copy same as the pfile that was name when you create a pfile from spfile.Right now you can set the parameter in pfile at orcle_home\db_1\database\ and startup by pfile The job is well done

No comments:

Post a Comment