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 Reply

7170

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

3883

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

4187

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

3540

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

1401

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

7936

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

3654

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

2791

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

2447

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

307

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

6964

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

7126

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

6842

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

4865

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4559

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3070

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1378

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

598

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

262

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General