LRM-00101: unknown parameter name ‘location’ LRM-00101: unknown parameter name ‘va

今天在配置RAC-DG時，修改主庫參數檔案後無法用修改後的PFILE啟動RAC主要資料庫，碰到了LRM-00101錯誤，這是一個語法錯誤，但是一開始始終沒找到解決方案：

SQL> create pfile='/rmanbackup/initora11rac.ora' from spfile;

File created.

SQL> !
[oracle@zlm1 ~]$ vi /rmanbackup/initora11rac.ora 

ora11rac1.__shared_io_pool_size=0
ora11rac2.__shared_pool_size=268435456
ora11rac1.__shared_pool_size=234881024
ora11rac2.__streams_pool_size=0
ora11rac1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/ora11rac/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATA/ora11rac/controlfile/current.260.823440203','+BACKUPDG/ora11rac/controlfile/current.256.823440203'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='ora11rac'
*.db_recovery_file_dest='+BACKUPDG'
*.db_recovery_file_dest_size=4558159872
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ora11racXDB)'
ora11rac2.instance_number=2
ora11rac1.instance_number=1
*.memory_target=838860800
*.open_cursors=300
*.processes=150
*.remote_listener='zlm-cluster-scan:1521'
*.remote_login_passwordfile='exclusive'
ora11rac2.thread=2
ora11rac1.thread=1
ora11rac2.undo_tablespace='UNDOTBS2'
ora11rac1.undo_tablespace='UNDOTBS1'
*.db_unique_name='ora11rac'
*.log_archive_config='dg_config=(ora11rac,ora11dg)
*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles) db_unique_name=ora11rac'
*.log_archive_dest_2='service=ora11dg valid_for=(online_logfiles,primary_role) db_unique_name=ora11dg'
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.log_archive_format='arc_%t_%s_%r.arc'
*.fal_server=ora11dg
*.standby_file_management='auto'
*.db_file_name_convert='/u01/app/oracle/oradata/ora11dg/datafile','+DATA/ora11rac/datafile','/u01/app/oracle/oradata/ora11dg/datafile','+DATA/ora11rac/tempfile'
*.log_file_name_convert='/u01/app/oracle/oradata/ora11dg/onlinelog','+DATA/ora11rac/onlinelog','/u01/app/oracle/oradata/ora11dg/onlinelog','+BACKUPDG/ora11rac/onlinelog'

exit

SQL> startup pfile='/rmanbackup/initora11rac.ora
LRM-00101: unknown parameter name 'location'
LRM-00101: unknown parameter name 'valid_for'
LRM-00101: unknown parameter name 'valid_for'
ORA-01078: failure in processing system parameters
SQL> 

根據提示檢查location和valid_for參數，發現都沒有問題，之後又檢查了好幾遍，原來是上面的"  *.log_archive_config='dg_config=(ora11rac,ora11dg)  "這句少了半邊引號" ' "，這麼細微的錯誤，真的很難發現啊！oracle錯誤提示不說dg_config有問題，而是說location和valid_for有問題，被誤導了好久，找到問題所在，就容易解決了，加上半邊引號後重新用pfile啟動：

SQL> startup pfile='/rmanbackup/initora11rac.ora'
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> startup force
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size                  2232960 bytes
Variable Size             578817408 bytes
Database Buffers          251658240 bytes
Redo Buffers                2396160 bytes
Database mounted.
Database opened.
SQL> 

總結：在建立或修改參數檔案的時候一定要注意檢查仔細，有的時候一個符號，一個字母或數字搞錯，就會造成LRM-00101語法錯誤。

-------------------------------------------------------------

By aaron8219 Chinaunix Blog：http://blog.chinaunix.net/uid/24612962.html

原創內容，轉載請註明連結，謝謝！

http://blog.csdn.net/aaron8219/article/details/10023167