LRM-00101: Unknown Parameter Name 'location' LRM-00101: Unknown Parameter Name 'va

Today in the configuration of RAC-DG, after modifying the master database parameter file can not start the RAC master database with the modified pfile, encountered a LRM-00101 error, this is a syntax error, however, no solution was found at the beginning:

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
*. Processses = 150
*. Remote_listener = 'zlm-cluster-Scan: 8080'
*. Remote_login_passwordfile = 'clusive'
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 _'
LRM-00101: Unknown Parameter Name 'valid _'
ORA-01078: Failure in Processing System Parameters
SQL>

Check the location and valid_for parameters according to the prompts. If no problem is found, check again several times. It turns out to be the above "*. log_archive_config = 'dg _ Config = (ora11rac, ora11dg) "This sentence missing half quotation marks" '". Such a subtle error is really hard to find! The Oracle error prompt does not mean that there is a problem with dg_config, but that there is a problem with location and valid_for, which has been misled for a long time. It is easy to solve the problem by finding the problem, and then re-start with pfile after adding half quotation marks:

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>

Summary: when creating or modifying a parameter file, be sure to check carefully. Sometimes there is a wrong symbol, a letter or number, it will cause a LRM-00101 syntax error.

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

By mongoon8219 chinaunix blog: http://blog.chinaunix.net/uid/24612962.html

Original content. For more information, see the link. Thank you!

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