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
- Vue設定許可權列表目錄Vue
- win10無管理員許可權怎麼安裝軟體 win10安裝軟體提示沒有管理員許可權解決方法Win10
- 登陸vCenter Server提示沒有許可權問題Server
- 修改組策略以安裝MSI程式進行許可權升級或許可權維持
- Linux系統下如何修改檔案或目錄的許可權?Linux
- Linux 目錄與許可權詳解Linux
- 安裝laravel許可權包Laravel
- 許可權修改命令
- Linux賬號安全——使用者登陸許可權Linux
- Oracle 目錄許可權丟失故障恢復Oracle
- Lnmp 網站根目錄檔案許可權LNMP網站
- 目錄檔案有寫許可權 危險
- 16.4.目錄檔案與許可權
- nfs 掛載目錄 root 許可權不夠 ?NFS
- Linux檔案與目錄許可權概述Linux
- Oracle軟體許可權修復Oracle
- Oracle RAC啟動CRS報錯:登陸許可權問題Oracle
- ORACLE軟體克隆完成後sysdba登入提示沒有許可權Oracle
- 圖文介紹Linux chmod目錄許可權Linux
- linux許可權管理,例項: 建立共享目錄Linux
- Linux的檔案許可權與目錄配置Linux
- 檢視使用者的目錄操作許可權
- Oracle中常用的目錄許可權設定命令Oracle
- C#不提升自己程式的許可權實現操作登錄檔C#
- 安裝grid軟體報錯
- win10沒有足夠的許可權修改登錄檔怎麼解決Win10
- Linux下安裝Oracle軟體所在目錄LinuxOracle