centos安装oracle10及重启后的tns错误解决

重启后就出现ORA-12514: TNS:listener does not currently know of service requested in connect descriptor:

vi  /usr/local/oracle/product/10.2.0.1/network/admin/listener.ora

SID_LIST_LISTENER   =
(SID_LIST   =
(SID_DESC   =
(SID_NAME   =   PLSExtProc)
(ORACLE_HOME   =   E:\oracle\product\10.1.0\Db_1)
(PROGRAM   =   extproc)
)
)

改为：
SID_LIST_LISTENER   =
(SID_LIST   =
(SID_DESC   =
(SID_NAME   =   PLSExtProc)
(ORACLE_HOME   =   E:\oracle\product\10.1.0\Db_1)
(PROGRAM   =   extproc)
)
(SID_DESC   =
(GLOBAL_DBNAME=   orcl)
(ORACLE_HOME   =   E:\oracle\product\10.1.0\Db_1)
(SID_NAME=orcl)
)
)