ORA-12705: Cannot access NLS data files or invalid environment specified error

2011-03-11  来源:本站原创  分类:Database  人气:210 

ORA-12705: Cannot access NLS data files or invalid environment specified error

Free install the Oracle client to use PL / SQL, TOAD FOR oracle connection manager such as Oracle9i, 10g

As we all know, Oralce client a few megabytes too big, there are many online DIR processing. This treatment uses official ORALCE Kit Instant Client Package!

Download: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

1: Download this, Instant Client Package - Basic package. Then extract to any directory for example: F: \ oracleClient, established in this directory NETWORK folder, then under this folder and then re-establish ADMIN folder, and then service has been established on the tnsnames.ora file to this directory, and modify the IP ;

2: Modify the environment variable to increase Oracle_home = F: \ oracleClient; modify the Path environment variable increase in F: \ oracleClient;

3: Start PL / SQL, there ORALCE logon Cancel Calcel, open PL/SQL- "Perference which set OCI Library and Oracle_home, I set the OCI Library = F: \ oracleClient \ oci.dll, Oracle_home = F: \ oracleClient . Exit back in. Login prompt appears if Oracle Instant Client ORA-12705: Cannot access NLS data files or invalid environment specified error. Amended as follows:

If the Windows platform, the registry \ HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE find key NLS_LANG, the key standards by the Oracle client installation created value is NA. This led to the ORA-12705 error. The solution is to modify the NA of SIMPLIFIED CHINESE_CHINA.ZHS16GBK.

Linux, if the environment variable NLS_LANG value is NA will cause ORA-12705 error, the workaround is to modify the

set NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK

This article comes from CSDN blog, reproduced, please indicate the source: http://blog.csdn.net/zhengsj/archive/2009/06/01/4231348.aspx

相关文章
  • ORA-12705: Cannot access NLS data files or invalid environment specified error 2011-03-11

    ORA-12705: Cannot access NLS data files or invalid environment specified error Free install the Oracle client to use PL / SQL, TOAD FOR oracle connection manager such as Oracle9i, 10g As we all know, Oralce client a few megabytes too big, there are m

  • birt Cannot access NLS data files or invalid environment 2010-07-27

    ORA-12705: Cannot access NLS data files or invalid environment specified Articles Category: Database solutions are as follows: 1, First open the "Control Panel "-->" item "-->" Regional Regional and Language Options" ca

  • ORA-12705: Cannot access NLS data files or invalid environment specified . 2013-11-24

    环境AIX 6.1 ,oracle11g ASM ASM实例安装完成,并能正常启动,ASM盘组能够检测到. oracle软件正常安装. 然后DBCA建库的时候,在选择文件存储为止的时候选择ASM磁盘,然后图形界面上不显示盘组, 手动输入 +datadg 开始提示ORA-12705 错误,解决方法如下: ORA-12705: Cannot access NLS data files or invalid environment specified . 解决方法:正确设置如下两个环境变量 expor

  • cannot access nls data files 2011-06-29

    Myeclipse database connection using the following questions cannot access nls data files Myeclipse change under eclipse.ini, set-Duser.language = zh, restart myeclipse.

  • ORA-12705: Cannot access NLS data files or invalied envaroments s 2010-07-08

    oracle NLS_LANG in the registry value SIMPLIFIED CHINESE_CHINA.ZHS16GBK eclipse startup configuration file eclipse.ini of-Duser.language property is to en Will be en to zh, problem-solving.

  • Data guard standby database ctl files and data files due to ORA-16012 inconsistent 2011-05-17

    Oracle dataguard now get to do remote disaster recovery. All configuration in accordance with the documentation, not a problem. But when other colleagues to create libraries that can not be prepared and the main database synchronization, maintenance

  • 12. Database Management - management table spaces and data files 2010-03-22

     describes the logical table space is part of the database. From the physical perspective, the database data stored in the data file; Logically, the database is stored in table space, table space by one or more data files. Logical structure of the d

  • Change the location of oracle data files 2010-12-03

    First, change the location of processes oracle data files 1, the tablespace read-only, read-only state can still be for users to access the data. SQL> alter tablespace tscsfm read only; 2, the physical copies of documents 3, the table space offline S

  • Oracle table spaces and data files 2011-07-26

    --============================== - Oracle tablespace and data files --============================== / * First, the concept Table space: one or more logical collection of data files Table space logical storage objects: permanent section -> Table and

  • How to recover data files from a good oracle database 2010-10-27

    One. There are data files, control files and log file backup 1. Reinstall the operating system, server, oracle also reinstall the. If you reinstall the oracle and the previous damage to the structure of the database is exactly the same, then the reco

  • Database, create tablespaces and data files more user commands 2011-02-21

    ORACLE create table space ORACLE, the table space is the basic method of data management, all the objects to be stored in the user table space, that is, users have the right to use space to create a user object. Otherwise it is not permitted to creat

  • SQLServer and Access.Excel data summary, 2011-04-15

    The so-called data transmission, in fact, refers to the SQLServer access Access, Excel data between. Why should we consider this problem? Due to historical reasons, many customers before the data are stored in a text database, such as Acess, Excel, F

  • jquery access to data 2008-12-06

    <! DOCTYPE HTML PUBLIC "- / / W3C / / DTD HTML 4.0 Transitional / / EN"> <HTML> <HEAD> <TITLE> Data (name, value) </ TITLE> <META NAME="Generator" CONTENT="EditPlus"> <META NAME="Au

  • Oracle10g only way to restore data files 2010-03-22

    To be completed. 1, first install a new ORACLE, including the service name, SID, the installation directory should be the best line with the original ORACLE directory. Please note that I installed on D drive, follow the actual installation directory

  • Use the command line CVS to access project source files 2010-04-11

    Use the command-line CVS to access project source files Introduction to CVS If you are involved in site development project, you must use CVS as a project source file version control tool. This is a series of tools for documentation (of three) in the

  • Use the command line Subversion to access project source files 2010-04-16

    Getting Started with Subversion Command Line If you are involved in the project is using Subversion for version control, you will need to use Subversion to access project source files and change. You can click on items on the left navigation pane on

  • oracle data files and renamed one way of moving data files 2010-04-21

    I want to do is to present the original Oracle database / oracle/A1 directory A.dbf move the file to / oracle/B1 directory B.dbf data files, in order to forget the future, record the steps as follows: 1.mv / oracle/A1/A.dbf / oracle/B1/B.dbf 2.sqlplu

  • mysql backup (direct copy of data files) 2010-05-04

    Objective: A machine in the library to transfer to the B machine. 1, stop mysql service in the A machine mysql installation directory, locate the my.ini file to open, in this paper to find datadir, to the path of data files: ibdata1 and copy all fold

  • There is no backup data files, only the full restoration of archive 2010-06-17

    Prerequisite 1. Archive mode. 2. Data files created after the current control file. Otherwise it will report ORA-01178 error. ORA-01178: file 5 created before last CREATE CONTROLFILE, cannot recreate ORA-01110: data file 5: 'D: \ ORACLE \ PRODUCT \ 1

  • mysql backup (direct copy of data files) to switch 2010-06-22

    mysql backup (direct copy of data files) Articles Category: Database Objective: A machine in the library to transfer to the B machine. 1, stop mysql service in the A machine mysql installation directory, locate the my.ini file to open, in this paper