oracle asm 日志,ASMuser + Beq方式读取日志无需asm密码

tnsnames.ora:

ASM_BEQ =  (DESCRIPTION

=

(ADDRESS = (PROTOCOL =

BEQ)

(PROGRAM =

/u01/app/11.2.0/grid/bin/oracle)

(ARGV0 =

oracle+ASM1)

(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS

=(PROTOCOL=BEQ)))')

(ENVS='ORACLE_HOME=/u01/app/11.2.0/grid,ORACLE_SID=+ASM1')

)

(CONNECT_DATA = (SERVICE_NAME = +ASM)(INSTANCE =

+ASM1))   )

注意：这里我配置的ASM密码为Abcd1234

第一次配置CAPTURE进程：

GGSCI

(nw3-rac1.ht8888.ht3 as ogg@orcl1) 1> view param

ext1

EXTRACT ext1EXTTRAIL ./dirdat/bj--SETENV

(ORACLE_SID="orcl1")--SETENV

(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERID ogg , PASSWORD

oggtranlogoptions asmuser sys@asm_beq, asmpassword

Abcd1234WILDCARDRESOLVE

DYNAMICDYNAMICRESOLUTIONTABLE tianbaobao.tianbaobao;

SQL> insert into

tianbaobao values (1,'lht');

1 row created.

SQL>

commit;

Commit complete.

GGSCI

(nw3-rac1.ht8888.ht3 as ogg@orcl1) 2> stats

ext1,total

Sending STATS request to EXTRACT EXT1 ...

Start of Statistics at 2015-03-01 07:14:24.

Output to ./dirdat/bj:

Extracting from TIANBAOBAO.TIANBAOBAO to

TIANBAOBAO.TIANBAOBAO:

*** Total statistics since 2015-03-01 07:13:13

*** Total

inserts

1.00 Total

updates

0.00 Total

deletes

0.00 Total

discards

0.00 Total

operations

1.00

End of Statistics.

第二次配置CAPTURE进程(密码修改为oracle):

GGSCI

(nw3-rac1.ht8888.ht3 as ogg@orcl1) 3> view param

ext1

EXTRACT ext1EXTTRAIL ./dirdat/bj--SETENV

(ORACLE_SID="orcl1")--SETENV

(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERID ogg , PASSWORD

oggtranlogoptions asmuser sys@asm_beq, asmpassword

oracleWILDCARDRESOLVE

DYNAMICDYNAMICRESOLUTIONTABLE tianbaobao.tianbaobao;

SQL> update tianbaobao

set name='goldengate' where id=3;

1 row updated.

SQL>

commit;

Commit complete.

GGSCI

(nw3-rac1.ht8888.ht3 as ogg@orcl1) 4> stats

ext1,total

Sending STATS request to EXTRACT EXT1 ...

Start of Statistics at 2015-03-01 07:23:19.

Output to ./dirdat/bj:

Extracting from TIANBAOBAO.TIANBAOBAO to

TIANBAOBAO.TIANBAOBAO:

*** Total statistics since 2015-03-01 07:23:08

*** Total

inserts

0.00 Total

updates

1.00 Total

deletes

0.00 Total

discards

0.00 Total

operations

1.00

End of Statistics.

第三次配置CAPTURE进程(密码修改为aaaaaaaa):

GGSCI

(nw3-rac1.ht8888.ht3 as ogg@orcl1) 5> view param

ext1

EXTRACT ext1EXTTRAIL ./dirdat/bj--SETENV

(ORACLE_SID="orcl1")--SETENV

(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERID ogg , PASSWORD

oggtranlogoptions asmuser sys@asm_beq, asmpassword

aaaaaaaaWILDCARDRESOLVE

DYNAMICDYNAMICRESOLUTIONTABLE tianbaobao.tianbaobao;

SQL> delete

tianbaobao where id=1;

1 row deleted.

SQL>

commit;

Commit complete.

GGSCI

(nw3-rac1.ht8888.ht3 as ogg@orcl1) 6> stats

ext1,total

Sending STATS request to EXTRACT EXT1 ...

Start of Statistics at 2015-03-01 07:30:37.

Output to ./dirdat/bj:

Extracting from TIANBAOBAO.TIANBAOBAO to

TIANBAOBAO.TIANBAOBAO:

*** Total statistics since 2015-03-01 07:30:12

*** Total

inserts

0.00 Total

updates

0.00 Total

deletes

1.00 Total

discards

0.00 Total

operations

1.00

End of Statistics.

第四次配置CAPTURE进程(不设置密码):

GGSCI

(nw3-rac1.ht8888.ht3 as ogg@orcl1) 7> view param

ext1

EXTRACT ext1EXTTRAIL ./dirdat/bj--SETENV

(ORACLE_SID="orcl1")--SETENV

(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERID ogg , PASSWORD

oggtranlogoptions

asmuser sys@asm_beqWILDCARDRESOLVE

DYNAMICDYNAMICRESOLUTIONTABLE tianbaobao.tianbaobao;

GGSCI

(nw3-rac1.ht8888.ht3 as ogg@orcl1) 8> start

ext1

Sending START request to MANAGER ...EXTRACT EXT1 starting

GGSCI

(nw3-rac1.ht8888.ht3 as ogg@orcl1) 9> info

all

Program

Status

Group

Lag at Chkpt  Time Since Chkpt

MANAGER

RUNNING

EXTRACT

STOPPED

EXT1

00:00:00

00:00:30

EXTRACT

STOPPED

PMP1

00:00:00

00:49:05

GGSCI

(nw3-rac1.ht8888.ht3 as ogg@orcl1) 10> view report

ext1

2015-03-01 07:49:02

ERROR

OGG-00868  Establishing ASM session for login user

sys: (1005) ORA-01005: null password given; logon denied.

第五次配置CAPTURE进程(密码为空):

GGSCI

(nw3-rac1.ht8888.ht3 as ogg@orcl1) 11> view param

ext1

EXTRACT ext1EXTTRAIL ./dirdat/bj--SETENV

(ORACLE_SID="orcl1")--SETENV

(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERID ogg , PASSWORD

oggtranlogoptions

asmuser sys@asm_beq, asmpassword WILDCARDRESOLVE

DYNAMICDYNAMICRESOLUTIONTABLE tianbaobao.tianbaobao;

GGSCI

(nw3-rac1.ht8888.ht3 as ogg@orcl1) 12> view report

ext1

2015-03-01 07:51:55

ERROR

OGG-00303  Missing ASMPASSWORD specifier for

TRANLOGOPTION.​

总结：使用ASMuser +

Beq方式，ASM密码可以随意设置都可以成功读取日志，由于GG语法要求密码不可不写、不可为空。