ORACLE 11 ORA-00119 startup exception throw error handling today unexpected server restart, resulting in oracle exceptions. Www.2cto.com SQL> startup ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'listener _ ORCL 'on another terminal enter www.2cto.com [root @ huang14 ~] # Su-oracle [oracle @ huang14 ~] $ Cd/u01/oracle/product/10.2.0/db_1/dbs/[oracle @ huang14 dbs] $ strings spfileorcl. ora> initorcl. ora [oracle @ huang14 dbs] $ grep local_liste initorcl. ora *. local_listener = '(ADDRESS_LIST = (Address = (Protocol = TCP) (Host = 172.0.0.1) (Port = 1521)' [oracle @ huang14 dbs] $ vi initorcl. ora found *. local_listener, replace *. local_listener = '(ADDRESS_LIST = (Address = (Protocol = TCP) (Host = 172.0.0.1) (Port = 1521 ))) 'SQL> startup nomount pfile ='/u01/oracle/product/10.2.0/db_1/dbs/initorcl. ora 'oracle instance started. total System Global Area 2147483648 bytes Fixed Size 1220432 bytes Variable Size 218103984 bytes Database Buffers 1912602624 bytes Redo Buffers 15556608 bytes SQL> create spfile from pfile; File created. SQL> startup ORACLE instance started. total System Global Area 2147483648 bytes Fixed Size 1220432 bytes Variable Size 218103984 bytes Database Buffers 1912602624 bytes Redo Buffers 15556608 bytes Database mounted. database opened.