Remove EM, force end EM process, start database ora-00119,ora-00132 error Resolution _oracle

Through the Emca-deconfig dbcontrol db-repos drop command to delete the EM repository, a long time did not delete the completion of the database connection number, reached the maximum number of database connections, the results of the front desk and the background are not connected to the database. Forced kill EM and application related process, shut down database, restart 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 '

Through the query Metalink may be caused by the modification of my host name problems.

The following fixes the problem by modifying the parameter file:

First create pfile through SPFile

$ sqlplus/as sysdba;
Sql> create Pfile from SPFile;

Local_listener This parameter was found by viewing the Pfile file, modifying *.local_listener= ' LISTENER_ORCL ' to *.local_listener= ' (address_list= ( PROTOCOL=TCP) (Host=your_hostname) (port=1521)) ' Save exit.
The login database then creates spfile based on the modified Pfile file

$ sqlplus/as sysdba;
Sql> create SPFile from Pfile;

Finally, the database is started. OK, problem solved!