Oracle Error > Dispatcher

sql> startup ora-32004: obsolete and/or deprecated parameter(s) specified oracle instance started. total system global area 135338868 bytes fixed size 453492 bytes variable size 109051904 bytes database buffers 25165824 bytes redo buffers 667648 bytes database mounted. database opened. sql> shutdown immediate database closed. database dismounted. sql> -----remove dispatcher in pfile sql> ------start in pfile ----------now start in pfile sql> startup pfile='d:\oracle\admin\sue\pfile\init.ora'; ora-32006: mts_servers initialization parameter has been deprecated ora-00121: shared_servers specified without dispatchers ora-01078: failure in processing system parameters database buffers 25165824 bytes redo buffers 667648 bytes database mounted. database opened. sql> create spfile from pfile='d:\oracle\admin\sue\init.ora'; create spfile from pfile='d:\oracle\admin\sue\init.ora' * error at line 1: ora-32002: cannot create spfile already being used by the instance sql> create pfile='d:\oracle\admin\sue\init.ora' from spfile; file created. sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup pfile='d:\oracle\admin\sue\init.ora' ora-32006: mts_servers initialization parameter has been deprecated oracle instance started. --------------------remove mts parameter sql> startup pfile='d:/oracle/admin/sue/pfile/init.ora' oracle instance started. total system global area fixed size variable size database buffers

135338868 453492 109051904 25165824

bytes bytes bytes bytes

redo buffers 667648 bytes database mounted. database opened. sql> create spfile from pfile='d:/oracle/admin/sue/pfile/init.ora'; file created.

sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup oracle instance started. total system global area fixed size variable size database buffers redo buffers database mounted. database opened. sql> spool off

135338868 453492 109051904 25165824 667648

bytes bytes bytes bytes bytes