-
I have done the following :
Connect to SYS.
update props$ set value$='UTF8' where name='NLS_CHARACTERSET';
update props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET';
- restart the database
However, I put a wrong value instead of UTF8 I put BIG5. Then, I got the following error. Is there a way that I can revert back? I just need to reconnect to SYS but since the database won't open, I can connect as an User. : (
SVRMGR> startup
ORACLE instance started.
Total System Global Area 36257168 bytes
Fixed Size 64912 bytes
Variable Size 19234816 bytes
Database Buffers 16777216 bytes
Redo Buffers 180224 bytes
Database mounted.
ORA-12701: CREATE DATABASE character set is not known
SVRMGR>
I got the error and the database refuses to open.
Please help and thank in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|