We're here to help!

Invalid NLS Parameter Value (nls_numeric_characters)

Follow

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

Problem Details

Problem Statement

Invalid NLS Parameter Value

Applicable Error Code

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

Affected Versions

Noticed in version 6.0 

Affected Platforms

Platform Indepdent

 
Description

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]$
Solution

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

Have more questions? Submit a request

Comments