| update sys.props$ set VALUE$='AL16UTF16' how to recovery [message #318825] |
Thu, 08 May 2008 02:20  |
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]
|
|
|
| Re: update sys.props$ set VALUE$='AL16UTF16' how to recovery [message #318834 is a reply to message #318825 ] |
Thu, 08 May 2008 03:03  |
Michel Cadot
Messages: 15225
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
You have lost your database.
Too bad to update dictionary.
Restore from a backup.
Regards
Michel
[Updated on: Thu, 08 May 2008 03:03]
|
|
|
]
Members
Search
Help
Register
Login
Home
