Skip to Content
avatar image
Former Member

brconnect error BR0301E SQL error -1017

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 04, 2008 at 06:48 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Oct 04, 2008 at 09:40 PM

    Hi,

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

    Thanks,

    Debasis.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 05, 2008 at 07:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded