[20171109]简单探究文件ab_ASM_SID.dat.txt-阿里云开发者社区

开发者社区> 数据库> 正文
登录阅读全文

[20171109]简单探究文件ab_ASM_SID.dat.txt

简介: [20171109]简单探究文件ab_ASM_SID.dat.txt --//昨天看了一篇Solving Communication problems between DB and ASM instances.

[20171109]简单探究文件ab_ASM_SID.dat.txt

--//昨天看了一篇Solving Communication problems between DB and ASM instances.链接
--//http://www.toadworld.com/platforms/oracle/b/weblog/archive/2017/11/07/solving-communication-problems-between-db-and-asm-instances

--//如果意外删除这个文件会导致建立数据文件失败.其它比如文件扩展我不是很清楚,做一个简单的探究.

1.环境:
SQL> select * from v$version where rownum<=1;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

2.简单探究:

$ echo $ORACLE_SID
+ASM1

$ locate ab_+ASM1.dat
/u01/app/11.2.0/grid/dbs/ab_+ASM1.dat

--//看看那个进程打开这个文件.发现没有.
# lsof /u01/app/11.2.0/grid/dbs/ab_+ASM1.dat

--//看看这个文件类型:
$ file $(locate ab_+ASM1.dat)
/u01/app/11.2.0/grid/dbs/ab_+ASM1.dat: data

$ xxd -c 16 /u01/app/11.2.0/grid/dbs/ab_+ASM1.dat | head
0000000: 0100 0000 0400 0000 2900 0000 0200 0000  ........).......
0000010: 1a04 0000 5f5f 434c 5341 4746 575f 5459  ....__CLSAGFW_TY
0000020: 5045 5f4e 414d 453d 6f72 612e 6173 6d2e  PE_NAME=ora.asm.
0000030: 7479 7065 004f 5241 5f43 5253 5f48 4f4d  type.ORA_CRS_HOM
0000040: 453d 2f75 3031 2f61 7070 2f31 312e 322e  E=/u01/app/11.2.
0000050: 302f 6772 6964 0054 4552 4d3d 6c69 6e75  0/grid.TERM=linu
0000060: 7800 5f5f 4352 5344 5f43 4f4e 4e45 4354  x.__CRSD_CONNECT
0000070: 5f53 5452 3d28 4144 4452 4553 533d 2850  _STR=(ADDRESS=(P
0000080: 524f 544f 434f 4c3d 4950 4329 284b 4559  ROTOCOL=IPC)(KEY
0000090: 3d4f 4841 5344 5f49 5043 5f53 4f43 4b45  =OHASD_IPC_SOCKE

--//感觉像是一些参数环境变量之类的信息.

$ cat  /u01/app/11.2.0/grid/dbs/ab_+ASM1.dat | tr '\0' '\n'
)
__CLSAGFW_TYPE_NAME=ora.asm.type
ORA_CRS_HOME=/u01/app/11.2.0/grid
TERM=linux
__CRSD_CONNECT_STR=(ADDRESS=(PROTOCOL=IPC)(KEY=OHASD_IPC_SOCKET_11))
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
CRF_HOME=/u01/app/11.2.0/grid
GIPCD_PASSTHROUGH=false
__CRSD_AGENT_NAME=/u01/app/11.2.0/grid/bin/oraagent_grid
__CRSD_MSG_FRAME_VERSION=2
LD_LIBRARY_PATH=/u01/app/11.2.0/grid/lib:/etc/ORCLcluster/lib
__CLSAGENT_INCARNATION=2
CRS_LIMIT_MEMLOCK=unlimited
ORASYM=/u01/app/11.2.0/grid/bin/oraagent.bin
PATH=
runlevel=3
RUNLEVEL=3
LANGSH_SOURCED=1
PWD=/
ENV_FILE=/u01/app/11.2.0/grid/crs/install/s_crsconfig_fyhis1_env.txt
CRS_LIMIT_OPENFILE=65536
LANG=en_US
TZ=Asia/Shanghai
__IS_HASD_AGENT=TRUE
previous=N
PREVLEVEL=N
__CLSAGENT_LOG_NAME=ora.asm.type_grid
CONSOLETYPE=vt
SHLVL=2
__CLSAGENT_LOGDIR_NAME=ohasd
LD_ASSUME_KERNEL=
CRS_LIMIT_CORE=unlimited
__CLSAGENT_USER_NAME=grid
UPSTART_INSTANCE=
CRS_LSNR_STACK=10240
UPSTART_EVENTS=runlevel
UPSTART_JOB=rc
ORACLE_HOME=/u01/app/11.2.0/grid
CRS_LIMIT_STACK=2048
ORACLE_SID=+ASM1
ORA_NET2_DESC=53,56
ORACLE_SPAWNED_PROCESS=1

$ cat /u01/app/11.2.0/grid/crs/install/s_crsconfig_fyhis1_env.txt
### This file can be used to modify the NLS_LANG environment variable, which determines the charset to be used for messages.
### For example, a new charset can be configured by setting NLS_LANG=JAPANESE_JAPAN.UTF8
### Do not modify this file except to change NLS_LANG, or under the direction of Oracle Support Services

TZ=Asia/Shanghai
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
TNS_ADMIN=
ORACLE_BASE=

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享:
数据库
使用钉钉扫一扫加入圈子
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

其他文章