ORA-12709: error while…
来源:互联网 发布:淘宝账户能注销吗 编辑:程序博客网 时间:2024/06/01 15:31
Problem Description:
====================
You are trying to start your instance via SQLPLUS or Server Managerwhen you encounter the
following error:
SQL> connect / as SYSDBA
or
SVRMGR> connect internal
SQL/SVRMGR> startup
You have confirmed that your ORACLE_HOME and ORACLE_SID are setcorrectly for
this instance.
No changes have been made to the database prior toshutdown.,
Solution Description:
=====================
In the Installation Guide for your Operating System and databaseversion, it
mentions that when specifying a character set other than US7ASCIIyou will need
to set one of the following ORA_NLS parameters at the operatingsystem level:
Only one of these parameters should be set at anytime.
On Unix the parameter should be set in the environment andshould
point to your $ORACLE_HOME/ocommon/nls/admin/data directory (pre10g)
or $ORACLE_HOME/nls/data (10g and up).
On windows this is typically *not* set in the registry
For more information on how to set ORA_NLSxx correctly pleaseread:
Note 77442.1 ORA_NLS (ORA_NLS32, ORA_NLS33, ORA_NLS10) EnvironmentVariables explained.
8.0/8i, 9i Unix Example:
------------------------
=====================
Use the correct setting for the environment variableORA_NLS33.
Per your platform specific Oracle Installation and ConfigurationGuide, the
ORA_NLS33 parameter should be set to the following:
ORA_NLS33 = $ORACLE_HOME/ocommon/nls/admin/data
To set the variable to the correct location, use the followingsyntax:
C-shell:
Bourne or Korn shell:
Restart your SQLPLUS or Server Manager session and restart thedatabase.
Check the files under ORACLE_HOME/ocommon/nls/admin/datadirectory.
1.
2.
of files in a previous backup or another database.
3.
Explanation:
============
Not finding the proper location for the NLS files, or some ofthe *.nlb files
in the ORACLE_HOME/ocommon/nls/admin/data directory are eithermissing or
corrupt.
REFERENCE
=========
Note1058400.6
Note275107.1
Note77442.1
- ORA-12709: error while…
- Error: ORA-1505…
- ORA-00700: soft internal error, …
- ORA-29702: error occur…
- import dump with error ORA-600[K…
- Error ORA-19606 on RMAN Delete
- ORA-16014,接着 …
- ORA-03137: TTC …
- LDAP: error code …
- g++ error : decla…
- linux : error whi…
- Error page: / Err…
- ERROR 23 (HY000) …
- MSCSLD : Error in…
- Error 000464 : 无…
- linux ERROR 1045 …
- Tomcat:IOException while …
- 【原创】mysql while do…
- OpenSSL工具生成根证书与应用证书
- 关于SQLSERVER SQL性能优化
- ORA-40210 time-out occ…
- 使用Catalog命令注册RMAN备份集
- 面试题------全排列的非递归和递归实现(含重复元素)
- ORA-12709: error while…
- 由于 ORA-20100: 错误:&…
- RMAN-08591: WARNING: i…
- Android 错误汇总
- Device Checks for&nbsp…
- hdu 5974 A Simple Math Problem
- perl adcfgclone.pl appsTier卡住
- 查看并关闭solaris 10防火墙
- 如何关闭solaris 10防火墙