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

修改\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了