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.