Home » RDBMS Server » Server Administration » CSALTER ERROR after csscan ran clean.
CSALTER ERROR after csscan ran clean. [message #496018] |
Wed, 23 February 2011 15:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
Re: CSALTER ERROR after csscan ran clean. [message #496021 is a reply to message #496018] |
Wed, 23 February 2011 16:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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>
|
|
|
Re: CSALTER ERROR after csscan ran clean. [message #496024 is a reply to message #496021] |
Wed, 23 February 2011 17:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
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.
|
|
|
Goto Forum:
Current Time: Mon Aug 26 17:24:32 CDT 2024
|