Pfile parameters oracle 10g
Dec 12, · If the instance is running with SPFILE parameter and you have changed the dynamic parameter to SPFILE only. At this time it does not validate the new parameter value. Anyway, now I can't connect with SQLPlus, or even get into the Enterprise Manager in Oracle 10g. SQL> startup pfile=comienzoweb.com ORACLE instance started. Total System. IS there a view where i can check whether an instance had been started using a pfile or an spfile? Aug 29, · My understanding is that the spfile is a binary file that should not be edited. You can start your database by telling it which spfile to use by setting the value inside you pfile: spfile="yadaydayada" The value of this parameter is the name of the current server parameter file (SPFILE) in use. This parameter can be defined in a client side PFILE to indicate the name of the server parameter.