Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Oracle 11, Change NLS_CHARACTERSET database property when database is down

Posted on 2010-11-24
3
Medium Priority
?
1,686 Views
Last Modified: 2012-05-10
Hi there,

I changed my database NLS_CHARACTERSET property to match an export.dmp file so I could import the data and now the database will not startup.  I am getting the error
ERROR: ORA-12705: Cannot access NLS data files or invalid environment specified

How do I change the NLS_CHARACTERSET property of the database when I cannot login to it ?

Points based on urgency.

Thank-you.
0
Comment
Question by:jcwiatr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34209829
My gUess is you never installed the language files that you told Oracle to use.

Set it back to the original setting and you should be OK.

Burleson has a page on getting around this error.  Google that error number and it should be one of the top links.

On mobile right now so I can't find it for you.
0
 
LVL 1

Author Comment

by:jcwiatr
ID: 34209844
Hi,   I am trying to set it back but when I try and startup the database to login I am getting the error message.

How do I change it back when I cannot startup/login to the database ?

Cheers

0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 34210121
Create a pfile from spfile, edit it, change the entry theb use startup pfile=your_pfile

Once it starts create a new spfile.

You cannot manually edit a spfile.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to recover a database from a user managed backup

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question