oracle asm密码是什么,ASM有自己的参数、密码、alert、监听文件

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;