存档

文章标签 ‘oracle’

ORA-00119: invalid specification for system parameter DISPATCHERS 错误如何解决

2022年2月9日 没有评论

SYS@PROD >startup ORA-00119: invalid specification for system parameter DISPATCHERS ORA-00111: invalid attribute DISPPATCHERS 解决方法 1.创建pfile SYS@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 Var...

分类: oracle 标签: ,