update sys.props$ set VALUE$='AL16UTF16' how to recovery [message #318825] |
Thu, 08 May 2008 02:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Andrey.Zheleznyakov
Messages: 1 Registered: May 2008
|
Junior Member |
|
|
I did following in sqlplus:
CONNECT / AS SYSDBA
SHUTDOWN IMMEDIATE
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET aq_tm_processes=0;
ALTER DATABASE OPEN;
update sys.props$ set VALUE$='AL16UTF16' where name='NLS_CHARACTERSET';
commit;
update sys.props$ set VALUE$='AL32UTF8' where name='NLS_NCHAR_CHARACTERSET';
commit;
SHUTDOWN IMMEDIATE
STARTUP
I do not have any backup files=( (I'm idiot)
after restart db says following error:
Database mounted
ORA-00911: invalid character
if i do
STARTUP MOUNT
ALTER DATABASE OPEN
following:
ALTER DATABASE OPEN
*
ORA-00911: invalid character
if i do:
SELET * FROM v$log
following:
SELECT * FROM v$log
*
ORA-00911: invalid charater.
listener doesn't work too.
when i try to conneting I get:
ORA-1033
How to recovery db after this.
pls help.
[Updated on: Thu, 08 May 2008 02:21] Report message to a moderator
|
|
|
|