gi的参数文件
/u01/app/11.2.0/grid/dbs/init.ora
但是里面的东西不对，因为这个不是asm真正使用的pfile

gi的密码文件
/u01/app/11.2.0/grid/dbs/orapw+ASM

gi的alert文件
/u01/app/grid/diag/asm/+asm/+ASM2/trace/

sqlplus / as sysasm
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/plmdb-cluster/asmparameterfile/registry.253.947607045

ASM的SPFIE不能直接cp出来
ASMCMD> cp +DATA/plmdb-cluster/asmparameterfile/registry.253.947607045 /home/grid/
ORA-19505: failed to identify file "+DATA/plmdb-cluster/asmparameterfile/registry.253.947607045"
ORA-17503: ksfdopn:2 Failed to open file +DATA/plmdb-cluster/asmparameterfile/registry.253.947607045
ORA-15308: could not access ASM SPFILE in RDBMS instance

sqlplus / as sysasm
SQL> create pfile='/home/grid/pfile' from spfile;
cat /home/grid/pfile
+ASM2.asm_diskgroups='ARCH'#Manual Mount
+ASM1.asm_diskgroups='ARCH'#Manual Mount
*.asm_diskstring='/dev/plm_db_*'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

ASM也有自己的alert文件
sqlplus / as sysasm
SQL> show parameter user_dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest string /u01/app/grid/diag/asm/+asm/+ASM2/trace

OCM考试的时候自己创建了ASM的listener、pfile、passwd文件

oracle用户关掉监听
lsnrctl stop listener
lsnrctl stop lsnr2

grid配置监听，使用oracle用户下的监听文件
/u01/app/11.2.0/grid/bin/srvctl add listener -l listener -p 1521 -o /u01/app/oracle/product/11.2.0/dbhome_1
/u01/app/11.2.0/grid/bin/srvctl add listener -l lsnr2 -p 1526 -o /u01/app/oracle/product/11.2.0/dbhome_1
/u01/app/11.2.0/grid/bin/srvctl start listener -l listener
/u01/app/11.2.0/grid/bin/srvctl start listener -l lsnr2

grid用户配置参数文件
cd /u01/app/11.2.0/grid/dbs
vi init+ASM.ora
instance_type=ASM

grid用户创建密码文件
orapwd file=orapw+ASM password=oracle

sqlplus / as sysasm
startup nomount

CREATE DISKGROUP dg01 EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disks/DISK1';
create diskgroup fra normal redundancy disk 'ORCL:DISK1', 'ORCL:DISL2';
如果失败，则alter system set asm_diskstring='/dev/oracleasm/disks/'否则下面asmcmd lsdsk --candidate显示不出磁盘组
alter diskgroup fra mount;

ITPub博客

ASM有自己的参数、密码、alert、监听文件

最新文章