grid軟體安裝目錄許可權被修改引起登陸ASM出現ORA-12547 TNSlost contact
測試環境,安裝EM12C AGENT後,登陸ASM時發現問題:
1.故障現象
[grid@AAAA grid]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Wed May 11 14:54:39 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
[root@AAAA ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE OFFLINE AAAA
ora.DATA.dg
ONLINE OFFLINE AAAA
ora.FRA.dg
ONLINE OFFLINE AAAA
ora.LISTENER.lsnr
ONLINE OFFLINE AAAA STARTING
ora.asm
ONLINE OFFLINE AAAA
ora.ons
OFFLINE OFFLINE AAAA
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE OFFLINE
ora.AAAA.db
1 ONLINE OFFLINE
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE AAAA
----------------------------------
2.排查過程
登陸ASM報錯,首先排查ASM的日誌:
Fri Apr 15 22:01:04 2016
NOTE: Advanced to new COD format for group ARCH
Wed May 11 14:11:51 2016
Errors in file /u01/app/grid/diag/asm/+asm/+ASM/trace/+ASM_ora_8967.trc (incident=5761):
ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match euid], [500], [507], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/grid/diag/asm/+asm/+ASM/incident/incdir_5761/+ASM_ora_8967_i5761.trc
----ORACLE_HOME的UID不相符,從下面檢查使用者許可權可以看到是將UID 507、500物件的是GRID/ORACLE使用者。
[grid@AAAA grid]$ id grid
uid=507(grid) gid=501(oinstall) groups=501(oinstall),502(dba),504(asmadmin),505(asmdba),506(asmoper)
[grid@AAAA grid]$ id oracle
uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmdba)
如下驗證可以發現GRID使用者的安裝許可權都被誤操作修改為OWNER為oracle。
[grid@AAAA +ASM]$ cd /u01/app/
[grid@AAAA app]$ ls -al
total 28
drwxrwxr-x. 7 oracle oinstall 4096 May 11 13:58 .
drwxrwxr-x. 3 oracle oinstall 4096 Apr 12 11:41 ..
drwxrwxr-x. 67 oracle oinstall 4096 Apr 15 11:49 11.2.0
drwxr-xr-x. 6 oracle oinstall 4096 May 11 14:03 agent12c
drwxrwxr-x. 9 oracle oinstall 4096 Apr 15 12:39 grid
drwxrwxr-x. 7 oracle oinstall 4096 Apr 15 13:38 oracle
drwxrwx---. 6 oracle oinstall 4096 May 11 14:24 oraInventory
ORA-12547: TNS:lost contact在RAC中常見的還有oracle程式的許可權不對,
ORA-12547 Errors
The error ORA-12547 indicates that the communication channel has been broken. It's most often thrown because the other end of the process went away unexpectedly.
Note 1307075.1 Oracle Database Fails to Start with Error ORA-12547
Note 381566.1 connect / as sysdba Fails with Ora-12547 And Tns-12514
Note 744512.1 Ora-12547: Tns:Lost Contact Creating Database After Clean Installation
1.故障現象
[grid@AAAA grid]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Wed May 11 14:54:39 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
[root@AAAA ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE OFFLINE AAAA
ora.DATA.dg
ONLINE OFFLINE AAAA
ora.FRA.dg
ONLINE OFFLINE AAAA
ora.LISTENER.lsnr
ONLINE OFFLINE AAAA STARTING
ora.asm
ONLINE OFFLINE AAAA
ora.ons
OFFLINE OFFLINE AAAA
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE OFFLINE
ora.AAAA.db
1 ONLINE OFFLINE
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE AAAA
----------------------------------
2.排查過程
登陸ASM報錯,首先排查ASM的日誌:
Fri Apr 15 22:01:04 2016
NOTE: Advanced to new COD format for group ARCH
Wed May 11 14:11:51 2016
Errors in file /u01/app/grid/diag/asm/+asm/+ASM/trace/+ASM_ora_8967.trc (incident=5761):
ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match euid], [500], [507], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/grid/diag/asm/+asm/+ASM/incident/incdir_5761/+ASM_ora_8967_i5761.trc
----ORACLE_HOME的UID不相符,從下面檢查使用者許可權可以看到是將UID 507、500物件的是GRID/ORACLE使用者。
[grid@AAAA grid]$ id grid
uid=507(grid) gid=501(oinstall) groups=501(oinstall),502(dba),504(asmadmin),505(asmdba),506(asmoper)
[grid@AAAA grid]$ id oracle
uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmdba)
如下驗證可以發現GRID使用者的安裝許可權都被誤操作修改為OWNER為oracle。
[grid@AAAA +ASM]$ cd /u01/app/
[grid@AAAA app]$ ls -al
total 28
drwxrwxr-x. 7 oracle oinstall 4096 May 11 13:58 .
drwxrwxr-x. 3 oracle oinstall 4096 Apr 12 11:41 ..
drwxrwxr-x. 67 oracle oinstall 4096 Apr 15 11:49 11.2.0
drwxr-xr-x. 6 oracle oinstall 4096 May 11 14:03 agent12c
drwxrwxr-x. 9 oracle oinstall 4096 Apr 15 12:39 grid
drwxrwxr-x. 7 oracle oinstall 4096 Apr 15 13:38 oracle
drwxrwx---. 6 oracle oinstall 4096 May 11 14:24 oraInventory
臨時解決方法:是重新使用命令:chown -R /u01/app/11.2.0 等方式修改目錄許可權後恢復正常,不過GRID軟體中有一些檔案的許可權是root,此時暫時不管了。
--從執行穩定角度來看,建議是重新安裝了。
ORA-12547: TNS:lost contact在RAC中常見的還有oracle程式的許可權不對,
ORA-12547 Errors
The error ORA-12547 indicates that the communication channel has been broken. It's most often thrown because the other end of the process went away unexpectedly.
Note 1307075.1 Oracle Database Fails to Start with Error ORA-12547
Note 381566.1 connect / as sysdba Fails with Ora-12547 And Tns-12514
Note 744512.1 Ora-12547: Tns:Lost Contact Creating Database After Clean Installation
相關文章
- RAC安裝目錄許可權快速恢復
- ubuntu 安裝onethink沒有目錄許可權Ubuntu
- 帆軟——目錄及許可權配置
- 11gR2 GI和DB安裝目錄許可權屬主被修改後的恢復方法
- 域使用者許可權|安裝軟體
- Linux 許可權管理之目錄許可權限制Linux
- 【LIUNX】目錄或檔案許可權,許可權授予
- win10修改登錄檔沒有許可權怎麼辦 win10系統下修改登錄檔許可權的方法Win10
- Linux 目錄許可權研究Linux
- linux目錄的許可權Linux
- ORA-12547: TNS:lost contact之oracle執行檔案許可權問題Oracle
- 打包壓縮RAC oracle軟體目錄後重灌OS,解壓後目錄許可權變化Oracle
- win11解除安裝軟體提示沒有許可權
- Vue設定許可權列表目錄Vue
- win10無管理員許可權怎麼安裝軟體 win10安裝軟體提示沒有管理員許可權解決方法Win10
- 登陸vCenter Server提示沒有許可權問題Server
- 修改組策略以安裝MSI程式進行許可權升級或許可權維持
- Linux系統下如何修改檔案或目錄的許可權?Linux
- 登入失敗,提示“資料庫目錄許可權寫入不足”,可以操作設定資料庫目錄許可權為 777。資料庫
- Linux 目錄與許可權詳解Linux
- 安裝laravel許可權包Laravel
- 許可權修改命令
- Linux賬號安全——使用者登陸許可權Linux
- 後臺登入提示:”登入失敗:資料庫目錄寫入許可權不足!“資料庫
- Oracle 目錄許可權丟失故障恢復Oracle
- Lnmp 網站根目錄檔案許可權LNMP網站
- 目錄檔案有寫許可權 危險
- 16.4.目錄檔案與許可權
- nfs 掛載目錄 root 許可權不夠 ?NFS
- Linux檔案與目錄許可權概述Linux
- Oracle軟體許可權修復Oracle
- Oracle RAC啟動CRS報錯:登陸許可權問題Oracle
- 在無 sudo 許可權的 linux 伺服器上安裝軟體Linux伺服器
- PbootCMS後臺登入提示:“登入失敗:資料庫目錄寫入許可權不足!”boot資料庫
- PbootCMS後臺登入提示:”登入失敗:資料庫目錄寫入許可權不足!“boot資料庫
- ORACLE軟體克隆完成後sysdba登入提示沒有許可權Oracle
- 圖文介紹Linux chmod目錄許可權Linux
- linux許可權管理,例項: 建立共享目錄Linux