Problems starting database

Hi,

Look at this,

ORA-12705 invalid or unknown NLS parameter value specified

Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.

Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION command, see Oracle8i SQL Reference.

Check it out

Bijoy

Where can i check for the ALTER SESSION command or NLS_LANG and where do i make changes to them ?

You can specifically set it up in the init<sid>.ora file -

NLS_LANGUAGE='AMERICAN'

and also set the environment variable in windows for NLS_LANG

NLS_LANG to the value equal to American_America.WE8ISO8859P1


Here is some more info -

NLS_LANG Parameters
Oracle8i for Windows NT provides NLS that enables users to interact with a database in their own language, as defined by the NLS_LANG parameter. When you install Oracle8i for Windows NT, the NLS_LANG parameter is registered by the Net8 Client installation script.

The default value of the NLS_LANG parameter at installation is either that of the existing NLS_LANG parameter of the currently selected Oracle home, or of the default language of the operating system. The default language and NLS_LANG value mappings are listed under "Commonly Used Values for NLS_LANG".

The NLS_LANG parameter is stored in the registry under the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID\NLS_LANG subkey, where ID is the unique number identifying the Oracle home.

The NLS_LANG parameter uses the following format:

NLS_LANG = LANGUAGE_TERRITORY.CHARACTER_SET

where:

LANGUAGE
 Specifies the language and conventions for displaying messages, day name, and month name.
 
TERRITORY
 Specifies the territory and conventions for calculating week and day numbers.
 
CHARACTER_SET
 Controls the character set used for displaying messages.
 

Bijoy

Hi,

first to know U don't need to have database started to connect with sqlplus version 8i. just type

sqlplus /nolog

and it's ok. :-)

for NLS_LANG just set this as enviromental variable. A lot of possibilities. One is to say in command line:

set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

than start sqlplus as I mention above and everything should be ok. U could even then say

connect system....

enjoy :-)

best regards,
Marius Nicoras

Hi,

i changed the NLS_LANG in the registry as suggested, but now there's another problem. When i click on start database, i get the mesage "Oracle 8i Instance Started" and then "ORA-205 Cannot mount database". What's wrong now?

Hi Mario,

can U take a look in the alert log file where Oracle write a detailed information regarding starting up/shuting down and others... Location of the file is written in your init<sid>.ora file at parameter background_dump_dest. So take a look and in case you cannot figure out why then post some lines from that file...

best regards,
Marius Nicoras

Hi,
it seems like control01.ctl is missing...

ALTER DATABASE MOUNT EXCLUSIVE
Wed Nov 14 23:46:00 2001
ORA-00202: controlfile: 'e:\Oracle\oradata\testdb\control01.ctl'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Wed Nov 14 23:46:00 2001
ORA-205 signalled during: ALTER DATABASE MOUNT EXCLUSIVE...
archiving is disabled


What should i do?

Hi,

it's the only control file the database it has, like 'e:\Oracle\oradata\testdb\control02.ctl' for example? If not, just copy the other one as 'e:\Oracle\oradata\testdb\control01.ctl' and should work ok. otherwise there are some steps to perform. Hope U can solve in this manner. If not just say it and I will explain how.

best regards,
Marius Nicoras

Yes, i would be very grateful if you could explain me how to do, since that in the "testdb" directory there isn't any file with .ctl extension. I only found some .ctl files under some directories containing Oracle's examples...

Hi,

sorry but last command should be:

alter database open resetlogs;

the same Marius Nicoras :-)

Hi,

if i'm honest i didn't understand much of what you suggested me, sorry:-), however i'd be grateful if you could explain me that. Anyway i tried another thing. I started the database configuration assistant and created a new database (copied from the CD). I thought that maybe now, when i set the NLS_LANG variable it should work...and it worked, or at least it seems so. I tried logging on SQL PLUS with system/manager and it seems all OK.

Thanx