obsolete parameters in pfile
Hi,
We have Oracle 10.2.0.3 database on AIX platform.For long ,our database has been running on pfile.We wanted our database to run on spfile and in that process,when we tried to "create spfile from pfile " we are getting the following errors.
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
ORA-32003: error occured processing parameter 'distributed_transactions'
LRM-00101: unknown parameter name 'distributed_transactions'
and similarly, for some other database,
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
ORA-32003: error occured processing parameter 'job_queue_interval'
LRM-00101: unknown parameter name 'job_queue_interval'
As 'distributed_transactions' and 'job_queue_interval' are obsolete parameters ,can I remove these parameter settings from pfile and go ahead creating the spfile or will it have some impact??
Could you please help us in resolving this issue....