Apr 2010 CPU patches
Date: Fri, 14 May 2010 09:31:09 +0000 (GMT)
Message-ID: <243253.96038.qm_at_web25408.mail.ukl.yahoo.com>
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 semanticsGLOBAL_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.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 14 2010 - 04:31:09 CDT