Apr 2010 CPU patches

From: Zabair Ahmed <roon987_at_yahoo.co.uk>
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 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.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 14 2010 - 04:31:09 CDT

Original text of this message