直接修改报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
cd $GRID_HOME/dbs WINDOWS: 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 sysdba sql*Plus: Release 10.2.0.5.0 - Production on чǚϥ 7Ղ 6 02:43:25 2018 Copyright (c) 1982,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,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
原文链接:https://www.f2er.com/oracle/205813.html参考自:How To Change ASM SYS PASSWORD ? (文档 ID 452076.1)How to connect to ASM instance from a remote client (Oracle Net) (文档 ID 340277.1)