Oracle在修改参数后启动时报下列错误

SYS@PROD>startup
ORA-00119:invalidspecificationforsystemparameterDISPATCHERS
ORA-00111:invalidattributeDISPPATCHERS

解决方法

1.创建pfile

SYS@PROD>createpfilefromspfile;

Filecreated.

2.修改pfile

[oracle@edbjr2p1dbs]$viminitPROD.ora

*.dispatchers='(PROT=TCP)(DISPATCHERS=2)'

3.从pfile启动

SYS@PROD>startuppfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initPROD.ora';
ORACLEinstancestarted.

TotalSystemGlobalArea835104768bytes
FixedSize2257840bytes
VariableSize549456976bytes
DatabaseBuffers281018368bytes
RedoBuffers2371584bytes
Databasemounted.
Databaseopened.

4.创建spfile

SYS@PROD>createspfilefrompfile;

Filecreated.

问题解决