精品福利av,中文字幕在线播放网址,麻豆一区一区三区四区

主頁(yè) > 知識(shí)庫(kù) > Oracle 12.2監(jiān)聽(tīng)無(wú)法啟動(dòng)解決方法

Oracle 12.2監(jiān)聽(tīng)無(wú)法啟動(dòng)解決方法

在自己的虛擬機(jī)的做實(shí)驗(yàn)，突然發(fā)現(xiàn)使用PL/SQL Developer無(wú)法連接到數(shù)據(jù)庫(kù)，報(bào)錯(cuò)ORA-12514，說(shuō)是監(jiān)聽(tīng)沒(méi)有啟動(dòng)。

先介紹虛擬機(jī)一下環(huán)境：redhat7.2+GI 12.2.0.1+Oracle 12.2.0.1，為了測(cè)試12.2的ASM特性安裝了GI。平時(shí)監(jiān)聽(tīng)程序默認(rèn)是開(kāi)啟啟動(dòng)的。但是今天不知道為什么沒(méi)有啟動(dòng)。使用crsctl查看資源狀態(tài)：發(fā)現(xiàn)監(jiān)聽(tīng)的狀態(tài)確實(shí)是OFFLINE狀態(tài)

[root@rhel7 .oracle]# crsstat
--------------------------------------------------------------------------------
Name      Target State    Server          State details    
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
        ONLINE ONLINE    rhel7          STABLE
ora.LISTENER.lsnr
        ONLINE OFFLINE   rhel7          STABLE
ora.asm
        ONLINE ONLINE    rhel7          Started,STABLE
ora.ons
        OFFLINE OFFLINE   rhel7          STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
   1    ONLINE ONLINE    rhel7          STABLE
ora.diskmon
   1    OFFLINE OFFLINE                STABLE
ora.driver.afd
   1    ONLINE ONLINE    rhel7          STABLE
ora.evmd
   1    ONLINE ONLINE    rhel7          STABLE
ora.ora12c.db
   1    ONLINE ONLINE    rhel7          Open,HOME=/u01/app/o
                               racle/product/12.2/d
                               b_home1,STABLE
--------------------------------------------------------------------------------

嘗試手動(dòng)啟動(dòng)監(jiān)聽(tīng)，依然報(bào)錯(cuò)：

[grid@rhel7 ~]$ srvctl start listener
PRCR-1079 : Failed to start resource ora.LISTENER.lsnr
CRS-5016: Process "/u01/app/grid/bin/lsnrctl" spawned by agent "ORAAGENT" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/12.2/grid/diag/crs/rhel7/crs/trace/ohasd_oraagent_grid.trc"
CRS-5016: Process "/u01/app/grid/bin/lsnrctl" spawned by agent "ORAAGENT" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/12.2/grid/diag/crs/rhel7/crs/trace/ohasd_oraagent_grid.trc"
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'rhel7' failed

根據(jù)提示查看trc文件，看到如下報(bào)錯(cuò)：

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 15-NOV-2017 20:03:28
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/grid/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/grid/network/admin/listener.ora
Log messages written to /u01/app/12.2/grid/diag/tnslsnr/rhel7/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel7)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12555: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
 TNS-00525: Insufficient privilege for operation
  Linux Error: 1: Operation not permitted
Listener failed to start. See the error message(s) above...

看到Insufficient privilege for operation這個(gè)字樣覺(jué)得很納悶，怎么會(huì)權(quán)限不足呢，于是嘗試用root直接啟動(dòng)監(jiān)聽(tīng)，依然報(bào)錯(cuò)：

[root@rhel7 .oracle]# lsnrctl start
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 15-NOV-2017 20:22:30
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/grid/bin/tnslsnr: please wait...
TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
 TNS-00516: Permission denied
  Linux Error: 13: Permission denied

于是各種百度，下面把百度到內(nèi)容列出來(lái)，可能會(huì)對(duì)看此文的同學(xué)有用，但是對(duì)我這種情況沒(méi)有用：
主要是說(shuō) /var/tmp/.oracle、/tmp/.oracle 這兩個(gè)目錄的權(quán)限訪問(wèn)問(wèn)題。進(jìn)入一看，我的/var/tmp/.oracle權(quán)限沒(méi)問(wèn)題，而/tmp/.oracle壓根就沒(méi)有這個(gè)文件。

于是直接查MOS，看有沒(méi)有相關(guān)的文檔，找到兩篇文檔：

Starting the Listener Fails With: TNS-12557 or TNS-12555: TNS:Permission Denied (文檔 ID 343253.1)
Listener Fails To Start With IPC Permission Errors (TNS-12546 TNS-12555 TNS-00516 TNS-00525) (文檔 ID 434062.1)

對(duì)比了文檔中列出的問(wèn)題，跟我的情況也不一相，看到最后發(fā)現(xiàn)這樣一句話：

4. If you find that there are no adapters linked or they have errors (such as "Permission denied") then issue a "relink all"

Reference:
Doc ID 1467060.1

于是只有用這種方法來(lái)試試了，由于crs使用的是grid home下的監(jiān)聽(tīng)命令所以對(duì)grid home做relink all操作?？墒怯殖霈F(xiàn)報(bào)錯(cuò)：

[grid@rhel7 bin]$ relink all
 The Oracle home in which you are running this relinking tool does not 
have proper write permissions. Please run this relink script as the same
user who owns the Oracle home and ensure that the Oracle home has the
permissions from the original installation.
 If this is a Grid Infrastructure home, please refer to the 
documentation for the proper steps to relink and apply oneoff patches.

意思是說(shuō)權(quán)限不足，使用root執(zhí)行，又報(bào)錯(cuò)說(shuō)不能用root執(zhí)行

[root@rhel7 bin]# relink all
The relink script cannot be run as root.

又查看grid home目錄權(quán)限

[root@rhel7 app]# ls -ld grid
total 8
drwxr-x--- 84 root  oinstall 4096 Jul 18 20:26 grid

原來(lái)owner是root，怪不得第一次執(zhí)行不成功，修改owner(應(yīng)該直接chmod也可以，這里沒(méi)有做測(cè)試)，重新執(zhí)行relink all

[root@rhel7 app]# chown grid grid
[grid@rhel7 ~]$ relink all
writing relink log to: /u01/app/grid/install/relink.log

成功后再次啟動(dòng)監(jiān)聽(tīng)，啟動(dòng)成功。

[grid@rhel7 ~]$ lsnrctl start
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 15-NOV-2017 20:50:59
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/grid/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/grid/network/admin/listener.ora
Log messages written to /u01/app/12.2/grid/diag/tnslsnr/rhel7/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel7)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rhel7)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias           LISTENER
Version          TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date        15-NOV-2017 20:51:00
Uptime          0 days 0 hr. 0 min. 0 sec
Trace Level        off
Security         ON: Local OS Authentication
SNMP           OFF
Listener Parameter File  /u01/app/grid/network/admin/listener.ora
Listener Log File     /u01/app/12.2/grid/diag/tnslsnr/rhel7/listener/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel7)(PORT=1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

至次問(wèn)題解決。

總結(jié)

以上所述是小編給大家介紹的Oracle 12.2監(jiān)聽(tīng)無(wú)法啟動(dòng)解決方法，希望對(duì)大家有所幫助，如果大家有任何疑問(wèn)請(qǐng)給我留言，小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)腳本之家網(wǎng)站的支持！

您可能感興趣的文章:

OracleOraDb10g_home1TNSListener服務(wù)無(wú)法啟動(dòng)怎么解決
修改計(jì)算機(jī)名或IP后Oracle10g服務(wù)無(wú)法啟動(dòng)的解決方法
oracle修改SGA后無(wú)法啟動(dòng)問(wèn)題分析及解決方法

標(biāo)簽：郴州滁州南充許昌涼山遼源合肥焦作

巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《Oracle 12.2監(jiān)聽(tīng)無(wú)法啟動(dòng)解決方法》，本文關(guān)鍵詞 Oracle,12.2,監(jiān)聽(tīng),無(wú)法,啟動(dòng),；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題，煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無(wú)關(guān)。