-- 啟動監(jiān)聽,提示已經(jīng)啟動.
[Oracle@sh ~]$ lsnrctl startLSNRCTL for linux: Version 12.1.0.2.0 - PRoduction on 06-FEB-2017 15:30:14Copyright (c) 1991, 2014, Oracle. All rights reserved.TNS-01106: Listener using listener name LISTENER has already been started
-- 通過ps 命令沒有發(fā)現(xiàn) 監(jiān)聽的進程
[root@sh ~]# ps -ef | grep -i tnsroot 36 2 0 Jan26 ? 00:00:00 [netns]root 14995 14824 0 15:30 pts/1 00:00:00 grep -i tns
-- 查看監(jiān)聽狀態(tài),報錯; TNS-01189
[oracle@sh ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-FEB-2017 15:57:39Copyright (c) 1991, 2014, Oracle. All rights reserved.Connecting to (DESCRipTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wh)(PORT=1521)))TNS-01189: The listener could not authenticate the user
-- 這個問題基本2個原因?qū)е?
1, /etc/hosts 文件中的 ip和主機名不一致
2, listener.ora 中監(jiān)聽主機非當前主機.
通過檢查, 是 listener.ora 監(jiān)聽主機填寫錯誤錯誤
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sh)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )
修改為當前主機名后,重啟監(jiān)聽恢復(fù)正常.
新聞熱點
疑難解答