1,The listener supports no services
2,invalid specification for system parameter LOCAL_LISTENER
create pfile from spfile
startup pfile='/ruiy/ocr/DBSoftware/app/oracle/product/11.2.0/dbhome_1/dbs/initpriydb.ora'
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_PRIYDB'
SQL> show parameter local_listener;
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
TNS:listener does not currently know of service requested in connect descriptor
修改\oracle\product\11.1.0\db_1\network\admin\listener.ora文件
加上
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = 你的数据库名称)
(ORACLE_HOME = D:\oracle\product\10.1.0\db_1)
)
)
然后重启lisener服务，就ok了
