oracle rac 随笔

查看gi时区

[+ASM1]@ht01[/u01/app/grid/crs/install]$cat s_crsconfig_ht01_env.txt
#########################################################################
#This file can be used to set values for the NLS_LANG and TZ environment
#variables and to set resource limits for Oracle Clusterware and
#Database processes.
#1. The NLS_LANG environment variable determines the language and
#   characterset used for messages. For example, a new value can be
#   configured by setting NLS_LANG=JAPANESE_JAPAN.UTF8
#2. The Time zone setting can be changed by setting the TZ entry to
#   the appropriate time zone name. For example, TZ=America/New_York
#3. Resource limits for stack size, open files and number of processes
#   can be specified by modifying the appropriate entries.
#
#Do not modify this file except as documented above or under the
#direction of Oracle Support Services.
#########################################################################
TZ=Asia/Shanghai
NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8
CRS_LIMIT_STACK=2048
CRS_LIMIT_OPENFILE=65536
CRS_LIMIT_NPROC=65536
TNS_ADMIN=

  查看gpnp配置文件

[+ASM1]@ht01[/u01/app/grid/crs/install]$gpnptool rget
Warning: some command line parameters were defaulted. Resulting command line: 
         /u01/app/grid/bin/gpnptool.bin rget -o-


Found 2 gpnp service instance(s) to rget profile from.

get-profile request to tcp://ht01:41861 (mdns:service:gpnp4eaed9870._tcp.local.://ht01:41861/agent=gpnpd,cname=ht-cluster,guid=86f8afcc718befe0bfe30184eaed9870,host=ht01,pid=29962/gpnpd h:ht01 c:ht-cluster u:86f8afcc718befe0bfe30184eaed9870):

<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="5" ClusterUId="86f8afcc718befe0bfe30184eaed9870" ClusterName="ht-cluster" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" IP="192.168.20.0" Adapter="enp0s8" Use="public"/><gpnp:Network id="net2" IP="192.168.0.0" Adapter="enp0s9" Use="asm,cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="/dev/asm*" SPFile="+OCR/ht-cluster/ASMPARAMETERFILE/registry.253.1066809153" Mode="remote" Extended="false"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>3NTsqEo7tvIjKOx999g0We1OlO4=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>VVMFcb0Pp0Fdhai5+MhuZtNbGHUKljcoEmy5GoDYP7JwkZjZDoXgilVuviZgEHZBfvY3OzGYefUUgU80DKD14hLDa0RfoXiJDkmWPcg6GkU8y5sah/F+n1X00v2m9YQTH1FqwUprE3/G6i3/jAOc7VJ9STos44WE+z7Q6TQuCPA=</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>
Success.

get-profile request to tcp://ht02:28571 (mdns:service:gpnp4eaed9870._tcp.local.://ht02:28571/agent=gpnpd,cname=ht-cluster,guid=86f8afcc718befe0bfe30184eaed9870,host=ht02,pid=3072/gpnpd h:ht02 c:ht-cluster u:86f8afcc718befe0bfe30184eaed9870):

<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="5" ClusterUId="86f8afcc718befe0bfe30184eaed9870" ClusterName="ht-cluster" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" IP="192.168.20.0" Adapter="enp0s8" Use="public"/><gpnp:Network id="net2" IP="192.168.0.0" Adapter="enp0s9" Use="asm,cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="/dev/asm*" SPFile="+OCR/ht-cluster/ASMPARAMETERFILE/registry.253.1066809153" Mode="remote" Extended="false"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>3NTsqEo7tvIjKOx999g0We1OlO4=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>VVMFcb0Pp0Fdhai5+MhuZtNbGHUKljcoEmy5GoDYP7JwkZjZDoXgilVuviZgEHZBfvY3OzGYefUUgU80DKD14hLDa0RfoXiJDkmWPcg6GkU8y5sah/F+n1X00v2m9YQTH1FqwUprE3/G6i3/jAOc7VJ9STos44WE+z7Q6TQuCPA=</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>
Success.

  oracle 文件权限对比

Script to capture and restore file permission in a directory (for eg. ORACLE_HOME) (Doc ID 1515018.1)

诊断 Grid Infrastructure 启动问题 (Doc ID 1623340.1)

gipcd not coming up (Doc ID 2034669.1)

11g rac 安装时遇到错误

grid root.sh ohasd 服务启动不起来   检查/var/tmp/.oracle,这里可以偷下懒  直接运行/u01/app/grid/network/install/sqlnet/setowner.sh

oracle 安装软件 ins_emagent.mk报错,参考mos error in invoking target 'agent nmhs' of make file ins_emagent.mk while installing Oracle 11.2.0.4 on Linux (Doc ID 2299494.1)

原文地址:https://www.cnblogs.com/omsql/p/15700245.html