-
Crazy Oracle.
I am trying to do the following:
ALTER DATABASE CHARACTER SET WE8ISO8859P1
*
ORA-01679: database must be mounted EXCLUSIVE and not open to activate
HOW do I do this?
The command I have been TRYING to use is:
"startup EXCLUSIVE mount"
I've also tried:
startup EXCLUSIVE
startup mount
startup mount EXCLUSIVE
startup nomount ...
Arrrrgh!
- Magnus
-
Startup nomount;
alter database mount exclusive;
:-)
Sergey.
-
bless you!
But now I get the following:
SVRMGR> startup nomount
ORACLE instance started.
Total System Global Area 50055600 bytes
Fixed Size 51632 bytes
Variable Size 16359424 bytes
Database Buffers 33554432 bytes
Redo Buffers 90112 bytes
SVRMGR> alter database mount exclusive;
Statement processed.
SVRMGR> ALTER DATABASE CHARACTER SET WE8ISO8859P1;
ALTER DATABASE CHARACTER SET WE8ISO8859P1
*
ORA-01679: database must be mounted EXCLUSIVE and not open to activate
SVRMGR>
why do I still get this error?>?>?
- Magnus
-
Hi
Try this
startup restrict mount;
Regards
Santosh
-
If you are trying to change the character set, do the following:
% svrmgrl
SVRMGR> connect internal
SVRMGR> shutdown immediate
SVRMGR> startup mount
SVRMGR> alter system enable restricted session;
SVRMGR> alter system set job_queue_processes=0;
SVRMGR> alter system set aq_tm_processes=0;
SVRMGR> alter database open;
SVRMGR> alter database character set WE8ISO8859P1;
SVRMGR> alter database national character set WE8ISO8859P1;
SVRMGR> shutdown immediate;
SVRMGR> startup restrict;
SVRMGR> shutdown immediate;
SVRMGR> startup
SVRMGR> shutdown immediate;
SVRMGR> startup
This procedure is outlined in http://metalink.oracle.com/metalink/...T&p_id=66320.1 and explains why the database has to be shutdown/startup so many times.
Jeff Hunter
-
you da man
god bless jeff hunter!
thanks,
Magnus
ps: the metalink link was very helpful. for some reason i am not able to query thru metalink, but I can goto links ... strange
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
|