Oracle下ORA-00119错误的解决

Oracle在修改参数后启动时报下列错误SYS@PROD >startup
ORA-00119: invalid specification for system parameter DISPATCHERS
ORA-00111: invalid attribute DISPPATCHERS解决方法1.创建pfileSYS@PROD >create pfile from spfile;File created.2.修改pfile[oracle@edbjr2p1 dbs]$ vim initPROD.ora*.dispatchers="（PROT=TCP）（DISPATCHERS=2）"3.从pfile启动SYS@PROD >startup pfile="/u01/app/oracle/product/11.2.0/db_1/dbs/initPROD.ora";
ORACLE instance started.Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 549456976 bytes
Database Buffers 281018368 bytes
Redo Buffers 2371584 bytes
Database mounted.
Database opened.4.创建spfileSYS@PROD >create spfile from pfile;File created.问题解决DBCA 报错 ORA-00119 ORA-00132 http://www.linuxidc.com/Linux/2014-04/99347.htmORA-00119: invalid specification for system parameter LOCAL_LISTENER http://www.linuxidc.com/Linux/2014-02/96745.htmORA-00119错误处理 http://www.linuxidc.com/Linux/2014-01/95675.htmOracle启动出现了ORA-00119，ORA-00130 http://www.linuxidc.com/Linux/2013-10/91919.htmORA-00119: invalid specification for system parameter REMOTE_LISTENER错误 http://www.linuxidc.com/Linux/2013-08/88636.htmOracle ORA-00119，ORA-00132 错误处理 http://www.linuxidc.com/Linux/2011-05/35600.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址