ASM ORA-01031: insufficient privileges.

when startup goldengate extract processes,  following errors showed in ggserr.log

2011-06-16 23:24:47  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, extgrp1.prm:  Establishing ASM session for login user SYS: (1031) ORA-01031: insufficient privileges.
2011-06-16 23:24:47  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extgrp1.prm:  PROCESS ABENDING.
2011-06-16 23:24:47  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, extgrp2.prm:  Establishing ASM session for login user SYS: (1031) ORA-01031: insufficient privileges.
2011-06-16 23:24:47  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extgrp2.prm:  PROCESS ABENDING.
2011-06-16 23:24:47  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, extgrp3.prm:  Establishing ASM session for login user SYS: (1031) ORA-01031: insufficient privileges.
2011-06-16 23:24:47  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extgrp3.prm:  PROCESS ABENDING.

try to login with sys as asm, same error

bash-3.00$ sqlplus sys/passwd111 as sysasm

SQL*Plus: Release 11.2.0.2.0 Production on Thu Jun 16 23:25:45 2011

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges

 

google , maybe caused by 11g new feature, about ASM

http://www.dba-oracle.com/t_11g_new_sysasm_role.htm
There is a new column in v$pwfile_users for the sysasm privilege:

SYS AS SYSDBA @ orcl11 SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS
—————————— —– —– —–
SYS                            TRUE  TRUE  FALSE

% Add a user to the password file by granting sysasm privileges.

bash-3.00$ orapwd file=orapw+ASM1 entries=20 password=welcome1
bash-3.00$ ls
ab_+ASM1.dat  hc_+ASM1.dat  init.ora  orapw+ASM1
bash-3.00$ sql

SQL*Plus: Release 11.2.0.2.0 Production on Thu Jun 16 23:28:57 2011

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS
—————————— —– —– —–
SYS                            TRUE  TRUE  FALSE

SQL> grant sysasm to sys;

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS
—————————— —– —– —–
SYS                            TRUE  TRUE  TRUE

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – Production
With the Real Application Clusters and Automatic Storage Management options

try again, goldengate extract startup successfully.

发表评论

电子邮件地址不会被公开。 必填项已用*标注