- 论坛徽章:
- 0
|
在SOLARIS上装完ORACLE9后，无法启动（内容见内）求助！
文档 ID: 注释:1017998.102
主题: Starting EM 2 OMS Fails with ORA-12705
类型: PROBLEM
状态: PUBLISHED
内容类型: TEXT/PLAIN
创建日期: 29-SEP-1999
上次修订日期: 12-APR-2002
Problem Description: ==================== You are trying to start up the Oracle Management Server (OMS) and receive an ORA-12705 error, causing the service to fail to start. 12705, 00000, "invalid or unknown NLS parameter value specified" // *Cause: The NLS parameter value specified in an alter session statement with an invalid NLS parameter. *Action: Check the syntax of the alter session command and the NLS_PARAMETER. Correct the syntax and retry the statement. Problem Explanation: ==================== An improper NLS parameter setting is preventing the OMS from connecting to the repository, thus preventing the OMS service from starting. Problem References: =================== [BUG]CANNOT LOG ON TO A LOCAL DATABASE [BUG]CANNOT SET NLS_LANGUAGE TO ANYTHING OTHER THAN AMERICAN [BUG]NLS: ORA-12705 IF NLS_LANG IS NOT AMERICAN_AMERICA.XXX (WHEN CONNECTING TO DB) Solution Description: ===================== The NLS parameter must be set correctly for the OMS to connect to the database. In this occurrence, the OMS was in one ORACLE_HOME and the 7.3.4 database was in the other home. Once the NLS parameter was properly set in the OMS home, the OMS connected to the repository and the service started. To set the NLS parameter on UNIX, perform the following steps: 1) Check the NLS parameter that the DATABASE is using by looking at the initSID. ora file. 2) CD to the proper ORACLE_HOME where the OMS is to be run. 3) Set the NLS parameter in the OMS home to match the one the database is using by issuing the following command: $ setenv NLS_LANG X "X" Is the actual NLS parameter used by the database. This command will vary depending on the shell and operating system. The above is an example of C shell on a Solaris OS. Check the Installation Guide for the database to learn more about setting the NLS parameter for the proper system. Solution Explanation: ===================== Usually, a client machine or a separate Oracle_home does not need an NLS parameter set. Once the database is contacted, it will relay the NLS parameter to the client machine or other Oracle_home environment. So, usually you would NOT want to set the NLS parameter in the OMS home. However, in this case, the NLS parameter, matching the one the database uses, had to be set for proper communication between homes. |
|
免费注册
发表于 2003-05-07 19:59
发表于 2003-05-08 15:10