Resolution to error - Unable to update Database Statistics

[Former Member]

OK, If there's one thing i hate most about SAP, its the dreaded installation, I am always so paranoid, as to something will definitely go wrong,

Lately i realized that it aint my mind , but the damn installation itself is pretty damn stupid. Why cant SAP leave the installation packaging to professionals like installshield...

Unfortunately SAP doesnt think of it as a better idea, so until then lets try to resolve as many errors as possible thru these forums..

Here's one error resolution ,i am pretty sure, many are checking for..

-

---

Use the following procedure to resolve error

<b>Warning - "loading of sql client library oci.dll failed"

Error - Unable to update Database Statistics, Check BRCONNECT.log</b>

The problem seems to be with the SAP Patch Collection InstallMaster disc Material No.(<b>51032143_13</b>).

To resolve the problem, here's what needs to be done,

1)Install DB Instance as usual.Then after the installation errors out due to loading of sql

client library oci.dll ..

2)I unsar the downloaded DBATOOLS.sar (Thanks for the Link Andreaz!!!)

-

---

log into sapnet (eg. service.sap.com) with your user-id/pwd:

-> downloads -> support packages and patches -> entry by application group -> additional

components -> sap kernel -> now chose either 32 or 64 bit; either unicode or non-unicode ->

sap kernel 6.40 -> windows server -> oracle -> download the package DBATOOLS Package for

Oracle 9.2.x ... brconnect is part of that package...

-

---

3)Copy the files in the Unsar'd package, as follows

overwrite br*.exe to S:\usr\sap\R31\SYS\exe\run

overwrite initSID.sap to S:\usr\sap\R31\SYS\exe\run &

S:\usr\sap\R31\SYS\exe\nuc\NTI386

overwrite libsbt.dll to S:\usr\sap\R31\SYS\exe\run &

S:\usr\sap\R31\SYS\exe\nuc\NTI386

overwrite sapdba_role.sql to S:\usr\sap\R31\SYS\exe\run &

S:\usr\sap\R31\SYS\exe\nuc\NTI386

4) Retry the installation again & Guess what!! it works....

Warning-: I initially tried a shortcut by replacing DBATOOLS.sar on the installmaster disc, rather than following above steps, but that doesnt seem to work, the installation fails as as soon as Tablespace creation starts. So the shortcut aint a good one..

[former_member204746]

Well, it looks like you resolved your problem yourself.

you can send feedback to SAP directly instead of posting this here in a forum.