cancel
Showing results for 
Search instead for 
Did you mean: 

brconnect error BR0301E SQL error -1017

Former Member
0 Kudos

Hi All,

I am having errors issuing the brconnect commands. For example, brconnect -f check is returning the error: *BR0301E SQL error -1017 at location db_connect-2, SQL statement:'CONNECT system/******* .*

I appreciate the fact that this may be a case of logon denied with the default user 'system' that brconnect uses. Issuing the same command as brconnect -u / -c -f check works fine and returns no error.

How do I fix this error? The platform is Oracle 10.2.0.2.0, Windows 2003 Server, ECC 6.0 Kernel 700-Patch Level 146.

Thanks in anticipation.

Akin.

Edited by: Akintunde Olorunsola on Oct 4, 2008 7:35 PM

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

I believe you have two separate questions here:

1. Why is the default without -"-u" failing - this is Br*tools try to use the default user-id and password SYSTEM/MANAGER to connect to the database. If you want this to work you will have to explicitly mention the user/password and the -u option "-u SYSTEM/<password>". Or else you will have to reset the password of SYSTEM to the original one:

alter user system identified by manager;

2. The answer to ur next question why this worksfine when using a "-u" option is because when you use a -u option the br*tools uses the OPS$ mechanism and not the default system user to log-in to the database.

Hope this helps.

- Regards, Dibya

debasissahoo
Active Contributor
0 Kudos

Hi,

As Madhukara has already explained the reason, have a look on SAP Note 562863, section 7.

Thanks,

Debasis.

madhukara_shenoy
Explorer
0 Kudos

Hi Akin,

If you don't mention the -u / option from the brconnect, then it will try to connect the database with the user

SYSTEM and it is default password MANAGER.

The above error indicates that you have changed the default password of the USER SYSTEM.

For the security reason many do so and they use -u / option of brconnect.

So now if you want to see the brconnect - check working you have to change the password of the database user system to 'MANAGER' or better continue using brconnect -u / .... option

Regards,

Madhukar

Former Member
0 Kudos

Thanks all for your prompt response.

I have not changed the password of the user SYSTEM, I only changed the password of the SAPSR3 user from the default 'SAP' . Could this have been responsible ? Do I revert to the default?

Please also note that other commands that need to call brconnect for their operations are also encountering this same error.

Regards,

Akin.

Former Member
0 Kudos

Hi,

I believe you havent used the right way to change the password of the database connect user SAPSR3 ,probably you have just changed it from the database level using an "alter user ..."

To allow continued logon of the R/3 work processes using the OPS$ mechanism, you must also change the password in the SAPUSER table. The simplest way of making a consistent change in the Oracle dictionary and in the

SAPSR3 table is to use the " -f chpass" option of brconnect, for example:

brconnect -f chpass -o sapsr3 -p <new_password>

Hope this will solve your issue. Also check the following notes for reference:

https://service.sap.com/sap/support/notes/562863

https://service.sap.com/sap/support/notes/400241

- Regards, Dibya

Former Member
0 Kudos

No Dibya, you are very wrong. I did not change the password for SAPSR3 user with 'alter user...... I made the change with brtools options.

I know that the SAP recommended way of changing passwords is via brconnect.

Akin.

0 Kudos

Hi,

I think Madhukara gave you the reason of your error.

So I'll try to rephrase it:

are you able to connect to your database using the following command:

> sqlplus system/manager

Former Member
0 Kudos

Thanks all for your input, I have the problem resolved. The account SYSTEM was locked.

Regards,

madhukara_shenoy
Explorer
0 Kudos

Hi,

Good to know that the problem resolved. The reason for the account lock may be because you have changed the default profile of the database user 'SYSTEM'. And also brconnect error might have been changed ORA-28000 instead of

ORA-01017.

Anyways .. good that problem is resolved.

Regards,

Madhukar