oracle rac 随笔

oracle rac随笔

查看镀锌铁时区

[ASM1]@ ht01[/u01/app/grid/CRS/install]$ cat s _ CRS config _ ht01 _ env。文本文件（textfile）

#########################################################################

#此文件可用于设置NLS _郎和坦桑尼亚环境的值

#变量和为神谕集群件和设置资源限制

#数据库进程。

#1.非线性系统(Non-Linear System)郎环境变量决定了语言和

#用于消息的字符集。例如，新值可以是

#通过设置NLS _郎=日本_日本进行配置UTF8 .

#2.可以通过将坦桑尼亚条目设置为来更改时区设置

#适当的时区名称。例如，TZ=美洲/纽约州

#3.堆栈大小、打开文件和进程数量的资源限制

#可以通过修改适当的条目来指定。

#

#除非上面或下面有记录，否则不要修改此文件

#甲骨文支持服务的方向。

#########################################################################

TZ=亚洲/上海

NLS _郎=简体中文_中国AL32UTF8 .

CRS_LIMIT_STACK=2048

CRS_LIMIT_OPENFILE=65536

CRS_LIMIT_NPROC=65536

TNS_ADMIN=

查看gpnp配置文件

[ASM1]@ ht01[/u01/app/grid/CRS/install]$ gpn工具rget

警告：某些命令行参数是默认的。结果命令行：

/u01/app/grid/bin/gpn工具。bin rget-o-

找到2个gpnp服务实例以从中获取配置文件。

对TCP ://ht 01336041861(mdns :服务： gpnp 4 eaed 9870)的获取个人资料请求_ TCP。本地的。//ht 01:41861/agent=gpnpd，cname=ht-cluster，guid=86f 8 afcc 718 befe 0 bfe 30184 eaed 9870，host=ht01，PID=29962/gpnpd h : ht01 c : ht-cluster u :86 F8 afcc 718 befe 0 bfe 30184 eaed 9877

可扩展标记语言版本='1.0 '编码=' UTF-8 ' gpnp : gpnp-Profile Version=' 1.0 ' xmlns=' http://www。网格-PNP。org/2005/11/gpnp-Profile ' xmlns : gpnp=' http://www .网格-PNP。org/2005/11/gpnp-Profile ' xmlns 3360 orcl=' http://www .神谕

pnp:HostNetwork HostName="*"gpnp:Network IP="192.168.20.0" Adapter="enp0s8" Use="public"/gpnp:Network IP="192.168.0.0" Adapter="enp0s9" Use="asm,cluster_interconnect"//gpnp:HostNetwork/gpnp:Network-Profileorcl:CSS-Profile DiscoveryString="+asm" LeaseDuration="400"/orcl:ASM-Profile 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:SignedInfods: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:Transformsds: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:Transformsds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/ds:DigestValue3NTsqEo7tvIjKOx999g0We1OlO4=/ds:DigestValue/ds:Reference/ds:SignedInfods:SignatureValueVVMFcb0Pp0Fdhai5+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-Profilegpnp:HostNetwork HostName="*"gpnp:Network IP="192.168.20.0" Adapter="enp0s8" Use="public"/gpnp:Network IP="192.168.0.0" Adapter="enp0s9" Use="asm,cluster_interconnect"//gpnp:HostNetwork/gpnp:Network-Profileorcl:CSS-Profile DiscoveryString="+asm" LeaseDuration="400"/orcl:ASM-Profile 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:SignedInfods: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:Transformsds: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:Transformsds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/ds:DigestValue3NTsqEo7tvIjKOx999g0We1OlO4=/ds:DigestValue/ds:Reference/ds:SignedInfods:SignatureValueVVMFcb0Pp0Fdhai5+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)