After oracle modifies the character set, the database cannot be started.

After oracle modifies the character set, the database cannot be started to solve the recently modified character set experiment. The tragedy is that the database cannot be started after the modification.

SQL> alter system set nls_language = 'American 'scope = spfile; SQL> alter system set nls_territory = 'American' scope = spfile; SQL> shutdown immediate; SQL> startup

 

ORA-12700: invalid NLS parameter value (nls_territory) solution: copy the content in spfile (which I opened with editplus) to D: \ 1.txt remove the portion of nls_language and then generate spfile

(*. Nls_language = 'American '*. nls_territory = 'American') SQL> create spfile from pfile = 'd:/1.txt '; the file has been created. The SQL> startupORACLE routine has been started. Total System Global Area 612368384 bytesFixed Size 1250428 bytesVariable Size 167775108 bytesDatabase Buffers 436207616 bytesRedo Buffers 7135232 bytes

 

The database has been loaded. The database has been opened.