修改asm中的sys密码
admin
2023-04-18 21:44:08
0

直接修改报ORA-01109: database not open:

[oracle@prodb2 admin]$ . oraenv
ORACLE_SID = [prodb2] ? +ASM2
[oracle@prodb2 admin]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on чǚϥ 7Ղ 6 02:24:48 2018

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> 
SQL> 
SQL> alter user sys identified by admin;
alter user sys identified by admin
                             *
ERROR at line 1:
ORA-01109: database not open

10g中修改密码需要修改密码文件:

cd $GRID_HOME/dbs

WINDOWS:

orapwd file=/database/PWD.ora password=

UNIX:

orapwd file=/dbs/orapw password=

测试:

节点2修改密码:
[oracle@prodb2 ~]$ cd $ORACLE_HOME/dbs
[oracle@prodb2 dbs]$ orapwd file=orapw+ASM2 password=oracle force=y
[oracle@prodb2 dbs]$ sqlplus sys/oracle@asm2 as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on чǚϥ 7Ղ 6 02:43:25 2018

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> 

节点1测试:
[oracle@ocm1 admin]$ sqlplus sys/oracle@asm2 as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on чǚϥ 7Ղ 6 02:45:31 2018

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show parameter remote_login_passwordfile

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

官方建议在修改密码前关闭asm实例,测试中未关闭,远程连接正常。

11g中修改密码相对简单:
single instance:


$ export ORACLE_SID=+ASM

$ asmcmd

ASMCMD> passwd sys
Enter old password (optional): 
Enter new password: ******

Cluster environment

ASMCMD> orapwusr --modify --password sys

Enter password: 
ASMCMD> exit

参考自:
How To Change ASM SYS PASSWORD ? (文档 ID 452076.1)
How to connect to ASM instance from a remote client (Oracle Net) (文档 ID 340277.1)

相关内容

热门资讯

玩家最新攻略“陕西三带开挂神器... 家人们!今天小编来为大家解答陕西三带透视挂怎么安装这个问题咨询软件客服徽9752949的挂在哪里买很...
终于明白“蜀友汇怎么装挂?”(... 网上科普关于“蜀友汇有没有挂”话题很是火热,小编也是针对蜀友汇作*弊开挂的方法以及开挂对应的知识点,...
终于懂了“推大石辅助器?”(确... 您好:推大石这款游戏可以开挂,确实是有挂的,需要了解加客服微信【9752949】很多玩家在这款游戏中...
今日重大通报“天涯麻将到底有挂... 您好:天涯麻将这款游戏可以开挂,确实是有挂的,需要了解加客服微信【4282891】很多玩家在这款游戏...
玩家分享攻略“哈灵麻将有没有挂... 家人们!今天小编来为大家解答哈灵麻将透视挂怎么安装这个问题咨询软件客服徽4282891的挂在哪里买很...
今日重大通报“川麻圈可以开挂吗... 有 亲,根据资深记者爆料川麻圈是可以开挂的,确实有挂(咨询软件无需打开直...
今日重大消息“福建麻将有没有挂... 您好:福建麻将这款游戏可以开挂,确实是有挂的,需要了解加客服微信【4282891】很多玩家在这款游戏...
【今日要闻】“经典联盟炸/金/... 有 亲,根据资深记者爆料经典联盟炸/金/花是可以开挂的,确实有挂(咨询软...
今日重大通报“微信链接牛牛真的... 家人们!今天小编来为大家解答微信链接牛牛透视挂怎么安装这个问题咨询软件客服徽9784099的挂在哪里...
今日重大消息“网易麻将究竟有挂... 有 亲,根据资深记者爆料网易麻将是可以开挂的,确实有挂(咨询软件无需打开...