1.从oracle12c 开始 RAC的密码文件被放置在ASM上
$srvctl config database -d racdb12c -a Database unique name: racdb12c Database name: racdb12c Oracle home: /oracle/app/oracle/product/12.2.0.1/db_1 Oracle user: oracle Spfile: +DGSYSTEM/RACDB12C/PARAMETERFILE/spfile.279.960749253 Password file: +DGSYSTEM/RACDB12C/PASSWORD/pwdracdb12c.267.960742987 Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: Disk Groups: DGSYSTEM,DGDATA1,DGDATA2,DGRECOVER Mount point paths: Services: Type: RAC Start concurrency: Stop concurrency: Database is enabled Database is individually enabled on nodes: Database is individually disabled on nodes: OSDBA group: dba OSOPER group: oper Database instances: racdb12c1,racdb12c2 Configured nodes: rac1,rac2 CSS critical: no CPU count: 0 Memory target: 0 Maximum memory: 0 Default network number for database services: Database is administrator managed
2.copy 密码文件到文件系统
create or replace directory source_dir as '+DGSYSTEM/RACDB12C/PASSWORD/'; create or replace directory dest_dir as '/home/oracle'; begin dbms_file_transfer.copy_file( source_directory_object => 'source_dir', source_file_name => 'pwdracdb12c.267.960742987', destination_directory_object => 'dest_dir', destination_file_name => 'orapwracdb12cdg' ); end; /
