Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OraOLEDB is still crazy

Wataru TanabeOct 28 2015 — edited Jun 10 2020

https://community.oracle.com/message/12990330#12990330

If there is no way to reply to archived discussions,

they don't seem to know that they tend to waste much time more than 120 days to solve the problems of their products.

(The reason why they archive discussions might be because they might know that the problems would be never solved.)

----

> In THIS APRIL(after March, 2015), we built the LATEST(*) 11.2.0.4 client environment.

> As a result, we found new behavior of OraOLEDB...

In the end of THIS SEPTEMBER, we build LATEST(*) 11.2.0.3 client environment.

*)You should ask Oracle Support how to update 11.2.0.3 client to latest revision.

As a result, we found new behavior of OraOLEDB...

---- our result ----

Name|Replace(Value," ","B")|DefinedSize|Type

EQ|ああ|2|202

LT|ああ|4|202

----

They seem to stop appending crazy blanks at last.

The value "202" of "Type" means "adVarWChar".

The number of characters of the value of CHAR(4 BYTE) is "less than or equal to" 4(VARIABLE-characters)

even though the number of bytes of the value is "just equal to" 4(FIXED-bytes)

when the encoding is JA16SJISTILDE(VARIABLE-width 2 byte character set).

Had they recovered their senses?

Not yet.

Why do they still believe that DefinedSize of "EQ" must be "2"?

Why do they cause inconsistencies to cause inconsistencies?

Comments

EdStevens

I installed Oracle 12c on VMware ESIX
No, you installed it on some unknown (to us) operating system on a VM. VMware ESIX is the hypervisor on which that VM was created, and is immaterial to your question.
So, what happened to the control files of the first instance? Show us the startup messages from the alert log. And please format it when you post it.

User_YOWZH

the operating system is Windows Server 2019. When the first instance is installed, everything works perfectly. However, after installation of the second instance, that is when it breaks access to the control files on the 1st instance. Will post alert log information.

User_YOWZH

Found that the problem was due to a bug with the version of the Oracle I was using. This describes the bug.
image.png

1 - 3

Post Details

Added on Oct 28 2015
36 comments
3,428 views