SAP ECC 60 installation - BR connect issue

[Former Member]

Hi,

During installation, installation has stopped with the error.

Execution of the command "D:\usr\sap\TEC\SYS\exe\uc\NTI386\brconnect.exe -u / -c -f crsyn -o SAPSR3" finished with return code 3. Output: BR0801I BRCONNECT 7.00 (13)BR0280I BRCONNECT time stamp: 2007-04-18 10.44.30BR0301E SQL error -1017 at location db_connect-2ORA-01017: invalid username/password; logon deniedBR0310E Connect to database instance TEC failed

SAP ECC 6.0 IDES unicode on Windows server on oracle 10.2g

Can anyone help me to solve this error? Thanks,

Regards,

Sundar.

[former_member618758]

Hi,

Like I said brconnect.exe -u / -c -f

Means brconnect uses OPS$ user (/) mechanism to assign a password other

than 'sap' to the user 'sapr3' in the SAP System. This prevents

unauthorized access to the database. So forget about sap<sid> user now.

sqlplus / failed means you had problem with OPS$ user, you should follow the note I gave on Creating OPS$ users, and make sure pass the sqlplus / test first.

Only when the OPS$ user has already been created as described above, the

password for the 'sap<sid>' user can be changed at any time. And apprently you are having SAPSR3 and SAPTEC 2 users, SAPTEC is not found, you need to make sure the user/schema you use is correct one.

George

[Former Member]

Hi,

Thanks, I tried with the user SAPSR3 and it executed successfully.

D:\oracle\TEC\102\RDBMS\ADMIN>brconnect -u system/manager -f chpass -o sapsr3 -p

init12345

BR0801I BRCONNECT 7.00 (13)

BR0280I BRCONNECT time stamp: 2007-04-18 16.56.06

BR0828I Changing password for database user SAPSR3

BR0280I BRCONNECT time stamp: 2007-04-18 16.56.06

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:

c

BR0280I BRCONNECT time stamp: 2007-04-18 16.56.21

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRCONNECT time stamp: 2007-04-18 16.56.21

BR0829I Password changed successfully in database for user SAPSR3

BR0830I Password inserted successfully into table OPS$TECADM.SAPUSER for user SAPSR3

BR0280I BRCONNECT time stamp: 2007-04-18 16.56.22

BR0802I BRCONNECT completed successfully

But even after this, sqlplus / is giving errors.

I am confused about the note 50088. It talks about 4.x sap versions and oracle 8.x versions. But I am installating ECC 60 IDES unicode on oracle 10.2 version. If I looked at other logs, it says ops$ is created successfully.

BTW, how do I contact SAP for installation issues. Do I have to go thru service website or any other phone numbers? Please let me know.

Regards,

Sundar.

[former_member618758]

Hi,

Glad this works.

Go to To http://service.sap.com>; Help&Support> Report a Product Error - Customer Messages> New Problem Solving Request and follow the link to complete the request.

George

[Former Member]

Hi George,

Thanks for the link, I will try that. But I am still confused. I looked at the other OSS note 400241 for brconnect issues. I checked all of them listed in the oss notes, I got the positive answers for all the queires as expected.

But the ABAP schema user is SAPSR3, but I don't have any idea why it is like this. This oss notes says, the user id should be SAP<SID>, in my case it should be SAPTEC.

I checked the keydb.xml, that also contains SAPSR3 as abapschema (which was displayed during installation as well, but it never asked to give the name for abapschema, it was displayed as defualt and i accepted as it is).

My question, does it have to be SAPTEC or SAPSR3. But there is no db users in oracle as SAPTEC, but SAPSR3 exists. SAPSR3 is also dbs_ora_schema in the environment variable.

If it has to be SAP<SID>, then how do I change SAPSR3 to SAP<SID>. and how many places do I have to change this?

Please let me know. Thanks,

[Former Member]

Hi,

OK, I did create users as per 50088, but still got the same errror. Can anyone help me on this? Thanks,

Regards,

Sundar.

[Former Member]

can you please try to run

sqlplus "/ as sysoper"

with the same OS User you are trying to start brconnect with?

peter

[Former Member]

Hi,

Yes I could connect to sqlplus using sysoper.

I uninstalled SAP, oracle yesterday and reinstalled with different sid (TE2) and the installation stopped exactly at the same place (POST LOAD ACtivities) with exactly same error BRCONNECT failed.

I followed everything as per OSS notes 400241 - I checked each and every SQL they asked to test, everything returns postive result.

I am really clueless what to do at this time.

As George mentioned, sqlplus / command still doesn't work.

George, I am still not sure about oss notes 50088, but I did the last step of the oss notes, where it says do it if kernel version > 4.6d, since this case kernel is 7.00. But the command is meant for oracle 8.1.7, it is not the case for my installation. Oracle is 10.2g. But I executed even this, it runs successfully.

brconnect.exe -u / -c -f crsyn -o SAPTE2

I even tried the above command at the command level, I got the same error.

C:\Documents and Settings\te2adm>brconnect.exe -u / -c -f crsyn -o SAPTE2

BR0801I BRCONNECT 7.00 (13)

BR0280I BRCONNECT time stamp: 2007-04-20 08.49.42

BR0301E SQL error -1017 at location db_connect-2

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance TE2 failed

BR0280I BRCONNECT time stamp: 2007-04-20 08.49.42

BR0804I BRCONNECT terminated with errors

Can anyone help me on this? Thanks,

[former_member204746]

try:

brconnect.exe -u system/manager -c -f crsyn -o SAPTE2

[Former Member]

Hi George,

Thanks for your help. After 2 days to effort, Now the sqlplus / works. but r3trans -d give error.

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPTE2's password 89 0.148892

4 ETW000 [dev trc ,00000] Connecting as /@TE2 on connection 0 (nls_hdl 0) ... (dbsl 700 240106)

4 ETW000 79 0.148971

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 52 0.149023

4 ETW000 [dev trc ,00000] 0 UTF8 1 02D4D000 02D52534 02D51DBC

4 ETW000 44 0.149067

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 6192 0.155259

4 ETW000 [dev trc ,00000] Allocating server context handle 95 0.155354

4 ETW000 [dev trc ,00000] Attaching to DB Server TE2 (con_hdl=0,svchp=02D51D08,svrhp=02D6357C)

4 ETW000 153 0.155507

4 ETW000 [dev trc ,00000] Assigning server context 02D6357C to service context 02D51D08

4 ETW000 72405 0.227912

4 ETW000 [dev trc ,00000] Allocating user session handle 126 0.228038

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=02D51D08,srvhp=02D6357C,usrhp=02D9EC50)

4 ETW000 177 0.228215

4 ETW000 [dev trc ,00000] Assigning user session 02D9EC50 to service context 02D51D08

4 ETW000 66228 0.294443

4 ETW000 [dev trc ,00000] Now '/@TE2' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 1934 0.296377

4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-942 when accessing table SAPUSER

Could anyone help?

Regards,

Sundar.

[former_member618758]

Hi,

Sorry for the late reply I was on vacation for a few days.

Can you run the sql command:

SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

And let me know the result?

Thanks,

George

[Former Member]

Ok, I applied the oss notes 50088, but the command ends with error:

D:\oracle\TEC\102\RDBMS\ADMIN>brconnect -u system/manager -f chpass -o saptec

init12345

BR0801I BRCONNECT 7.00 (13)

BR0925I Public synonym SAP_SDBAH created successfully for table SAPSR3.SDBAH

BR0925I Public synonym SAP_SDBAD created successfully for table SAPSR3.SDBAD

BR0925I Public synonym SAP_MLICHECK created successfully for table SAPSR3.MLIC

CK

BR0925I Public synonym SAP_SAPLIKEY created successfully for table SAPSR3.SAPL

EY

BR0925I Public synonym SAP_DBAML created successfully for table SAPSR3.DBAML

BR0925I Public synonym SAP_DBARCL created successfully for table SAPSR3.DBARCL

BR0925I Public synonym SAP_DBAFID created successfully for table SAPSR3.DBAFID

BR0925I Public synonym SAP_DBAEXTL created successfully for table SAPSR3.DBAEX

BR0925I Public synonym SAP_DBAREOL created successfully for table SAPSR3.DBARE

BR0925I Public synonym SAP_DBABARL created successfully for table SAPSR3.DBABA

BR0925I Public synonym SAP_DBADFL created successfully for table SAPSR3.DBADFL

BR0925I Public synonym SAP_DBAOPTL created successfully for table SAPSR3.DBAOP

BR0925I Public synonym SAP_DBASPAL created successfully for table SAPSR3.DBASP

BR0925I Public synonym SAP_DBABD created successfully for table SAPSR3.DBABD

BR0925I Public synonym SAP_DBABL created successfully for table SAPSR3.DBABL

BR0925I Public synonym SAP_DBATL created successfully for table SAPSR3.DBATL

BR0925I Public synonym SAP_DBAOBJL created successfully for table SAPSR3.DBAOB

BR0925I Public synonym SAP_DBAPHAL created successfully for table SAPSR3.DBAPH

BR0925I Public synonym SAP_DBAGRP created successfully for table SAPSR3.DBAGRP

BR0925I Public synonym SAP_DBAERR created successfully for table SAPSR3.DBAERR

BR0925I Public synonym SAP_DBATRIAL created successfully for table SAPSR3.DBAT

AL

BR0925I Public synonym SAP_DBSTATC created successfully for table SAPSR3.DBSTA

BR0925I Public synonym SAP_DBSTATTORA created successfully for table SAPSR3.DB

ATTORA

BR0925I Public synonym SAP_DBSTATIORA created successfully for table SAPSR3.DB

ATIORA

BR0925I Public synonym SAP_DBSTATHORA created successfully for table SAPSR3.DB

ATHORA

BR0925I Public synonym SAP_DBSTAIHORA created successfully for table SAPSR3.DB

AIHORA

BR0925I Public synonym SAP_DBCHECKORA created successfully for table SAPSR3.DB

ECKORA

BR0925I Public synonym SAP_DBMSGORA created successfully for table SAPSR3.DBMS

RA

BR0925I Public synonym SAP_TGORA created successfully for table SAPSR3.TGORA

BR0925I Public synonym SAP_IGORA created successfully for table SAPSR3.IGORA

BR0925I Public synonym SAP_TSORA created successfully for table SAPSR3.TSORA

BR0925I Public synonym SAP_TAORA created successfully for table SAPSR3.TAORA

BR0925I Public synonym SAP_IAORA created successfully for table SAPSR3.IAORA

BR0925I Public synonym SAP_SVERS created successfully for table SAPSR3.SVERS

BR0925I Public synonym SAP_DD02L created successfully for table SAPSR3.DD02L

BR0925I Public synonym SAP_DD09L created successfully for table SAPSR3.DD09L

BR0925I Public synonym SAP_DDNTT created successfully for table SAPSR3.DDNTT

BR0925I Public synonym SAP_DBCHK created successfully for table SAPSR3.DBCHK

BR0925I Public synonym SAP_DBDIFF created successfully for table SAPSR3.DBDIFF

BR0824E Owner SAPTEC not found in database or not SAP owner

BR0182E Checking parameter/option 'chpass_owner/-o' failed

BR0280I BRCONNECT time stamp: 2007-04-18 16.20.38

BR0804I BRCONNECT terminated with errors

D:\oracle\TEC\102\RDBMS\ADMIN>

Are there any other OSS notes that I need to apply before applying this one? Please let me know. Thanks for your help.

[Former Member]

No, I got the error.

D:\oracle\TEC\102\RDBMS\ADMIN>sqlplus /

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Apr 18 16:13:59 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

[Former Member]

Hi,

where do we set the password for abap schema? in my case the schema is SAPSR3. I don't remember setting this value (password) during installation.

Can anyone let me know if there is a default password for this abap schema? Thanks,

Regards,

Sundar.

[former_member618758]

Hi,

Ok now we were/are dealing with 2 problems.

Once was db startup problem and apprently is solved now.

The second one is the BR0301E SQL error -1017 problem.

From statement brconnect.exe -u / -c -f

Which means brconnect is using ops$ user for the ora<sid> to login, this back to my question to you before which was not answered:

Can you run sqlplus / in the command line?

If not you need to check that the ops$ user is correct: Note 50088. After that, the problem should be solved.

George

[Former Member]

Hi,

I did all the steps; as per you reply and as per sap oss notes.

I still got the same error:

BR0801I BRCONNECT 7.00 (13)

BR0280I BRCONNECT time stamp: 2007-04-18 15.28.35

BR0301E SQL error -1017 at location db_connect-2

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance TEC failed

BR0280I BRCONNECT time stamp: 2007-04-18 15.28.35

BR0804I BRCONNECT terminated with errors

I looked at other logs, it tries to logon using the user SAPSR3. I need to know where, what profiles / authorizations to be set for this user id, if that is the issue.

Regards,

Sundar.

[Former Member]

This is the oracle trace for this sap:

Dump file d:\oracle\tec\saptrace\usertrace\tec_ora_3924.trc

Wed Apr 18 13:45:13 2007

ORACLE V10.2.0.2.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

Windows Server 2003 Version V5.2 Service Pack 2

CPU : 2 - type 586, 2 Physical Cores

Process Affinity : 0x00000000

Memory (Avail/Total): Ph:3260M/3839M, Ph+PgF:10887M/11870M, VA:1264M/2047M

Instance name: tec

Redo thread mounted by this instance: 1

Oracle process number: 13

Windows thread id: 3924, image: ORACLE.EXE (SHAD)

• SERVICE NAME:(SYS$USERS) 2007-04-18 13:45:13.187

• SESSION ID:(85.3) 2007-04-18 13:45:13.187

tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)

tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

[former_member618758]

Hi,

Ok I think I know what's wrong.

Starting in 10.2, we have a new check to be sure that the data

dictionary version and the instance version are the same, in order to

open the database for normal operation. If you shutdown the database before running catalog and catproc, you need to open the database in UPGRADE mode, and run both those scripts, before trying to open the database for normal use. Refer the below note:

582427 - Error due to inconsistent Oracle DDIC

I think this should be it.

Thanks,

George

[Former Member]

Hi,

Thanks, It ends with error. I am really wondering why these errors are appearing. The installation was going smoothly and I got one error and I am full of errors. Are there any issues with installation? or I am missing something here.

Please let me know.

Regards,

Sundar.

D:\>sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Apr 18 13:44:51 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 633339904 bytes

Fixed Size 1291036 bytes

Variable Size 327159012 bytes

Database Buffers 301989888 bytes

Redo Buffers 2899968 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

SQL>

[Former Member]

Hi,

Thanks, I will try. But I restarted the server, even sqlplus is not working now.

I am getting the following error.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

I am using sqlplus system/manager@tec

I used logon to sqlplus before restart the server.

Could anyone help me to fix this? I am really frustrated with these errors from both sap and oracle. I would like to complete this installation (crap) and start working on others. Thanks for your help.

[former_member618758]

Hi,

Try to go to command line and type:

sqlplus "/ as sysdba"

then

startup

Are you able to startup the dbs?

George

[former_member618758]

Hi Sundar,

Please make sure loging on with a local user when the installation is done for the local machine?

You can also check that the ops$ user is correct: Note 50088.

If you changed the sapr3 password recently, also note 8523.

Make sure you can run sqlplus / and sqlplus sapr3/pwd from SIDadm and SAPService<SAPSID>.

Check 'Rights' to choose the option 'Log on Locally' from windows User Administration >Policies >User Rights

Once you have made the above changes run the sapdba_role.script

(134592)

Thanks,

George