on 08-26-2009 12:49 AM
Hello Folks
I have problem installing SAP R/3 Enterprise (4.72 Enterprise Ext2) IDES Version
The installation is under Windows 2003 server 32bit SP2 and Oracle 920
I did the correct installation from oracle database (i followed the guide)
and i patched oracle with "Oracle 9.2 Patch Set 7 WIN I386 32Bit"
Also one step before i had a BRTools 7.00 error, downloaded the BRTools 640
DBATL640O92_51-10004734.SAR DBATOOLS Package for Oracle 9.2.x
After this i downloaded vcredist_<platform>.exe from Microsoft web page and retry
I'm in the Database Instance Installation (non-unicode) and phase 29 (Updating database statistics)
and i got the same error
brconnect.exe Unable to locate component
This application has failed to start because orasql10.dll was not found. Re-installing the application may fix this problem
This is a image the error
http://i249.photobucket.com/albums/gg236/Azurah80/error.jpg
This is a log
INFO 2009-08-25 18:17:56
Output of E:\usr\sap\C11\SYS\exe\run/brconnect -u / -c -f crsyn -o SAPC11 is written to the logfile brconnect.log.
WARNING 2009-08-25 18:28:03
Execution of the command "E:\usr\sap\C11\SYS\exe\run/brconnect -u / -c -f crsyn -o SAPC11" finished with return code 128. Output:
ERROR 2009-08-25 18:28:03
CJS-00288 Could not update database statistics.
DIAGNOSIS: Command brconnect -u / -c -f crsyn -o SAPC11 returned 128.
SOLUTION: See brconnect.log for details.
I dont know what happend please help
I'm adding more information about Brconnect
C:\Documents and Settings\c11adm>BRCONNECT
BR0801I BRCONNECT 6.40 (51)
BR0155E No value found for option '-f'
BR0280I BRCONNECT time stamp: 2009-08-26 14.34.20
BR0804I BRCONNECT terminated with errors
C:\Documents and Settings\c11adm>BRCONNECT -v
BR0801I BRCONNECT 6.40 (51)
BR0153E Unknown option '-v' found at position 1
BR0280I BRCONNECT time stamp: 2009-08-26 14.37.49
BR0804I BRCONNECT terminated with errors
C:\Documents and Settings\c11adm>brconnect -u / -c -f check
BR0801I BRCONNECT 6.40 (51)
BR0805I Start of BRCONNECT processing: cebigorb.chk 2009-08-26 14.40.51
BR0484I BRCONNECT log file: F:\oracle\C11\sapcheck\cebigorb.chk
BR0280I BRCONNECT time stamp: 2009-08-26 14.40.52
BR0301E SQL error -1017 at location db_connect-2
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance C11 failed
BR0280I BRCONNECT time stamp: 2009-08-26 14.40.52
BR0301E SQL error -1017 at location db_connect-2
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance C11 failed
BR0806I End of BRCONNECT processing: cebigorb.chk 2009-08-26 14.40.52
BR0280I BRCONNECT time stamp: 2009-08-26 14.40.52
BR0804I BRCONNECT terminated with errors
may be it's help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
C:\Documents and Settings\c11adm>E:\usr\sap\C11\SYS\exe\run/brconnect -u / -c -f
crsyn -o SAPC11
BR0801I BRCONNECT 6.40 (51)
BR0280I BRCONNECT time stamp: 2009-08-26 15.10.47
BR0301E SQL error -1017 at location db_connect-2
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance C11 failed
BR0280I BRCONNECT time stamp: 2009-08-26 15.10.47
BR0804I BRCONNECT terminated with errors
a little bit more information...
> C:\Documents and Settings\c11adm>E:\usr\sap\C11\SYS\exe\run/brconnect -u / -c -f
> crsyn -o SAPC11
> BR0801I BRCONNECT 6.40 (51)
> BR0280I BRCONNECT time stamp: 2009-08-26 15.10.47
> BR0301E SQL error -1017 at location db_connect-2
> ORA-01017: invalid username/password; logon denied
ah!
your OPS$-user is not correctly created.
Check if you can solve that using
Note 400241 - Problems with ops$ or sapr3 connect to Oracle
Markus
Markus im not sure if i'm correct but
I applied the following note 717677
and if you see i have the users created on the Oracle
Enter user-name: / as sysdba
Connected.
SQL> select * from all_users;
USERNAME USER_ID CREATED
-
-
-
SYS 0 24-AUG-09
SYSTEM 5 24-AUG-09
OUTLN 11 24-AUG-09
DBSNMP 19 24-AUG-09
OPS$C11ADM 21 24-AUG-09
SAPC11 22 24-AUG-09
OPS$SAPSERVICEC11 23 24-AUG-09
OPS$ORADBC11 25 26-AUG-09
OPS$ORAC11 26 26-AUG-09
ORAC11 27 26-AUG-09
ORADBC11 28 26-AUG-09
11 rows selected.
But when i tried to login wiht the Oracle, tha said tha my user or password is invalid
C:\Documents and Settings\c11adm>sqlplus
SQL*Plus: Release 9.2.0.7.0 - Production on Wed Aug 26 15:57:37 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
SQL> connect OPS$C11ADM/*******@C11
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
I'm not sure what happend
Cherios
As far as I have seen, in windows server, OPS$ user has hostname in it. Like
OPS$HOSTNAME_DBSERVER\SIDADM
But in your case from the list I can not see the hostname in the OPS$ users.
Please check note
https://service.sap.com/sap/support/notes/50088
There is a script attached to the note. ( oradbusr10.zip) ...Try to use that.
I ran the scrip as a note 50088
C:\Documents and Settings\c11adm>sqlplus /NOLOG @oradbusr.sql SAPC11 NT chavez-server
SQL*Plus: Release 9.2.0.7.0 - Production on Thu Aug 27 01:57:12 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected.
old 6: if length('&&1') = 5 then
new 6: if length('SAPC11') = 5 then
old 7: if substr(upper('&&1'),1,5) = 'SAPR3' then
new 7: if substr(upper('SAPC11'),1,5) = 'SAPR3' then
old 11: if upper('&&2') = 'NT' then
new 11: if upper('NT') = 'NT' then
old 18: :sDomain := upper('&&3');
new 18: :sDomain := upper('chavez-server');
Enter value for 4: C11
old 19: :sSapSid := upper('&&4');
new 19: :sSapSid := upper('C11');
old 21: :sSapSid := upper('&&3');
new 21: :sSapSid := upper('chavez-server');
old 37: :sSchema := upper('&&1');
new 37: :sSchema := upper('SAPC11');
old 39: if upper('&&2') = 'NT' then
new 39: if upper('NT') = 'NT' then
old 46: :sDomain := upper('&&3');
new 46: :sDomain := upper('chavez-server');
old 47: :sSapSid := upper('&&4');
new 47: :sSapSid := upper('C11');
old 49: :sSapSid := upper('&&3');
new 49: :sSapSid := upper('chavez-server');
using following Parameters:
.
. Oracle Version: 9.2.0.7.0
. Parametervalue os_authent_prefix: OPS$
. Schema Id: C11
. Database User (Schema): SAPC11
. SAP R/3 Administrator: OPS$C11ADM
. SAP R/3 Serviceuser: OPS$SAPSERVICEC11
. Domain/Host: CHAVEZ-SERVER
.
Connected.
Connected.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
after that i change the sapr3 password as note said
C:\Documents and Settings\c11adm>brconnect -u system/******* -f chpass -o sapr3 -p *******
BR0801I BRCONNECT 6.40 (51)
BR0280I BRCONNECT time stamp: 2009-08-27 01.59.25
BR0828I Changing password for database user SAPR3
BR0280I BRCONNECT time stamp: 2009-08-27 01.59.25
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:
cont
BR0280I BRCONNECT time stamp: 2009-08-27 01.59.35
BR0257I Your reply: 'cont'
BR0259I Program execution will be continued...
BR0280I BRCONNECT time stamp: 2009-08-27 01.59.35
BR0829I Password changed successfully in database for user SAPR3
BR0830I Password inserted successfully into table OPS$ADM.SAPUSER for user SAPR3
BR0830I Password inserted successfully into table OPS$C11ADM.SAPUSER for user SAPR3
BR0830I Password inserted successfully into table OPS$\C11ADM.SAPUSER for user SAPR3
BR0280I BRCONNECT time stamp: 2009-08-27 01.59.35
BR0802I BRCONNECT completed successfully
But ...... i have the SAME error when i execute "brconnect -u / -c -f crsyn -o SAPC11"
C:\Documents and Settings\c11adm>brconnect -u / -c -f crsyn -o SAPC11
BR0801I BRCONNECT 6.40 (51)
BR0280I BRCONNECT time stamp: 2009-08-27 01.59.48
BR0301E SQL error -1017 at location db_connect-2
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance C11 failed
BR0280I BRCONNECT time stamp: 2009-08-27 01.59.48
BR0804I BRCONNECT terminated with errors
Someone have any idea???
C:\Documents and Settings\c11adm>brconnect -u system/******* -f chpass -o sapr3 -p *******
Your Schema Owner is SAPC11 not SAPSR3.
Please change the password using below command.
brconnect -u system/******* -f chpass -o SAPC11 -p *******
Oracle Version: 9.2.0.7.0
. Parametervalue os_authent_prefix: OPS$
. Schema Id: C11
. Database User (Schema): SAPC11
. SAP R/3 Administrator: OPS$C11ADM
. SAP R/3 Serviceuser: OPS$SAPSERVICEC11
. Domain/Host: CHAVEZ-SERVER
Your System is using OPS$C11ADM user so change the password of this user..
Keep the both passwords same.
Hope this will help.
Thanks,
Shambo
> Also one step before i had a BRTools 7.00 error, downloaded the BRTools 640
> DBATL640O92_51-10004734.SAR DBATOOLS Package for Oracle 9.2.x
your problem is:
Those DBATools are
"Support Package SAP KERNEL 6.40_EX2 32-BIT Windows Server on IA32 32bit ORACLE"
The 640_EX2 kernel is linked against Oracle 10g, that's why you get
> This application has failed to start because orasql10.dll was not found. Re-installing the application may fix this problem
you have to download the DBATOOLS 640, not 640_EX2 if you use Oracle 9.2.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello again
i downloaded the DBA tools 640
and i got this error
INFO 2009-08-26 10:21:15
Working directory changed to C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\NUC\DB.
INFO 2009-08-26 10:21:15
Output of E:\usr\sap\C11\SYS\exe\run/brconnect -u / -c -f crsyn -o SAPC11 is written to the logfile brconnect.log.
WARNING 2009-08-26 10:21:15
Execution of the command "E:\usr\sap\C11\SYS\exe\run/brconnect -u / -c -f crsyn -o SAPC11" finished with return code 3. Output: BR0801I BRCONNECT 6.40 (51)BR0252E Function _popen() failed for '( F:\oracle\C11\920\bin\SQLPLUS /nolog ) < \nul 2>&1' at location BrPipeOpen-4BR0253E errno 2: No such file or directoryBR0272E Execution of program '( F:\oracle\C11\920\bin\SQLPLUS /nolog ) < \nul 2>&1' through pipe failedBR0303E Determination of Oracle version failed
ERROR 2009-08-26 10:21:16
CJS-00288 Could not update database statistics.<br>DIAGNOSIS: Command brconnect -u / -c -f crsyn -o SAPC11 returned 3.<br>SOLUTION: See brconnect.log for details.
and the brconnect log is the follow
BR0801I BRCONNECT 6.40 (51)
BR0252E Function _popen() failed for '( F:\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 '( F:\oracle\C11\920\bin\SQLPLUS /nolog ) < \nul 2>&1' through pipe failed
BR0303E Determination of Oracle version failed
BR0280I BRCONNECT time stamp: 2009-08-26 10.21.15
BR0804I BRCONNECT terminated with errors
>
> Can you execute that in a cmd.exe (as user <sid>adm)?
>
>
F:\oracle\C11\920\bin\SQLPLUS /nolog
>
>
>
> Markus
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\c11adm>F:\oracle\C11\920\bin\SQLPLUS /nolog
SQL*Plus: Release 9.2.0.7.0 - Production on Wed Aug 26 12:03:44 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL>
is working ....
Hi,
Please post the brconnect.log file.
Thanks,
Shambo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.