mounted EXCLUSIVE and not open???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: mounted EXCLUSIVE and not open???

  1. #1
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Angry


    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

  2. #2
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    Startup nomount;
    alter database mount exclusive;

    :-)

    Sergey.

  3. #3
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Angry


    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

  4. #4
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Try this

    startup restrict mount;

    Regards
    Santosh

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking 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
  •  


Click Here to Expand Forum to Full Width