FAQ
Has anyone seen this error message when trying to install the Apr CPU 2010 patch on database.

uname -a
Linux jltuatdb.internal 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:58:04 EST 2007 i686 i686 i386 GNU/Linux
[jltdev_at_jltuatdb CPUJan2009]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Fri May 14 10:23:27 2010

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> _at_catcpu

ERROR:

ORA-00096: invalid value BYTE for parameter nls_length_semantics, must be from
among RYLRYÜJRY-

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
[jltdev_at_jltuatdb CPUJan2009]$

This is the output from database_properties...

DICT.BASE    2    dictionary base tables version #
DBTIMEZONE    0:00    DB time zone

NLS_LANGUAGE    AMERICAN    Language
NLS_TERRITORY    AMERICA    Territory
NLS_CURRENCY    $    Local currency
NLS_ISO_CURRENCY    AMERICA    ISO currency
NLS_NUMERIC_CHARACTERS    .,    Numeric characters
NLS_CHARACTERSET    UTF8    Character set
NLS_CALENDAR    GREGORIAN    Calendar system
NLS_DATE_FORMAT    DD-MON-RR    Date format
NLS_DATE_LANGUAGE    AMERICAN    Date language
NLS_SORT    BINARY    Linguistic definition
NLS_TIME_FORMAT    HH.MI.SSXFF AM    Time format
NLS_TIMESTAMP_FORMAT    DD-MON-RR HH.MI.SSXFF AM    Time stamp format
NLS_TIME_TZ_FORMAT    HH.MI.SSXFF AM TZH:TZM    Time with timezone format
NLS_TIMESTAMP_TZ_FORMAT    DD-MON-RR HH.MI.SSXFF AM TZH:TZM    Timestamp with timezone format
NLS_DUAL_CURRENCY    $    Dual currency symbol
NLS_COMP    BINARY    NLS comparison
NLS_NCHAR_CHARACTERSET    AL16UTF16    NCHAR Character set
NLS_LENGTH_SEMANTICS    BYTE    NLS length semantics

GLOBAL_DB_NAME    JLTDEV.INTERNAL    Global database name
EXPORT_VIEWS_VERSION    8    Export views revision #
NLS_NCHAR_CONV_EXCP    FALSE    NLS conversion exception
NLS_RDBMS_VERSION    10.2.0.3.0    RDBMS version for NLS parameters

DEFAULT_TEMP_TABLESPACE    TEMP    ID of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE    USERS    Default Permanent Tablespace ID
DEFAULT_TBS_TYPE    SMALLFILE    Default tablespace type

I can replicate the error, when I do the following, which is in fact what the catcpu.sql is also doing...

[jltdev_at_jltuatdb CPUJan2009]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Fri May 14 10:27:55 2010

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> ALTER SESSION SET NLS_LENGTH_SEMANTICS=BYTE;

ERROR:

ORA-00096: invalid value BYTE for parameter nls_length_semantics, must be from
among RYLRYÜJRY-

SQL>

Any help much appreciated.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 14, '10 at 9:31a
activeMay 14, '10 at 9:31a
posts1
users1
websiteoracle.com

1 user in discussion

Zabair Ahmed: 1 post

People

Translate

site design / logo © 2022 Grokbase