Topic
  • 2 replies
  • Latest Post - ‏2008-10-06T04:14:52Z by SystemAdmin
SystemAdmin
SystemAdmin
280 Posts

Pinned topic ClearDDTS & Oracle 10.2.0.1.0 - Can not connect the two...

‏2008-09-12T15:06:36Z |
Can't get ClearDDTS to rebuild on to 10.2.0.1.0. I set the compatibility back to 10.0.0 on the oracle system but it still doesn't want to talk. Anyone else have a similar issue?
Going into maintenance mode...
Killing the ClearDDTS daemons...
ClearDDTS is in maintenance mode.
Connecting to oracle database (user=ddts, instance=ddts)...
ddtsdbbuild: Couldn't connect to the Oracle server. ERROR: ORA-3113

Connection failed. Database build aborted.

ClearDDTS & Oracle 10.2.0.1.0 - Can not connect the two...
Updated on 2008-10-06T04:14:52Z at 2008-10-06T04:14:52Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    280 Posts

    Re: ClearDDTS & Oracle 10.2.0.1.0 - Can not connect the two...

    ‏2008-10-05T19:08:06Z  
    That's a codepage pb : your Oracle 10g database may have as codepage something different than USASCII7 and ClearDDTS don't like that.

    i've ran several test with combinations of DDTs v4.6 & v4.8 with Oracle 9i and Oracle 10g. Everytime the DB codepage is not simply ASCII, the DB rebuild is failing exactly the same way you experienced ...

    So you'll way to set Oracle with a poor codepage ... or decommission DDTS ;-)

    Regards
    Jerome
  • SystemAdmin
    SystemAdmin
    280 Posts

    Re: ClearDDTS & Oracle 10.2.0.1.0 - Can not connect the two...

    ‏2008-10-06T04:14:52Z  
    That's a codepage pb : your Oracle 10g database may have as codepage something different than USASCII7 and ClearDDTS don't like that.

    i've ran several test with combinations of DDTs v4.6 & v4.8 with Oracle 9i and Oracle 10g. Everytime the DB codepage is not simply ASCII, the DB rebuild is failing exactly the same way you experienced ...

    So you'll way to set Oracle with a poor codepage ... or decommission DDTS ;-)

    Regards
    Jerome
    That was it. Thank you for the reply. Strange problem seeing that the oracle database is set to latin-1 and in that Strict US ascii is a subset of that. You would think it wouldn't be a problem. Thanks for the post.

    Robert Feldhousen