Shulou(Shulou.com)06/01 Report--

Oracle launches the following error after modifying the parameters

SYS@PROD > startup

ORA-00119: invalid specification for system parameter DISPATCHERS

ORA-00111: invalid attribute DISPPATCHERS

Solution method

1. Create pfile

SYS@PROD > create pfile from spfile

File created.

two。 Modify pfile

[oracle@edbjr2p1 dbs] $vim initPROD.ora

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

3. Launch from 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. Create spfile

SYS@PROD > create spfile from pfile

File created.

Problem solving

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.