在Suse 12.4上安裝11.2.0.4的rac執行root.sh報錯“ORA-12547: TNS:lost contact”

lhrbest發表於2020-05-07


在Suse 12.4上安裝11.2.0.4的rac執行root.sh報錯“ORA-12547: TNS:lost contact”


在節點1上執行root.sh，報錯： /u01/app/11.2.0/grid/root.sh

Performing root user operation for Oracle 11g 
The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0/grid
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
User ignored Prerequisites during installation
Installing Trace File Analyzer
Adding Clusterware entries to inittab
CRS-2672: Attempting to start 'ora.mdnsd' on 'v3erpzgd01'
CRS-2676: Start of 'ora.mdnsd' on 'v3erpzgd01' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'v3erpzgd01'
CRS-2676: Start of 'ora.gpnpd' on 'v3erpzgd01' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'v3erpzgd01'
CRS-2672: Attempting to start 'ora.gipcd' on 'v3erpzgd01'
CRS-2676: Start of 'ora.cssdmonitor' on 'v3erpzgd01' succeeded
CRS-2676: Start of 'ora.gipcd' on 'v3erpzgd01' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'v3erpzgd01'
CRS-2672: Attempting to start 'ora.diskmon' on 'v3erpzgd01'
CRS-2676: Start of 'ora.diskmon' on 'v3erpzgd01' succeeded
CRS-2676: Start of 'ora.cssd' on 'v3erpzgd01' succeeded
ASM failed to start. Check /u01/app/grid/cfgtoollogs/asmca/asmca-200507PM121627.log for details.
Configuration of ASM ... failed
see asmca logs at /u01/app/grid/cfgtoollogs/asmca for details
Did not succssfully configure and start ASM at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 6912.
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed

檢視檔案：/u01/app/grid/cfgtoollogs/asmca/asmca-200507PM121627.log，錯誤如下：

[main] [ 2020-05-07 09:50:51.837 CST ] [UsmcaLogger.logException:174]  ORA-12547: TNS:lost contact
[main] [ 2020-05-07 09:50:51.837 CST ] [UsmcaLogger.logException:175]  oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12547: TNS:lost contact
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1658)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:981)
oracle.sysman.assistants.usmca.backend.USMInstance.connectToASM(USMInstance.java:626)
oracle.sysman.assistants.usmca.backend.USMInstance.configureLocalASM(USMInstance.java:3016)
oracle.sysman.assistants.usmca.service.UsmcaService.configureLocalASM(UsmcaService.java:1049)
oracle.sysman.assistants.usmca.model.UsmcaModel.performConfigureLocalASM(UsmcaModel.java:944)
oracle.sysman.assistants.usmca.model.UsmcaModel.performOperation(UsmcaModel.java:797)
oracle.sysman.assistants.usmca.Usmca.execute(Usmca.java:174)
oracle.sysman.assistants.usmca.Usmca.main(Usmca.java:369)
[main] [ 2020-05-07 09:50:51.837 CST ] [UsmcaLogger.logInfo:143]  ASM failed to start. Check /u01/app/grid/cfgtoollogs/asmca/asmca-200507AM095050.log for details.
[main] [ 2020-05-07 09:50:51.837 CST ] [UsmcaLogger.logInfo:143]  Instance running false
[main] [ 2020-05-07 09:50:51.837 CST ] [UsmcaLogger.logInfo:143]  ASM failed to start. Check /u01/app/grid/cfgtoollogs/asmca/asmca-200507AM095050.log for details.

其實看不出來啥，總之就是不能建立ASM例項，然後去檢查ASM例項的告警日誌發現錯誤如下：

System parameters with non-default values:
  large_pool_size          = 12M
  instance_type            = "asm"
  remote_login_passwordfile= "EXCLUSIVE"
  asm_diskstring           = "/dev/oracleasm/asm-*"
  asm_power_limit          = 1
  diagnostic_dest          = "/u01/app/grid"
Cluster communication is configured to use the following interface(s) for this instance
  10.206.110.3
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Process PMON died, see its trace file
USER (ospid: 14306): terminating the instance due to error 443
Instance terminated by USER, pid = 14306
Thu May 07 12:16:34 2020
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x7F8962019640, __lll_unlock_elision()+48] [flags: 0x0, count: 1]
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.


解決： https://www.novell.com/support/kb/doc.php?id=7022289

How to disable Hardware Lock Elision

This document  (7022289) is provided subject to the  disclaimer at the end of this document.

Environment

SUSE Linux Enterprise Server 12 (SLES 12)
SUSE Linux Enterprise Server 12 Service Pack 1 (SLES 12 SP1)
SUSE Linux Enterprise Server 12 Service Pack 2 (SLES 12 SP2)
SUSE Linux Enterprise Server 12 Service Pack 3 (SLES 12 SP3)
SUSE Linux Enterprise Server 12 Service Pack 4 (SLES 12 SP4)
SUSE Linux Enterprise Server 12 Service Pack 5 (SLES 12 SP5)
SUSE Linux Enterprise Server 15 (SLES 15)
SUSE Linux Enterprise Server 15 Service Pack 1 (SLES 15 SP1)
 

Situation

Some third-party applications installed on SUSE Linux Enterprise Server, may require that the 'Hardware Lock Elision' functionality is disabled.

Resolution

Temporary solution: Add the appropriate noelision path statement to the beginning of the library load path (LD_LIBRARY_PATH) so that the noelision libraries are used in preference to any others appearing later in the path

                                  e.g.   export LD_LIBRARY_PATH=/lib64/noelision/:$LD_LIBRARY_PATH

                                  On server reboot, this change will be lost.


Permanent solution: Create file  /etc/ld.so.conf.d/noelision.conf

                                 Add the appropriate line: e.g.    /lib64/noelision

                                 After saving the noelision.conf changes, run ` ldconfig` to rebuild caches.
 

Cause

There is a bug in some Intel CPUs which does not handle the Hardware Lock Elision correctly.

Additional Information

Oracle grid software is susceptible to this CPU bug. If elision locking is not disabled on servers with such faulty CPUs, Oracle may crash during initialization.

The ' noelision' 32 bit and 64 bit libraries are found here:-

       /lib/noelision
       /lib64/noelision


NOTE: Make sure that  /etc/ld.so.conf includes the  /etc/ld.so.conf.d/ directory (default) or add the directory you want to be included (the directory where you placed the  noelision.conf file)   * it is recommended to keep everything under  /etc/ld.so.conf.d/

NOTE: The files present in the  directories listed in  /etc/ld.so.conf are applied in alpha-numerical file name order. You need to be aware of what is in each file, in each of the included directories, to make sure that the desired settings are being applied and not 'overwritten' or ignored.


 

Disclaimer

This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.






About Me

........................................................................................................................

● 本文作者：小麥苗，部分內容整理自網路，若有侵權請聯絡小麥苗刪除

● 本文在itpub、部落格園、CSDN和個人微 信公眾號（ DB寶）上有同步更新

● 本文itpub地址： http://blog.itpub.net/26736162

● 本文部落格園地址： http://www.cnblogs.com/lhrbest

● 本文CSDN地址： https://blog.csdn.net/lihuarongaini

● 本文pdf版、個人簡介及小麥苗雲盤地址： http://blog.itpub.net/26736162/viewspace-1624453/

● 資料庫筆試面試題庫及解答： http://blog.itpub.net/26736162/viewspace-2134706/

● DBA寶典今日頭條號地址： http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826

........................................................................................................................

● QQ群號： 230161599 、618766405

● 微 信群：可加我微 信，我拉大家進群，非誠勿擾

● 聯絡我請加QQ好友 （ 646634621 ），註明新增緣由

● 於 2020-05-01 06:00 ~ 2020-05-30 24:00 在西安完成

● 最新修改時間：2020-05-01 06:00 ~ 2020-05-30 24:00

● 文章內容來源於小麥苗的學習筆記，部分整理自網路，若有侵權或不當之處還請諒解

● 版權所有，歡迎分享本文，轉載請保留出處

........................................................................................................................

● 小麥苗的微店： https://weidian.com/s/793741433?wfr=c&ifr=shopdetail

● 小麥苗出版的資料庫類叢書： http://blog.itpub.net/26736162/viewspace-2142121/

● 小麥苗OCP、OCM、高可用網路班： http://blog.itpub.net/26736162/viewspace-2148098/

● 小麥苗騰訊課堂主頁： https://lhr.ke.qq.com/

........................................................................................................................

使用 微 信客戶端掃描下面的二維碼來關注小麥苗的微 信公眾號（ DB寶）及QQ群（DBA寶典）、新增小麥苗微 信， 學習最實用的資料庫技術。

........................................................................................................................

歡迎與我聯絡

 

 



來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26736162/viewspace-2690327/，如需轉載，請註明出處，否則將追究法律責任。

相關文章