Error in DB installtion

[Former Member]

Hi ,

I have installed SAP 4.7 R\3 with oracle 10g in window 2003 standard edition.

There is no issue in installing CI.

after proceeding to DB installation i got struck in Update Database statistics

In log it shows

WARNING 2010-05-27 15:04:32

Execution of the command "D:\usr\sap\TVS\SYS\exe\run/brconnect -u / -c -f crsyn -o SAPTVS" finished with return code 3. Output: BR0801I BRCONNECT 7.00 (16)BR0252E Function popen() failed for '( D:\oracle\TVS\10264\BIN\sqlplus /nolog ) < \nul 2>&1' at location BrPipeOpen-4BR0253E errno 2: No such file or directoryBR0272E Execution of program '( D:\oracle\TVS\102_64\BIN\sqlplus /nolog ) < \nul 2>&1' through pipe failedBR0303E Determination of Oracle version failed

ERROR 2010-05-27 15:04:32

CJS-00288 Could not update database statistics.<br>DIAGNOSIS: Command brconnect -u / -c -f crsyn -o SAPTVS returned 3.<br>SOLUTION: See brconnect.log for details.

BR0801I BRCONNECT 7.00 (16)

BR0252E Function popen() failed for '( D:\oracle\TVS\10264\BIN\sqlplus /nolog ) < \nul 2>&1' at location BrPipeOpen-4

BR0253E errno 2: No such file or directory

BR0272E Execution of program '( D:\oracle\TVS\102_64\BIN\sqlplus /nolog ) < \nul 2>&1' through pipe failed

BR0303E Determination of Oracle version failed

BR0280I BRCONNECT time stamp: 2010-05-27 15.04.32

BR0804I BRCONNECT terminated with errors

But i can able to connect to database through sqlplus and i can do the all relevant changes

I have already check and applied as per posted forms but none of that working

Please help in solving this issue

Thansk in advance,

Bala

[former_member227600]

ERROR 2010-05-27 15:04:32
CJS-00288 Could not update database statistics.
DIAGNOSIS: Command brconnect -u / -c -f crsyn -o SAPTVS returned 3.
SOLUTION: See brconnect.log for details.

Can you please paste content from brconnect.log from your installation directory.

[Former Member]

Hi karan,

Thanks for response,

details of brconnect.log pasted below.

BR0801I BRCONNECT 7.00 (16)

BR0252E Function popen() failed for '( D:\oracle\TVS\10264\BIN\sqlplus /nolog ) < \nul 2>&1' at location BrPipeOpen-4

BR0253E errno 2: No such file or directory

BR0272E Execution of program '( D:\oracle\TVS\102_64\BIN\sqlplus /nolog ) < \nul 2>&1' through pipe failed

BR0303E Determination of Oracle version failed

BR0280I BRCONNECT time stamp: 2010-05-27 15.04.32

BR0804I BRCONNECT terminated with errors

Thanks,

Bala

[Former Member]

Hello bala,

This seems to be a permission issue.

Can you check the folder permissions D:\oracle\TVS\102_64\BIN.

Check the permissions of the brtools in the Kernel.

Check the SAP note - 113747.

Try to run oraroot.sh and saproot.sh. They are present in the in /sapmnt/IRQ/exe directory. Check the below link.

http://help.sap.com/saphelp_nw70/helpdata/en/43/3753c4b87b6025e10000000a422035/content.htm

Hope this solves your problem.

Thanks,

Nick S

[Former Member]

Hi nick,

Thanks for response

I have seen the link....

In the provided link it is stating for unix server but am using windows server 2003

Thanks in advance

Bala

[Former Member]

Hi Bala,

Please have a look at the below thread.

It helps you.

Thanks,

Nick S

[fjhernanz]

Hi,

The command you're using:

brconnect -u / -c -f crsyn -o

does not start a statistics update but it creates the synonyms in the database. Please follow note 838725. The brconnect command for creating Oracle dictionary statistics is:

brconnect -u / -c -f stats -t oradict_stats

Br,

Javier

[Former Member]

Hi Javier,

Thanks for immediate reply,

I have ran as you mentioned but throws another issue as

D:\usr\sap\TVS\SYS\exe\run>brconnect -u / -c -f stats -t oradict_stats

BR0801I BRCONNECT 7.00 (16)

BR0805I Start of BRCONNECT processing: cedhzvam.sta 2010-05-27 16.57.52

BR0280I BRCONNECT time stamp: 2010-05-27 16.57.52

BR0301E SQL error -1017 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance TVS failed

BR0280I BRCONNECT time stamp: 2010-05-27 16.57.52

BR0301E SQL error -1017 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance TVS failed

BR0806I End of BRCONNECT processing: cedhzvam.sta 2010-05-27 16.57.52

BR0280I BRCONNECT time stamp: 2010-05-27 16.57.52

BR0804I BRCONNECT terminated with errors

Please let me know exact solution to resolve this problem.

Thanks in advance

Bala

[Former Member]

Hi,

BR0301E SQL error -1017 at location db_connect-2, SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance TVS failed

It seems BRTOOLS unable to connect to database.

You may need to import SAPDBA_ROLE as per the below note..

[Note 134592 - Importing the SAPDBA role (sapdba_role.sql)|https://service.sap.com/sap/support/notes/134592]

Execute the attached script as follow:

sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>

Also check if ORACLE_HOME and ORACLE_SID environment variables are set correctly for SAPServiceSID user.

Regards.

Rajesh Narkhede

[former_member204746]

read SAP note 400241 - problem with OPS$

[Former Member]

Hi rajesh,

Thsnks for your response,

Thers is no problem in brtools

I can able to check the table space and other functions using brtools

only problem is with brconnect

As you mentioned i executed the script but it shows as

SP2-0310: unable to open file "sapdba_role.sql"

Thanks in advance

Bala

[Former Member]

Hi,

SP2-0310: unable to open file "sapdba_role.sql"

Please check if ora<sid> user has at least read permission to above file.

Also the file is readable... (it is not currupt)

Also set the permission of brconnect as per the note "113747 - Permissions for DBA tools BRTools and SAPDBA"

# chmod 4775 /sapmnt/<SID>/exe/brconnect
# chown ora<sid>:sapsys /sapmnt/<SID>/exe/brconnect

Regards.

Rajesh Narkhede

[Former Member]

Hi,

As i already mentioned that am installting in windows server not in unix server

Is there any way to change owner permission for windows server ?

Please let me know to solve this issue

Thanks

Bala

[Former Member]

Hi,

May be your are not running the command from the location where sapdba_role.sql is stored.

Or use the absolute path for the above file.

For example:

sqlplus /nolog @<drive>:\path\to\sapdba_role <SAPSCHEMA_ID>

Check that and let us know...

Regards.

Rajesh Narkhede