修改asm中的sys密码
直接修改报ORA-01109: database not open:
[oracle@prodb2 admin]$ . oraenvORACLE_SID = [prodb2] ? +ASM2[oracle@prodb2 admin]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on чǚϥ 7Ղ 6 02:24:48 2018Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> 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/dbsWINDOWS:orapwd file=<ORACLE_HOME>/database/PWD<SID>.ora password=<sys_password>UNIX:orapwd file=<ORACLE_HOME>/dbs/orapw<SID> password=<sys_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 sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on чǚϥ 7Ղ 6 02:43:25 2018Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> 节点1测试:[oracle@ocm1 admin]$ sqlplus sys/oracle@asm2 as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on чǚϥ 7Ղ 6 02:45:31 2018Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> show parameter remote_login_passwordfileNAME TYPE VALUE------------------------------------ ---------------------- ------------------------------remote_login_passwordfile string EXCLUSIVE
官方建议在修改密码前关闭asm实例,测试中未关闭,远程连接正常。
11g中修改密码相对简单:
single instance:
$ export ORACLE_SID=+ASM$ asmcmdASMCMD> passwd sysEnter old password (optional): Enter new password: ******
Cluster environment
ASMCMD> orapwusr --modify --password sysEnter 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)
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。