Shulou(Shulou.com)06/01 Report--

Directly modify the newspaper 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 customers 7 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

To change the password in 10g, you need to modify the password file:

Cd $GRID_HOME/dbsWINDOWS:orapwd file=/database/PWD.ora password=UNIX:orapwd file=/dbs/orapw password=

Test:

Node 2 change password: [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 password 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 > Node 1 Test: [oracle@ocm1 admin] $sqlplus sys/oracle@asm2 as sysdbaSQL*Plus: Release 10.2.0.5.0-Production on subscription 7 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

It is officially recommended to shut down the asm instance before changing the password. It is not closed in the test and the remote connection is normal.

It is relatively easy to change the password in 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

Reference from:

How To Change ASM SYS PASSWORD? (document ID 452076.1)

How to connect to ASM instance from a remote client (Oracle Net) (document ID 340277.1)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.