Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1691
  • Last Modified:

Oracle 11, Change NLS_CHARACTERSET database property when database is down

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
jcwiatr
Asked:
jcwiatr
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
jcwiatrAuthor Commented:
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
 
slightwv (䄆 Netminder) Commented:
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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now