Oracle下ORA-00119错误的解决
时间:2022-03-10 17:12
Oracle在修改参数后启动时报下列错误
>startup
ORA-00119: invalid specification for system parameter DISPATCHERS
ORA-00111: invalid attribute DISPPATCHERS
解决方法
1.创建pfile
>create pfile from spfile;
File created.
2.修改pfile
[oracle@edbjr2p1 dbs]$ vim initPROD.ora
*.dispatchers=‘(PROT=TCP)(DISPATCHERS=2)‘
3.从pfile启动
>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.创建spfile
>create spfile from pfile;
File created.
问题解决
本文出自 “” 博客,请务必保留此出处
Oracle下ORA-00119错误的解决,布布扣,bubuko.com