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>
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:
Post a Comment