ORA-00119: Invalid specification for system parameter error Solution

If you accidentally change system parameters to an error, restarting will get a ORA-00119 error.

Example: accidentally modifying the dispatchers parameter at a time:

Alter system set dispatchers = '(Protocol = TCP) (Service = orcl' scope = spfile;

The parentheses are missing.

The following error is returned during startup:

ORA-32004: obsolete and/or deprecated parameter (s) specified
ORA-00119: Invalid specification for system parameter dispatchers

Solution:

1. Recreate pfile: SQL> Create pfile from spfile

2. The new pfile may be stored in different locations based on OS (Windows: \ oracle \ product \ 10.2.0 \ db_1 \ database \ init $ Sid. ora, Unix: D: \ oracle \ product \ 10.2.0 \ db_1 \ DBS \ init $ Sid. ora)

3. Modify the pfile file and find the correct value of the incorrect parameter. In this example, brackets are added.

Dispatchers = '(Protocol = TCP) (Service = orcl )'

4. Restart with pfile. SQL> startup pfile = '$ ORACLE_HOME/dbs/init $ Sid. ora ';

The database is started successfully.

5. Recreate spfile SQL> Create spfile from pfile

6. Restart. If the pfile parameter is not specified for startup, the created spfile is restarted.