Remove EM, force end the EM process, start the database ORA-00119, the solution to ORA-00132 error, ora-00119ora-00132

Remove EM, force end the EM process, start the database ORA-00119, the solution to ORA-00132 error, ora-00119ora-00132

When you use the emca-deconfig dbcontrol db-repos drop command to delete the EM database, it has not been deleted for a long time. During this period, the number of database connections has soared to the maximum number of database connections. As a result, the front-end and back-end databases cannot be connected. Force killing EM and application-related processes, shut down the database, restart the database times: ORA-00119, ORA-00132 error.
SQL> startup;

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'listener _ ORCL'

By querying metalink, it is possible that the host name is changed.

Modify the parameter file to solve the problem:

Create pfile through spfile

$ Sqlplus/as sysdba;
SQL> create pfile from spfile;

You can view the pfile file and find the local_listener parameter. Modify the parameter *. local_listener = 'listener _ ORCL 'is *. local_listener = '(ADDRESS_LIST = (Address = (Protocol = tcp) (Host = your_hostname) (Port = 1521)') Save and exit.
Then log on to the database and create a spfile based on the modified pfile file.

$ Sqlplus/as sysdba;
SQL> create spfile from pfile;

Finally, start the database. OK, solve the problem!