栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 系统运维 > 运维 > Linux

11g rac赋予sys对sysasm的权限,默认无权限,修改asm密码

Linux 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

11g rac赋予sys对sysasm的权限,默认无权限,修改asm密码

ASMCMD> orapwusr --modify --password sys

Enter password: ******jycjyc
ASMCMD> exit

[root@rac1 ~]# su - grid
Last login: Tue Oct 12 15:52:27 CST 2021 on pts/0
[grid@rac1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 12 15:56:17 2021

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select * from v$pwfile_users;

USERNAME                                                     SYSDBA
------------------------------------------------------------ ----------
SYSOPER    SYSASM
---------- ----------
SYS                                                          TRUE
TRUE       FALSE

ASMSNMP                                                      TRUE
FALSE      FALSE


SQL> grant sysasm to sys;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac1 ~]$ sqlplus sys/jyc as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 12 15:56:48 2021

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

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: ^C
[grid@rac1 ~]$ sqlplus sys/jycjyc as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 12 15:56:55 2021

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

[grid@rac1 ~]$ sqlplus sys/jycjyc as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 12 16:00:10 2021

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> set line 160
SQL> select * from v$pwfile_users;

USERNAME                                                     SYSDBA     SYSOPER    SYSASM
------------------------------------------------------------ ---------- ---------- ----------
SYS                                                          TRUE       TRUE       TRUE
ASMSNMP                                                      TRUE       FALSE      FALSE

SQL> grant sysasm to ASMSNMP;

Grant succeeded.

SQL> select * from v$pwfile_users;

USERNAME                                                     SYSDBA     SYSOPER    SYSASM
------------------------------------------------------------ ---------- ---------- ----------
SYS                                                          TRUE       TRUE       TRUE
ASMSNMP                                                      TRUE       FALSE      TRUE

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac1 ~]$ sqlplus asmsnmp/jyc as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 12 16:01:03 2021

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

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: ^C^[[A
[grid@rac1 ~]$ sqlplus asmsnmp/jycjyc as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 12 16:01:10 2021

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

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: ^C
[grid@rac1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 12 16:01:19 2021

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> alter user ASMSNMP identified by jyc;

User altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac1 ~]$ sqlplus asmsnmp/jyc as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 12 16:01:44 2021

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select * from v$pwfile_users;

USERNAME                                                     SYSDBA
------------------------------------------------------------ ----------
SYSOPER    SYSASM
---------- ----------
SYS                                                          TRUE
TRUE       TRUE

ASMSNMP                                                      TRUE
FALSE      TRUE


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac1 ~]$ ssh rac2
Last login: Tue Oct 12 15:35:43 2021
[grid@rac2 ~]$ sqlplus asmsnmp/jyc as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 12 16:02:18 2021

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select * from v$pwfile_users;

USERNAME                                                     SYSDBA
------------------------------------------------------------ ----------
SYSOPER    SYSASM
---------- ----------
SYS                                                          TRUE
TRUE       TRUE

ASMSNMP                                                      TRUE
FALSE      TRUE


SQL> 
SQL> exit

其它参考:

11g修改asm密码_sqlora的专栏-CSDN博客

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/320518.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号