Re: NLS probleam

From: Jim Gregory <JG200024_at_NCR.com>
Date: Wed, 15 Nov 2000 14:20:02 -0500
Message-ID: <3a12e1e6@rpc1284.daytonoh.ncr.com>

The error is telling you that you are possibly running ORACLE Parallel Server and that you must mount the db in exclusive mode ( only your instance is active and no other instance can mount the db.

try : startup mount exclusive

HTH

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR
"Opinions are my own and do not reflect
  those of Keane or my clients"
Dudi Naim <yoramn_at_cti2.com> wrote in message
news:3a103451_at_news.bezeqint.net...


> Hi

>

> I need to change the NATIONAL CHARACTER SET  from US7ASCII

> to WE8ISO8859P1

>

> but when i do

>

> SQL> SHUTDOWN IMMEDIATE;

> SQL> STARTUP MOUNT;

> SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

> SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

> SQL> ALTER DATABASE OPEN;

> SQL> ALTER DATABASE  NATIONAL CHARACTER SET WE8ISO8859P1;

>

> I recived

>

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

>

> Please Help !!

>

> yoramn_at_cti2.com

>

>

>

Received on Wed Nov 15 2000 - 13:20:02 CST