Home » RDBMS Server » Server Administration » ORA-01482: unsupported character set in 10g with gather stats (10.2.0.1 Windows 2003 x64 Sp1)
ORA-01482: unsupported character set in 10g with gather stats [message #356107] Wed, 29 October 2008 10:08 Go to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
Hi all,

I was just wondering if this error is common and what i would need to change without affecting the whole database.
We are on still on ithe base install release10.2.0.1 and I only get the issues in one environments tables and not another?!
Can it be data related ?


(TRACEFILE)

*** 2008-10-21 22:00:20.156
*** ACTION NAME:(GATHER_STATS_JOB) 2008-10-21 22:00:20.156
*** MODULE NAME:(DBMS_SCHEDULER) 2008-10-21 22:00:20.156
*** SERVICE NAME:(SYS$USERS) 2008-10-21 22:00:20.156
*** SESSION ID:(111.46637) 2008-10-21 22:00:20.156
ORA-01482: unsupported character set
*** 2008-10-21 22:00:20.156
GATHER_STATS_JOB: GATHER_TABLE_STATS('"TRESOR_RRTAP"','"EMPLOYER"','""', ...)
ORA-01482: unsupported character set
*** 2008-10-21 22:00:20.266
GATHER_STATS_JOB: GATHER_TABLE_STATS('"TRESOR"','"EMPLOYER"','""', ...)
ORA-01482: unsupported character set
*** 2008-10-21 22:00:27.641
GATHER_STATS_JOB: GATHER_TABLE_STATS('"TRESOR_RRTAP"','"MEMBER"','""', ...)
ORA-01482: unsupported character set

Much appreciated
John
Re: ORA-01482: unsupported character set in 10g with gather stats [message #356129 is a reply to message #356107] Wed, 29 October 2008 12:53 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello,

This is oracle bug in 10.2.0.2. Please install latest patch & try to analyze.

Reg: Doc: 5018738.8

Babu
Re: ORA-01482: unsupported character set in 10g with gather stats [message #356134 is a reply to message #356107] Wed, 29 October 2008 13:10 Go to previous messageGo to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
We are on version 10.2.0.1 and can't afford to upgrade to 0.4 at this moment as it's not happening in all envs., which leads me to believe it's a data issue.
I have applied what Oracle said in a bundled patch which includs this DOC. and no luck.

Any other ideas ?
Thanks for reply !
Re: ORA-01482: unsupported character set in 10g with gather stats [message #356140 is a reply to message #356134] Wed, 29 October 2008 13:28 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Try this 344739.1

Again I'm requesting to you. Please install latest patch & try..

Babu

[Updated on: Wed, 29 October 2008 13:30]

Report message to a moderator

Re: ORA-01482: unsupported character set in 10g with gather stats [message #356144 is a reply to message #356140] Wed, 29 October 2008 13:48 Go to previous messageGo to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
I have applied that patch mentionned in the note and problem still exists.

Upgrading to 10.2.0.4 cannot be done at the moment Sad


Re: ORA-01482: unsupported character set in 10g with gather stats [message #356168 is a reply to message #356144] Wed, 29 October 2008 16:37 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>>I have applied that patch mentionned in the note and problem still exists.

Please post here patch number & also post output of below command.

In Oracle_home

opatch lsinventory


Babu
Re: ORA-01482: unsupported character set in 10g with gather stats [message #356346 is a reply to message #356107] Thu, 30 October 2008 07:45 Go to previous message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
Hi Babu... here is the output

E:\oracle\product\10.2.0\db_1\OPatch>opatch lsinventory
Invoking OPatch 10.2.0.1.3

Oracle interim Patch Installer version 10.2.0.1.3
Copyright (c) 2005, Oracle Corporation. All rights reserved..


Oracle Home : E:\oracle\product\10.2.0\db_1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 10.2.0.1.3
OUI version : 10.2.0.1.0
OUI location : E:\oracle\product\10.2.0\db_1\oui
Log file location : E:\oracle\product\10.2.0\db_1\cfgtoollogs\opatch\opatch200
10-30_07-44-33AM.log

Lsinventory Output file location : E:\oracle\product\10.2.0\db_1\cfgtoollogs\o
tch\lsinv\lsinventory2008-10-30_07-44-33AM.txt

------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle Database 10g 10.2.0.1.
There are 1 products installed in this Oracle Home.


Interim patches (1) :

Patch 5695786 : applied on Mon Oct 27 12:22:50 EST 2008
Created on 26 Dec 2006, 13:58:41 hrs
Bugs fixed:
5695786, 5694720, 5689937, 5500954, 5490936, 5490846, 5298887, 4939157
5092688, 4900129, 5366688, 5227899, 5109749, 5239701, 5225798, 5242648
5059261, 5049088, 5049080, 5059258, 4712199, 4901291, 5012796, 4447168
4537790, 4745114, 4458790, 4698156, 4916909, 4570793, 4523125, 4644048
4748797, 4671216, 4751888, 4515623, 4546618, 4898338, 4767699, 4908068
4496863, 4884408, 4542082, 4923787, 4865122, 4690147, 4686909, 4619452
4690401, 3807408, 4626732, 4573573, 4868255, 4573980, 4584509, 4902585
3748430, 4754888, 4383610, 4770480, 4577670, 4667809, 4309867, 4569842
4517846, 4439465, 4114966, 4751931, 4554682, 4554846, 4529672, 4583539
4629654, 4727495, 4505011, 4562889, 4629844, 4652261


------------------------------------------------------------------------------


OPatch succeeded.

Previous Topic: Problem creation TABLESPACE
Next Topic: drop table error
Goto Forum:
  


Current Time: Thu Dec 05 01:08:54 CST 2024