ORA-12700: invalid NLS parameter value (nls_numeric_characters)


bash-3.2$ sqlplus / as sysdba;
SQL*Plus: Release 11.2.0.3.0 Production on Sat Nov 2 20:27:43 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management and Real Application Testing options
SQL> select name from v$database;
NAME
---------
KBAZER
SQL>
SQL>shut immediate;
Database closed.
Database dismounted
ORACLE instance shut down
SQL> startup;
ORA-12700: invalid NLS parameter value (nls_numeric_characters)
What happened :(
SQL> startup mount pfile=’/011g/admin/KBAZER/pfile/init.ora.3192010161810;
ORACLE instance started.
Total System Global Area 6881345536
Fixed Size                  2154456 bytes
Virable Size   3758096424 byts
Database Buffers    3087007744 bytes
Redo Buffers    34086912 bytes
ORA-00059 ; maximum number of DB_FILES exceeded
It is  problem !!!!!!!!!!!!!!!!!!!!!!!
SQL>create pfile =’/011g/ora11g/product/11.1.0/db_1/dbs/spfilebackup/KBAZER.ora’ from spile=’/011g/ora11g/product/11.1.0/db_1/dbs/spfilebackup/spfileKBAZER.ora’;
File created
SQL> shut immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORA-12700: invalid NLS parameter value (nls_numeric_characters)
We got the same error!! for solutions:
SQL> startup pfile =’/011g/ora11g/product/11.1.0/db_1/dbs/spfilebackup/KBAZER.ora’
ORACLE instance started.
Total System Global Area 6881345536
Fixed Size                  2154456 bytes
Virable Size              3758096424 byts
Database Buffers    3087007744 bytes
Redo Buffers          34086912 bytes
ORA-00059 ; maximum number of DB_FILES exceeded
SQL> show parameter db_files;
NAME               TYPE                VALUE
-----------------------------------------------
Db_files         integer              200
SQL> shut immediate;
ORA-01507 database not mounted
ORACLE instance shut down.
SQL> startup pfile=’/011g/ora11g/product/11.1.0/db_1/dbs/spfilebackup/KBAZER.ora’
ORACLE instance started.
Total System Global Area   6881345536
Fixed Size                  2154456 bytes
Virable Size              3758096424 byts
Database Buffers    3087007744 bytes
Redo Buffers          34086912 bytes
Database mounted.
Database opened.
SQL>create spfile from pfile=’/011g/ora11g/product/11.1.0/db_1/dbs/spfilebackup/KBAZER.ora’
File created.
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>startup;
ORACLE instance started.
Total System Global Area   6881345536
Fixed Size                  2154456 bytes
Virable Size              3758096424 byts
Database Buffers    3087007744 bytes
Redo Buffers          34086912 bytes
Database mounted.
Database opened.

Problem solved, database started :)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: