mounted EXCLUSIVE and not open???

[jgmagnus]

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

[pss]

Startup nomount;
alter database mount exclusive;

:-)

Sergey.

[jgmagnus]

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

[santoshym]

Hi

Try this

startup restrict mount;

Regards

[marist89]

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.

[jgmagnus]

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