Error changing Character Set

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • M Mueller
    #1

    Error changing Character Set

    OS - Windows NT 4.0 Enterprise Edition
    DB Version - 8.1.7.4.1

    When trying to change the Character Set from US7ASCII to WE8MSWIN1252,
    we complete the following steps from SVRMGR, connected as internal:

    SHUTDOWN IMMEDIATE;
    STARTUP MOUNT EXCLUSIVE;
    ALTER SYSTEM ENABLE RESTRICTED SESSION;
    ALTER SYSTEM SET JOB_QUEUE_PROCE SSES=0;
    ALTER SYSTEM SET AQ_TM_PROCESSES =0;
    ALTER DATABASE OPEN;
    ALTER DATABASE CHARACTER SET WE8MSWIN1252;

    Here we receive the following oracle error:

    ORA-01679: database must be mounted EXCLUSIVE and not open to activate

    The strange part is that this has worked on two other database
    servers. One is the same Oracle version, but on Windows 2000 Advanced
    Server. The other database is the same Oracle version and same
    operating system.

    Any thoughts?

    Thanks in advance,
    Melissa Mueller
    mmueller@lanvis ion.com
    Tags: None
    • Frank
      #2
      Re: Error changing Character Set

      M Mueller wrote:
      OS - Windows NT 4.0 Enterprise Edition
      DB Version - 8.1.7.4.1
      >
      When trying to change the Character Set from US7ASCII to WE8MSWIN1252,
      we complete the following steps from SVRMGR, connected as internal:
      >
      SHUTDOWN IMMEDIATE;
      STARTUP MOUNT EXCLUSIVE;
      ALTER SYSTEM ENABLE RESTRICTED SESSION;
      ALTER SYSTEM SET JOB_QUEUE_PROCE SSES=0;
      ALTER SYSTEM SET AQ_TM_PROCESSES =0;
      ALTER DATABASE OPEN;
      ALTER DATABASE CHARACTER SET WE8MSWIN1252;
      >
      Here we receive the following oracle error:
      >
      ORA-01679: database must be mounted EXCLUSIVE and not open to activate
      >
      The strange part is that this has worked on two other database
      servers. One is the same Oracle version, but on Windows 2000 Advanced
      Server. The other database is the same Oracle version and same
      operating system.
      >
      Any thoughts?
      >
      Thanks in advance,
      Melissa Mueller
      mmueller@lanvis ion.com
      Are you sure? The last two commands seem reversed; you definitly open
      your database before changing the characterset
      --
      Regards, Frank van Bortel

        Comment

        Previous template Next
        Working...