Error changing Character Set

M Mueller

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_PROCESSES=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
mm******@lanvision.com

Jul 19 '05 #1

Subscribe Post Reply

7166

Frank

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_PROCESSES=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
mm******@lanvision.com

Are you sure? The last two commands seem reversed; you definitly open
your database before changing the characterset
--
Regards, Frank van Bortel

Jul 19 '05 #2

Similar topics

Changing KeyCode in OnKeyDown

by: Z | last post by:

I have sub-classed the TextBox. In its OnKeyDown event I can intercept key strokes, examine them, etc. When I get a certain keycode (e.g., 'A') I want to change it to another unicode key from a...

.NET Framework

Why code completion and early error checking are needed

by: Steven T. Hatton | last post by:

Some people have suggested the desire for code completion and refined edit-time error detection are an indication of incompetence on the part of the programmer who wants such features. ...

C / C++

C compling Error on IBM 390

by: shiling zhang | last post by:

I have a C program that is complied fine under DOS and UNIX. However, the same C program has the following compling error under IBM 390. TIA. ...

C / C++

Changing scripts in a RichTextBox

by: Bruce Wolfe | last post by:

I have a RichTextBox populated with characters that include a character of a script other than the default. When I try to paste a Unicode character into the RichTextBox downstream of that character...

C# / C Sharp

Convert.DateTime Error in .Net 2.0

by: Me | last post by:

Hi all I am getting a really bizzare error on when I convert a string into a datetime: The code is : DateTime dt1 = Convert.ToDateTime("10 Sep 2005"); Console.WriteLine(dt1.Year);

C# / C Sharp

Inheritance error: class Foo has no attribute "bar"

by: crystalattice | last post by:

I've finally figured out the basics of OOP; I've created a basic character creation class for my game and it works reasonably well. Now that I'm trying to build a subclass that has methods to...

Python

Error in scanf implementation or error in example in standard?

by: Simon Biber | last post by:

The following Example 3 is given in the 1999 C standard for the function fscanf: I have tested several implementations and none of them get the last case right. In no case does fscanf return 0...

C / C++

Confused with error using ofstream

by: rEvolution27 | last post by:

I'm a c++ newbie here, trying out some stuff and when I try to compile this: void create() { char name; cout << "Creating a new timetable /n Please type a name for this timetable"; cin >name;...

C / C++

Error changing Character Set

by: M Mueller | last post by:

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...

Oracle Database

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing