Friday, October 20, 2017

ORA-12709 error while loading create database character set

sqlplus '/as sysdba'

SQL*Plus: Release 12.2.0.1.0 Production on Fri Oct 20 15:15:36 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 9999220736 bytes
Fixed Size                 12341968 bytes
Variable Size            1879051568 bytes
Database Buffers         8086618112 bytes
Redo Buffers               21209088 bytes
ORA-12709: error while loading create database character set










Solution :
got to /home/oracle/product/obiedb/12c/12.2.0.1/nls/data/old
[oracle@prince old]$ perl cr9idata.pl
Creating directory /home/oracle/product/obiedb/12c/12.2.0.1/nls/data/9idata ...
Copying files to /home/oracle/product/obiedb/12c/12.2.0.1/nls/data/9idata...
Copy finished.
Please reset environment variable ORA_NLS10 to /home/oracle/product/obiedb/12c/12.2.0.1/nls/data/9idata!
[oracle@prince old]$

qlplus '/as sysdba'

SQL*Plus: Release 12.2.0.1.0 Production on Fri Oct 20 15:25:07 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 9999220736 bytes
Fixed Size                 12341968 bytes
Variable Size            1879051568 bytes
Database Buffers         8086618112 bytes
Redo Buffers               21209088 bytes
Database mounted.
Database opened.
SQL>


No comments: