且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

oralce dubugs

更新时间:2022-09-11 22:57:34

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了