Tuesday, September 8, 2015

12c ASMSNMP user creation in RAC

You need ASMSNMP user to configure the targets in Grid Control Monitoring. Below are the step by step creation of ASMSNMP user creation in 12c in RAC.

#########################
Check for the ASMSNMP user
#########################

[grid@Sajidserver01 ~]$ asmcmd

ASMCMD> lspwusr
Username sysdba sysoper sysasm
     SYS   TRUE    TRUE  FALSE


[grid@Sajidserver01 ~]$ sqlplus /as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Tue Sep 8 10:04:41 2015

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SYS@+ASM1>select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM     CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS                            TRUE  TRUE  FALSE FALSE FALSE FALSE          0


#############################
Create pwd file in grid home
#############################
[grid@Sajidserver01 ~]$ cd $ORACLE_HOME/dbs
{grid@Sajidserver01 dbs]$ pwd
/usr/app/12.1.0/grid/dbs
[grid@Sajidserver01 dbs]$ ls -ltr

[grid@Sajidserver01 dbs]$ orapwd file=/usr/app/12.1.0/grid/dbs/orapw+ASM password=<ur pwd>

[grid@Sajidserver01 dbs]$ ls -ltr

-rw-r----- 1 grid oinstall   7680 Sep  8 10:09 orapw+ASM


##############################################################################

Note the points on pwd file management in ASM

If there are two nodes with +ASM1 running on node 1 and +ASM2 running on node2.

— Pre 11gR2 —
Password file on Node1: orapw+ASM1
Password file on Node2: orapw+ASM2

— 12cR2 or Post 11gR2 —
Password file on Node1: orapw+ASM
Password file on Node2: orapw+ASM

###############################################################################

Copy the file across the nodes (As configured in cluster)

[grid@Sajidserver01 dbs]$ scp orapw+ASM Sajidserver02:/usr/app/12.1.0/grid/dbs/

orapw+ASM                                                                                                                  100% 7680     7.5KB/s   00:00

[grid@Sajidserver01 dbs]$ sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Tue Sep 8 10:11:55 2015

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SYS@+ASM1>create user asmsnmp identified by <ur pwd>;

User created.

SYS@+ASM1>grant sysdba to asmsnmp;

Grant succeeded.

SYS@+ASM1>select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM     CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS                            TRUE  TRUE  FALSE FALSE FALSE FALSE          0
ASMSNMP                        TRUE  FALSE FALSE FALSE FALSE FALSE          0

SYS@+ASM1>show parameter pass;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE

[grid@Sajidserver01 dbs]$ asmcmd

ASMCMD> lspwusr
Username sysdba sysoper sysasm
     SYS   TRUE    TRUE  FALSE
 ASMSNMP   TRUE   FALSE  FALSE

#######################
Check You Connection
#######################

[grid@Sajidserver01 dbs]$ sqlplus asmsnmp as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Sep 8 10:13:49 2015

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

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options


No comments:

Post a Comment