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)
