Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

obsolete parameters in pfile

bharathDBAMar 16 2012 — edited May 14 2013
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....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2013
Added on Mar 16 2012
4 comments
401 views