OraFAQ Forum: Server Administration » CSALTER ERROR after csscan ran clean.

Home » RDBMS Server » Server Administration » CSALTER ERROR after csscan ran clean.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CSALTER ERROR after csscan ran clean. [message #496018]

Wed, 23 February 2011 15:17

cakeday
Messages: 31
Registered: May 2010

Member

MY CSSCAN comes out clean (scan.txt is attached below.
But when i try to run csalter, it gives me the following error:
CSALTER:
SQL> startup restrict
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 494927872 bytes
Fixed Size 2085072 bytes
Variable Size 230690608 bytes
Database Buffers 255852544 bytes
Redo Buffers 6299648 bytes
Database mounted.
Database opened.
SQL> @@csalter.plb

0 rows created.

Function created.

Function created.

Procedure created.

This script will update the content of the Oracle Data Dictionary.
Please ensure you have a full backup before initiating this procedure.
Would you like to proceed (Y/N)?Y
old 6: if (UPPER('&conf') <> 'Y') then
new 6: if (UPPER('Y') <> 'Y') then
Checking data validility...
Unrecognized convertible date found in scanner result

PL/SQL procedure successfully completed.

Checking or Converting phrase did not finish successfully
No database (national) character set will be altered
CSALTER finished unsuccessfully.

PL/SQL procedure successfully completed.

0 rows deleted.

Function dropped.

Function dropped.

Procedure dropped.

==========

csscan resULTS

"scan.txt" 226 lines, 19214 characters
Database Scan Summary Report

Time Started : 2011-02-23 10:10:48
Time Completed: 2011-02-23 10:20:58

Process ID Time Started Time Completed
---------- -------------------- --------------------
1 2011-02-23 10:11:10 2011-02-23 10:20:57
---------- -------------------- --------------------

[Database Size]

Tablespace Used Free Total Expansion
------------------------- --------------- --------------- --------------- ---------------
SYSTEM 2,033.25M 996.75M 3,030.00M 850.48M
UNDOTBS1 41.81M 888.19M 930.00M .00K
SYSAUX 442.69M 57.31M 500.00M 9.63M
TEMP .00K .00K .00K .00K
USERS 247.38M 595.13M 842.50M 9.00K
MFTCCL001_DATA 3.81M 7,044.19M 7,048.00M .00K
MFTCCS001_DATA 3.81M 7,044.19M 7,048.00M .00K
MFTSIM001_DATA 2,783.63M 5,288.38M 8,072.00M .00K
MFT001_DATA 13,003.13M 8,020.88M 21,024.00M 9.00K
------------------------- --------------- --------------- --------------- ---------------
Total 18,559.50M 29,935.00M 48,494.50M 860.12M

The size of the largest CLOB is 1625114 bytes

[Database Scan Parameters]

Parameter Value
------------------------------ ------------------------------------------------
CSSCAN Version v2.1
Instance Name X003
Database Version 10.2.0.4.0
Scan type Full database
Scan CHAR data? YES
Database character set WE8ISO8859P1
FROMCHAR WE8ISO8859P1
TOCHAR AL32UTF8
Scan NCHAR data? NO
Array fetch buffer size 1024000
Number of processes 1
Capture convertible data? NO
------------------------------ ------------------------------------------------

[Scan Summary]

All character type data in the data dictionary are convertible to the new character set
All character type application data are convertible to the new character set
"scan.txt" 226 lines, 19214 characters
Database Scan Summary Report

Time Started : 2011-02-23 10:10:48
Time Completed: 2011-02-23 10:20:58

Process ID Time Started Time Completed
---------- -------------------- --------------------
1 2011-02-23 10:11:10 2011-02-23 10:20:57
---------- -------------------- --------------------

[Database Size]

Tablespace Used Free Total Expansion
------------------------- --------------- --------------- --------------- ---------------
SYSTEM 2,033.25M 996.75M 3,030.00M 850.48M
UNDOTBS1 41.81M 888.19M 930.00M .00K
SYSAUX 442.69M 57.31M 500.00M 9.63M
TEMP .00K .00K .00K .00K
USERS 247.38M 595.13M 842.50M 9.00K
MFTCCL001_DATA 3.81M 7,044.19M 7,048.00M .00K
MFTCCS001_DATA 3.81M 7,044.19M 7,048.00M .00K
MFTSIM001_DATA 2,783.63M 5,288.38M 8,072.00M .00K
MFT001_DATA 13,003.13M 8,020.88M 21,024.00M 9.00K
------------------------- --------------- --------------- --------------- ---------------
Total 18,559.50M 29,935.00M 48,494.50M 860.12M

The size of the largest CLOB is 1625114 bytes

[Database Scan Parameters]

Parameter Value
------------------------------ ------------------------------------------------
CSSCAN Version v2.1
Instance Name X003
Database Version 10.2.0.4.0
Scan type Full database
Scan CHAR data? YES
Database character set WE8ISO8859P1
FROMCHAR WE8ISO8859P1
TOCHAR AL32UTF8
Scan NCHAR data? NO
Array fetch buffer size 1024000
Number of processes 1
Capture convertible data? NO
------------------------------ ------------------------------------------------

[Scan Summary]

All character type data in the data dictionary are convertible to the new character set
All character type application data are convertible to the new character set

[Data Dictionary Conversion Summary]

Datatype Changeless Convertible Truncation Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2 34,835,743 0 0 0
CHAR 2,993,112 0 0 0
LONG 181,112 0 0 0
LONG 691 0 0 0
CLOB 0 0 0 0
VARRAY 1,575 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 83,962,044 3,058 0 0
Total in percentage 99.996% 0.004% 0.000% 0.000%

[Distribution of Convertible, Truncated and Lossy Data by Table]

USER.TABLE Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
MDSYS.SDO_COORD_OP_PARAM_VALS 200 0 0
MDSYS.SDO_GEOR_XMLSCHEMA_TABLE 1 0 0
MDSYS.SDO_STYLES_TABLE 78 0 0
MDSYS.SDO_XML_SCHEMAS 3 0 0
MFT.MDLR_PAL_ITEM_DESC 1,457 0 0
MFT.MDLR_PAL_MENU_DESC 72 0 0
MFTGIS.MDLR_PAL_ITEM_DESC 1,457 0 0
MFTGIS.MDLR_PAL_MENU_DESC 72 0 0
SYS.METASTYLESHEET 80 0 0
SYS.RULE$ 1 0 0
SYS.SYS_EXPORT_FULL_01 1,869 0 0
SYS.SYS_EXPORT_FULL_02 1,869 0 0
SYS.SYS_EXPORT_FULL_03 1,869 0 0
SYS.SYS_EXPORT_FULL_04 1,869 0 0
SYS.SYS_EXPORT_FULL_05 1,869 0 0
SYS.SYS_EXPORT_FULL_06 1,869 0 0
SYS.SYS_EXPORT_FULL_07 1,869 0 0
SYS.SYS_EXPORT_FULL_08 1,869 0 0
SYS.SYS_EXPORT_FULL_09 1,887 0 0
SYS.SYS_EXPORT_FULL_10 1,887 0 0
SYS.SYS_EXPORT_FULL_11 1,890 0 0
SYS.SYS_EXPORT_FULL_12 1,890 0 0
SYS.SYS_EXPORT_FULL_13 1,890 0 0
SYS.SYS_EXPORT_FULL_14 1,890 0 0
SYS.SYS_EXPORT_FULL_15 1,890 0 0
SYS.SYS_EXPORT_FULL_16 1,890 0 0
SYS.SYS_EXPORT_FULL_17 1,890 0 0
SYS.SYS_EXPORT_FULL_18 1,890 0 0
SYS.SYS_EXPORT_FULL_19 1,890 0 0
SYS.SYS_EXPORT_FULL_20 1,890 0 0
SYS.SYS_EXPORT_FULL_21 1,890 0 0
SYS.SYS_EXPORT_FULL_22 1,890 0 0
SYS.SYS_EXPORT_FULL_23 1,890 0 0
SYS.SYS_EXPORT_FULL_24 1,890 0 0
SYS.SYS_EXPORT_FULL_26 1,890 0 0
SYS.SYS_EXPORT_FULL_27 1,890 0 0
SYS.SYS_EXPORT_FULL_28 1,890 0 0
SYS.SYS_EXPORT_FULL_29 1,890 0 0
SYS.SYS_EXPORT_FULL_30 1,890 0 0
SYS.SYS_EXPORT_FULL_31 1,890 0 0
SYS.SYS_EXPORT_FULL_32 1,890 0 0
SYS.SYS_EXPORT_FULL_34 1,890 0 0
SYS.SYS_EXPORT_FULL_35 1,890 0 0
SYS.SYS_EXPORT_FULL_36 1,890 0 0
SYS.SYS_EXPORT_FULL_37 1,890 0 0
SYS.SYS_EXPORT_FULL_38 1,890 0 0
SYS.SYS_EXPORT_FULL_39 1,890 0 0
LONG 691 0 0 0
CLOB 0 0 0 0
VARRAY 1,575 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 83,962,044 3,058 0 0
Total in percentage 99.996% 0.004% 0.000% 0.000%

[Distribution of Convertible, Truncated and Lossy Data by Table]

USER.TABLE Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
MDSYS.SDO_COORD_OP_PARAM_VALS 200 0 0
MDSYS.SDO_GEOR_XMLSCHEMA_TABLE 1 0 0
MDSYS.SDO_STYLES_TABLE 78 0 0
MDSYS.SDO_XML_SCHEMAS 3 0 0
MFT.MDLR_PAL_ITEM_DESC 1,457 0 0
MFT.MDLR_PAL_MENU_DESC 72 0 0
MFTGIS.MDLR_PAL_ITEM_DESC 1,457 0 0
MFTGIS.MDLR_PAL_MENU_DESC 72 0 0
SYS.METASTYLESHEET 80 0 0
SYS.RULE$ 1 0 0
SYS.SYS_EXPORT_FULL_01 1,869 0 0
SYS.SYS_EXPORT_FULL_02 1,869 0 0
SYS.SYS_EXPORT_FULL_03 1,869 0 0
SYS.SYS_EXPORT_FULL_04 1,869 0 0
SYS.SYS_EXPORT_FULL_05 1,869 0 0
SYS.SYS_EXPORT_FULL_06 1,869 0 0
SYS.SYS_EXPORT_FULL_07 1,869 0 0
SYS.SYS_EXPORT_FULL_08 1,869 0 0
SYS.SYS_EXPORT_FULL_09 1,887 0 0
SYS.SYS_EXPORT_FULL_10 1,887 0 0
SYS.SYS_EXPORT_FULL_11 1,890 0 0
SYS.SYS_EXPORT_FULL_12 1,890 0 0
SYS.SYS_EXPORT_FULL_13 1,890 0 0
SYS.SYS_EXPORT_FULL_14 1,890 0 0
SYS.SYS_EXPORT_FULL_15 1,890 0 0
SYS.SYS_EXPORT_FULL_16 1,890 0 0
SYS.SYS_EXPORT_FULL_17 1,890 0 0
SYS.SYS_EXPORT_FULL_18 1,890 0 0
SYS.SYS_EXPORT_FULL_19 1,890 0 0
SYS.SYS_EXPORT_FULL_20 1,890 0 0
SYS.SYS_EXPORT_FULL_21 1,890 0 0
SYS.SYS_EXPORT_FULL_22 1,890 0 0
SYS.SYS_EXPORT_FULL_23 1,890 0 0
SYS.SYS_EXPORT_FULL_24 1,890 0 0
SYS.SYS_EXPORT_FULL_26 1,890 0 0
SYS.SYS_EXPORT_FULL_27 1,890 0 0
SYS.SYS_EXPORT_FULL_28 1,890 0 0
SYS.SYS_EXPORT_FULL_29 1,890 0 0
SYS.SYS_EXPORT_FULL_30 1,890 0 0
SYS.SYS_EXPORT_FULL_31 1,890 0 0
SYS.SYS_EXPORT_FULL_32 1,890 0 0
SYS.SYS_EXPORT_FULL_34 1,890 0 0
SYS.SYS_EXPORT_FULL_35 1,890 0 0
SYS.SYS_EXPORT_FULL_36 1,890 0 0
SYS.SYS_EXPORT_FULL_37 1,890 0 0
SYS.SYS_EXPORT_FULL_38 1,890 0 0
SYS.SYS_EXPORT_FULL_39 1,890 0 0
SYS.SYS_EXPORT_FULL_40 1,890 0 0
SYS.SYS_EXPORT_FULL_42 1,890 0 0
LONG 691 0 0 0
CLOB 0 0 0 0
VARRAY 1,575 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 83,962,044 3,058 0 0
Total in percentage 99.996% 0.004% 0.000% 0.000%

[Distribution of Convertible, Truncated and Lossy Data by Table]

USER.TABLE Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
MDSYS.SDO_COORD_OP_PARAM_VALS 200 0 0
MDSYS.SDO_GEOR_XMLSCHEMA_TABLE 1 0 0
MDSYS.SDO_STYLES_TABLE 78 0 0
MDSYS.SDO_XML_SCHEMAS 3 0 0
MFT.MDLR_PAL_ITEM_DESC 1,457 0 0
MFT.MDLR_PAL_MENU_DESC 72 0 0
MFTGIS.MDLR_PAL_ITEM_DESC 1,457 0 0
MFTGIS.MDLR_PAL_MENU_DESC 72 0 0
SYS.METASTYLESHEET 80 0 0
SYS.RULE$ 1 0 0
SYS.SYS_EXPORT_FULL_01 1,869 0 0
SYS.SYS_EXPORT_FULL_02 1,869 0 0
SYS.SYS_EXPORT_FULL_03 1,869 0 0
SYS.SYS_EXPORT_FULL_04 1,869 0 0
SYS.SYS_EXPORT_FULL_05 1,869 0 0
SYS.SYS_EXPORT_FULL_06 1,869 0 0
SYS.SYS_EXPORT_FULL_07 1,869 0 0
SYS.SYS_EXPORT_FULL_08 1,869 0 0
SYS.SYS_EXPORT_FULL_09 1,887 0 0
SYS.SYS_EXPORT_FULL_10 1,887 0 0
SYS.SYS_EXPORT_FULL_11 1,890 0 0
SYS.SYS_EXPORT_FULL_12 1,890 0 0
SYS.SYS_EXPORT_FULL_13 1,890 0 0
SYS.SYS_EXPORT_FULL_14 1,890 0 0
SYS.SYS_EXPORT_FULL_15 1,890 0 0
SYS.SYS_EXPORT_FULL_16 1,890 0 0
SYS.SYS_EXPORT_FULL_17 1,890 0 0
SYS.SYS_EXPORT_FULL_18 1,890 0 0
SYS.SYS_EXPORT_FULL_19 1,890 0 0
SYS.SYS_EXPORT_FULL_20 1,890 0 0
SYS.SYS_EXPORT_FULL_21 1,890 0 0
SYS.SYS_EXPORT_FULL_22 1,890 0 0
SYS.SYS_EXPORT_FULL_23 1,890 0 0
SYS.SYS_EXPORT_FULL_24 1,890 0 0
SYS.SYS_EXPORT_FULL_26 1,890 0 0
SYS.SYS_EXPORT_FULL_27 1,890 0 0
SYS.SYS_EXPORT_FULL_28 1,890 0 0
SYS.SYS_EXPORT_FULL_29 1,890 0 0
SYS.SYS_EXPORT_FULL_30 1,890 0 0
SYS.SYS_EXPORT_FULL_31 1,890 0 0
SYS.SYS_EXPORT_FULL_32 1,890 0 0
SYS.SYS_EXPORT_FULL_34 1,890 0 0
SYS.SYS_EXPORT_FULL_35 1,890 0 0
SYS.SYS_EXPORT_FULL_36 1,890 0 0
SYS.SYS_EXPORT_FULL_37 1,890 0 0
SYS.SYS_EXPORT_FULL_38 1,890 0 0
SYS.SYS_EXPORT_FULL_39 1,890 0 0

Report message to a moderator

Re: CSALTER ERROR after csscan ran clean. [message #496019 is a reply to message #496018]

Wed, 23 February 2011 15:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

32004, 00000, "obsolete or deprecated parameter(s) specified for %s instance"
// *Cause:  Obsolete or deprecated parameters for this instance type 
//          were specified in the SPFILE or the PFILE on the server side.
// *Action: See alert log for a list of parameters that are obsolete
//          or deprecated. Remove them from the SPFILE or the server 
//          side PFILE.

Report message to a moderator

Re: CSALTER ERROR after csscan ran clean. [message #496021 is a reply to message #496018]

Wed, 23 February 2011 16:28

cakeday
Messages: 31
Registered: May 2010

Member

i cleaned up the deprecated parameter (which was sql_trace) and then when i tried running csalter -- still the same error.
CSSCAN looks clean.

startup restrictDatabase closed.
Database dismounted.
ORACLE instance shut down.
SQL>
ORACLE instance started.

Total System Global Area 494927872 bytes
Fixed Size 2085072 bytes
Variable Size 230690608 bytes
Database Buffers 255852544 bytes
Redo Buffers 6299648 bytes
Database mounted.
Database opened.
SQL> @@csalter.plb

0 rows created.

Function created.

Function created.

Procedure created.

This script will update the content of the Oracle Data Dictionary.
Please ensure you have a full backup before initiating this procedure.
Would you like to proceed (Y/N)?Y
old 6: if (UPPER('&conf') <> 'Y') then
new 6: if (UPPER('Y') <> 'Y') then
Checking data validility...
Unrecognized convertible date found in scanner result

PL/SQL procedure successfully completed.

Checking or Converting phrase did not finish successfully
No database (national) character set will be altered
CSALTER finished unsuccessfully.

PL/SQL procedure successfully completed.

0 rows deleted.

Function dropped.

Function dropped.

Procedure dropped.

SQL>

Report message to a moderator

Re: CSALTER ERROR after csscan ran clean. [message #496024 is a reply to message #496021]

Wed, 23 February 2011 17:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Unrecognized convertible date found in scanner result
It appears you have "dirty" data.
If you can't find/fix the bad data, your choices are limited.

exp/imp is THE approved method to change characterset.

Report message to a moderator

Previous Topic:	how to spot which oracle packages are installed / licensed
Next Topic:	add database to server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 08:25:51 CDT 2024