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.