oralce dubugs

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

修改oracleproduct11.1.0db_1
etworkadminlistener.ora文件
加上
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = 你的数据库名称)
(ORACLE_HOME = D:oracleproduct10.1.0db_1)
)
)
然后重启lisener服务,就ok了
原文地址:https://www.cnblogs.com/ruiy/p/4251337.html