Error During Installation: Could not update database statistic

[Former Member]

Hi all,

We are running on Windows 2000 Service Pack 4.

We are installing SAP R3 Enterprise 4.7 Ext. 200 SR1

What we did:

Install Oracle 9.2

Install the Oracle Patch 9.2.0.7

Install The Central Instance: ABAP + NON UNICODE

We are now installing the database instance, it Stop in the step 29 of 34: <b>Updating Database Statistics</b>

The SAP system is already started and has the <b>GREEN</b> status.

The following Oracle services are <b>up</b> and <b>running:</b>

OracleService<SID>

OracleTVKAgent

OracleTVK920TNSListener

In order to resolve the problem with, we try changing the Kernel, using the latest one from SAP (<b>196 version</b>) So we stopped the SAP System, Them replace the kernel, and Start the SAP Server again. The system start without problems and wiht the <b>GREEN</b> status. Them we retry the process but nothing!! it fails.

After try to login as sysdba

SQLPLUS /nolog

Connect / as sysdba

But it gives this <b>Error</b>:

ORA-12560: TNS:protocol adapter error.

This is very strange since our OracleTVK920TNSListener is up and running] (<b>started</b>)

Them we try this:

<b>tnsping <DB SID></b>

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = vensapk) (PORT = 1527))) (CONNECT

DATA = (SID = TVK) (GLOBALNAME = TVK.WORLD)))

<b>OK</b> (40 msec)

C:\Documents and Settings\Administrator.VENSAP>lsnrctl status OracleTVK920TNSLis

tener

LSNRCTL for 32-bit Windows: Version 9.2.0.7.0 - Production on 26-NOV-2007 10:10:

03

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

TNS-01101: Could not find service name OracleTVK920TNSListener

NNC-00405: network failure

lsnrctl status OracleTVK920TNSListener

LSNRCTL for 32-bit Windows: Version 9.2.0.7.0 - Production on 26-NOV-2007 10:35:29

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

TNS-01101: Could not find service name OracleTVK920TNSListener

NNC-00405: network failure

In this moment we are logged as the <b>Domain Administrator</b> since we need this to do the installation. We are <b>not</b> logged as the <SID>adm user.

Please Some tips,

Best Regards,

Erick Ilarraza

[Former Member · Accepted solution]

>>>>In this moment we are logged as the Domain Administrator since we need this to do the installation. We are not logged as the <SID>adm user.

you have to use a user with the appropriate environment (variables) set to connect to the database.

<sid>adm has the right environment and should be used for those tasks.

peter

[Former Member · Accepted solution]

Hi! Thanks a lot for your replies

<b>Markus:</b>

This is our host file

127.0.0.1 localhost

10.55.46.69 vensapk SAPTRANSHOST

Our system is called vensapk

<b>Peter:</b>

You are right, I login with <SID>adm user.

SQLPLUS /nolog

connect / as sysdba

Connected

So perfect..

Them i try to run the Update Statistics manually (executing the same command the SAPinst is trying to run):

Microsoft Windows 2000 [Version 5.00.2195]

(C) Copyright 1985-2000 Microsoft Corp.

C:\Documents and Settings\tvkadm>brconnect -u / -c -f crsyn -o SAPTVK

BR0801I BRCONNECT 7.00 (16)

BR0999E Loading of <b>SQL client library oci.dll failed</b> - please check Oracle configuration

BR0310E Connect to database instance TVK failed

BR0280I BRCONNECT time stamp: 2007-11-26 12.06.54

BR0804I BRCONNECT terminated with errors

Best Regards,

Erick Ilarraza

[former_member204746 · Accepted solution]

you must downgrade BRTOOLS to version 6.40.

BRTOOLS 7.00 was made for Oracle 10g and you are on Oracle 9i.

[markus_doehr2 · Accepted solution]

You have installed the 7.00 BR*TOOLS and trying to connect against a 9.2 database, this does not work.

Replace them by the newest BR*TOOLS of kernel 6.40.

--

Markus

[Former Member · Accepted solution]

Hi!!

Thanks a lot for your help!

The installation is running again

INFO 2007-11-26 12:53:19

Execution of the command "D:\usr\sap\TVK\SYS\exe\run/brconnect -u / -c -f crsyn -o SAPTVK" <b>finished with return code 0</b>. Output: BR0801I BRCONNECT 6.40 (46)

Best Regards,

Erick ILarraza

[markus_doehr2]

Is the machine connected to the network? If no, is the loopback adapter installed?

Also check if there's a line with your hostname (aside from 127.0.0.1 localhost) in c:\windows\system32\drivers\etc\hosts

--

Markus