The following error occurred while starting the database
[Email protected] ~]$ Sqlplus/as SYSDBA
Sql*plus:release 11.2.0.4.0 Production on Mon 5 21:56:00 2014
Copyright (c) 1982, Oracle. All rights reserved.
Connected to an idle instance.
[email protected]>startup
ORA-00119:INVALID specification for system parameter Local_listener
Ora-00132:syntax error or unresolved network name ' LSNR2 '
Solutions
[Email protected] ~]$ CD $ORACLE _home/dbs
[[email protected] dbs]$ ls
Hc_orcl1.dat hc_prod.dat Initprod.ora ora_control1 orapworcl SNAPCF_PROD.F
Hc_orcl.dat Init.ora Lkprod ora_control2 Orapwprod
[Email protected] dbs]$ vim Initprod.ora
Find this line, delete
*.local_listener= ' LSNR2 '
Start the Oracle Database
[email protected]>startup
ORACLE instance started.
Total System Global area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 528485456 bytes
Database buffers 301989888 bytes
Redo buffers 2371584 bytes
Database mounted.
Database opened.
This article is from the "Cloud Life" blog, make sure to keep this source http://ovcer.blog.51cto.com/1145188/1406910