Error when Updating database Statistics

[Former Member]

Hi all,

I'm installing Database instance Of SAP R3E 4.7 extension set 2 SR1 on Window 2003 , orcle 9.2 (patch 9.2.0.8.0) . I got an error while Updating database Statictics is processing. How can i solve this problem

Log error is:

WARNING 2007-09-12 14:14:26

Execution of the command "C:\usr\sap\C11\SYS\exe\run/brconnect -u / -c -f crsyn -o SAPC11" finished with return code 3.

Output: BR0801I BRCONNECT 6.40 (45)BR0252E Function _popen() failed for '( C:\oracle\c11\920\bin\SQLPLUS /nolog ) < \nul 2>&1' at location BrPipeOpen-4BR0253E

errno 2: No such file or directoryBR0272E Execution of program '( C:\oracle\c11\920\bin\SQLPLUS /nolog ) < \nul 2>&1' through pipe failedBR0303E Determination of Oracle version failed

BR0801I BRCONNECT 6.40 (45)

BR0252E Function _popen() failed for '( C:\oracle\c11\920\bin\SQLPLUS /nolog ) < \nul 2>&1' at location BrPipeOpen-4

BR0253E errno 2: No such file or directory

BR0272E Execution of program '( C:\oracle\c11\920\bin\SQLPLUS /nolog ) < \nul 2>&1' through pipe failed

BR0303E Determination of Oracle version failed

BR0280I BRCONNECT time stamp: 2007-09-12 14.14.26

BR0804I BRCONNECT terminated with errors

BR,

Keng

Message was edited by:

Prachya Pantuyakorn

[former_member670924 · Accepted solution]

Hi Peter,

I've read that Topic. But i quite new for Oracle . So , how can i create

OPS$computername\NW4ADM for a local user

OPS$domainname\NW4ADM for a domain user

in oracle database

BR,

Prachya

[Former Member · Accepted solution]

they should normaly exist in the database.

try to run

sqlplus /nolog

connect / as sysdba

select username from dba_users;

put if the don't exist:

sqlplus /nolog

connect / as sysdba

create user "OPS$COMPUTERNAME\NW4ADM" identified externally;

grant sapconn to "OPS$COMPUTERNAME\NW4ADM";

grant sapdba to "OPS$COMPUTERNAME\NW4ADM";

the rest should be part of note 50088

peter

[Former Member · Accepted solution]

Hi Peter.

When i run command.

connect / as sysdba

i got an error

ORA-12560: TNS: protocol adapter error.

What'd i do ?

PS: I log in to Window with user "Administrator"

BR,

Prachya

[Former Member · Accepted solution]

Hi,

Pls check following things: This is very generic error, so you will have to check for cause of error.

1) Environment Variable ORACLE_SID

2) Check whether listener service is runnign or not.

3) Check Note 441518 - ORA-12560 composite SAP Note.

Regards,

Payal

[Former Member · Accepted solution]

Thanks, Payal & Peter

I've solved this problem.

[Former Member · Accepted solution]

Hi,

Please reward points to the replies which are useful.

Regards,

Payal

Message was edited by:

Payal Patel

[Former Member · Accepted solution]

Boys,

it is time that you are visiting some fundatmental basis administration courses!!!!!

please don't waste our time.

<sid>adm user is created in order to be used for all administrative tasks you have to perform on your SAP installation.

Other users, even they are members of the local adminsitrators group, DO NOT HAVE THE APPROPRIATE environment to run SAP programs / tools.

The Windows Buildin User ADMINISTRATOR should never be used for those purposes.

peter

[Former Member]

Hi,

Check whether <b>C:\oracle\c11\920\bin\SQLPLUS</b> is added to Environment variable <b>Path</b>

<b>[ignore this reply]</b>

Regards,

Payal

Message was edited by:

Payal Patel

Message was edited by:

Payal Patel

[former_member204746]

Payal, you probably made a typo...

answer should be:

Check whether C:\oracle\c11\920\bin\ is added to Environment variable Path

[Former Member]

Hi Eric,

Oh I am so sorry.

I made mistake.

It should be <b>C:\oracle\c11\920\bin</b>.

Thanks Eric for correcting it.

Someone should not be misguided.

Regards,

Payal

[Former Member]

maybe you should have a look at:

[former_member204746]

does file C:\oracle\c11\920\bin\SQLPLUS exist?