Home » RDBMS Server » Server Administration » update sys.props$ set VALUE$='AL16UTF16' how to recovery (Oracle 11g linux)
update sys.props$ set VALUE$='AL16UTF16' how to recovery [message #318825] Thu, 08 May 2008 02:20 Go to next message
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

Re: update sys.props$ set VALUE$='AL16UTF16' how to recovery [message #318834 is a reply to message #318825] Thu, 08 May 2008 03:03 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have lost your database.
Too bad to update dictionary.
Restore from a backup.

Regards
Michel

[Updated on: Thu, 08 May 2008 03:03]

Report message to a moderator

Previous Topic: table partition
Next Topic: Database Compression
Goto Forum:
  


Current Time: Fri Dec 09 09:49:52 CST 2016

Total time taken to generate the page: 0.07157 seconds