Two pcservers, one storage, win2003, oracle11g, and Rose ha
ORACLE_HOME is on the local hard disk, and oracle db is on the Storage
Spfile + Sid. ora is used on the local disk for storage as init + Sid. ora. The content in init + Sid. ora is spfile = 'Storage/spfile + Sid. ora'
By default, ORACLE_HOME under the local hard disk on both machines has a password file (PWD + Sid. ora ),
This password file can be stored to adapt to the following situations:
1. Changed the Sys password on the machine that provided the service.
2. Shut down the machine providing services
3. A new sys password can also be read when a sleeping machine takes over the service.
The process is as follows: (the process must be completed on two machines respectively)
1. Add keys and corresponding key values to the Registry
Under HKEY_LOCAL_MACHINE/software/Oracle/key_oradb11g_home1
Add a key of the ora_oracle_pwfile character type. The corresponding key value is H:/pwdoracle. ora.
2. Move the password file from the default location to the H drive
3. Change the password for testing
Microsoft Windows [version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:/Documents and Settings/Administrator> sqlplus/As sysdba
SQL * Plus: Release 11.2.0.1.0 production on Sunday December 12 13:33:36 2010
Copyright (c) 1982,201 0, Oracle. All rights reserved.
Connect:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, data mining and real application testing options
SQL> alter user SYS identified by aaaaaa;
The user has changed.
SQL> alter user SYS identified by aaaaaa;
The user has changed.
SQL> host dir H :/
The volume in drive H is a new volume
The serial number of the volume is the D850-9611
H:/directory
<Dir> app
<Dir> Archive
<Dir> archivelog
904,704 msdia80.dll
<Dir> Oracle
1,536 pwdoracle. ora
2 files in 906,240 bytes
4 directories, 2,394,996,736 available bytes
SQL>Host date
Current date: Sunday
Enter a new date: (year, month, day)
SQL> host time
Time: 13:35:55. 07
Enter the new time:
SQL>
Summary:
1. Bug 08
:
Password files are privileged users, that is, the sleeping machine does not affect your applications.
Windows systems can modify the Registry Linux UX, and other systems can link
Search for the ora_sid_pwfile parameter value in the System Registration Library (which is the full path name of the password file); if not found, search for the ora_pwfile parameter value; if not found, use the default value ORACLE_HOME \ database \ pwdsid. ora;
2. Similar win registry keys (or Linux environment variables) and tns_admin are used to indicate the directory where the tnsnames. ora file is located.