We're here to help!

 This Articles helps in resolving Invalid Parameter issues in the SPFILE due to missing escape sequences.

Problem Details

invalid NLS parameter value (nls_numeric_characters) Dbvisit Standby
terminated.Return code = 433(Tracefile required if contacting Dbvisit Standby
support: /usr/tmp/27454_dbv_functions_DEV_201306071652.trc (server:oelinux1))

Dbvisit Standby terminated.
Return code = 177

While performing Step 4 - Creating a standby database, I got the below error :

Transfer /u02/oracle/DEV/data/a_txn_ind03.dbf to host oelinux1:/u02/oracle/DEV/data/a_txn_ind03.dbf ...
Transfer /u02/oracle/DEV/data/a_txn_ind04.dbf to host oelinux1:/u02/oracle/DEV/data/a_txn_ind04.dbf ...
Transfer /u02/oracle/DEV/data/a_txn_ind05.dbf to host oelinux1:/u02/oracle/DEV/data/a_txn_ind05.dbf ...
Transfer /u02/oracle/DEV/data/a_ref02.dbf to host oelinux1:/u02/oracle/DEV/data/a_ref02.dbf ...
Shutting down standby database on oelinux1...
Standby database DEV on oelinux1 shutdown.

Remote pfile /u02/oracle/DEV/11.2.0/dbs/init.ora backed as
/u02/oracle/DEV/11.2.0/dbs/init.ora.201306071652.
Remote pfile /u02/oracle/DEV/11.2.0/dbs/init.ora deleted.
Spfile created on remote server.

Restoring standby control files...
201306071600 - Remote execution error on oelinux1.
Starting Standby Database DEV...201306071652 - SQL> SQL> SQL> SQL> ORA-12700:
invalid NLS parameter value (nls_numeric_characters) Dbvisit Standby
terminated.Return code = 433(Tracefile required if contacting Dbvisit Standby
support: /usr/tmp/27454_dbv_functions_DEV_201306071652.trc (server:oelinux1))

Dbvisit Standby terminated.
Return code = 177

(Tracefile required if contacting Dbvisit Standby support:
/usr/tmp/9410_dbvisit_setup_csd_DEV_201306071600.trc (server:ebs))
[oradev@ebs standby]$

Dbvisit Standby treats commas in oracle database parameter values as a string separator, rather than as a part of the string itself. For example, a parameter control_files may contain several control file names, separated by commas. When creating a standby pfile or spfile, Dbvisit Standby splits the value of the control_files parameter using a comma as a separator, and encloses each name in quotes.

To treat a comma as a part of the value string, each comma must be escaped by a backslash. In your case a parameter nls_numeric_characters may be set to ., on the primary. When creating a standby, a list of primary database parameters is displayed, so you can edit-modify them for standby if required. The parameter nls_numeric_characters will be displayed with a value .,

You need to edit this parameter and change its value to* .\, (without quotes), before proceeding further with creating of the standby. This way Dbvisit Standby will treat this comma as a part of the parameter value, and will place it in the standby spfile with a value ., *

Arjen Visser June 08, 2013 00:44