Skip to Content

ORA-01017: invalid username/password; logon denied

Dear All,

We are getting below mention error whlile executing brbackup command.

MMS51TST:s5tadm 6> brbackup

BR0051I BRBACKUP 7.00 (43)

BR0055I Start of database backup: bebpryzf.anf 2009-10-05 09.23.11

BR0484I BRBACKUP log file: /oracle/S5T/sapbackup/bebpryzf.anf

BR0280I BRBACKUP time stamp: 2009-10-05 09.23.11

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

'CONNECT system/*******'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance S5T failed

BR0280I BRBACKUP time stamp: 2009-10-05 09.23.11

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

'CONNECT system/*******'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance S5T failed

BR0056I End of database backup: bebpryzf.anf 2009-10-05 09.23.11

BR0280I BRBACKUP time stamp: 2009-10-05 09.23.11

BR0054I BRBACKUP terminated with errors

I have executed both sapdba_role.sql , sapconn_role.sql script and checked with

sqlplus /nolog

sql>conn /@SID

It's working fine

also we are able to connect with system user id with password.

As per note Note 400241,i also changed SAPSID password.

Kindly suggest

-Mahesh

Add a comment
10|10000 characters needed characters exceeded

Related questions

8 Answers

  • Best Answer
    Posted on Oct 05, 2009 at 08:12 AM

    Hi MAhesh,

    Just try this ..

    brbackup -u system/<your system user passowrd > -t online -c -m all -p init<SID>.sap

    Replace the above line eith you system user password & init<SID>.sap file name.

    Thanks

    Anil

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 05, 2009 at 05:16 AM

    Hi,

    Check below link:

    ORA-01017: invalid username/password; logon denied

    Thanks

    Sunny

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 07, 2009 at 06:26 AM

    Hi Mahesh,

    Try using this SQL command and it would allow you to log in as system user

    Connect to the database as sysdba

    sqlplus '/ as sysdba'

    then issue the following SQL

    ALTER USER SYSTEM ACCOUNT UNLOCK;

    If you want to change the password for system user then issue the following command

    ALTER USER SYSTEM IDENTIFIED BY <PASSWORD OF YOU CHOICE>;

    *Both these command should be issued by sys user .

    This would help you

    Regards

    Aditya

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 07:54 AM

    Hi,

    The core issue with an ORA-01017 error is an invalid user ID and passwords combination, but other than an incorrect password, there are user ID issues that may contribute to the ORA-01017 error:

    It may be that the user ID is invalid for the target system - The user ID exists as the username column in the dba_users view.

    select username from dba_users;

    Check your $ORACLE_SID environmental parameter. If your $ORACLE_SID is set to the wrong system ID then you may get a ORA-01017 error because you are connecting to the wrong database.

    If using external OS user authentication (ops$ or remote_os_authent) you need to verify that the user ID is valid. You can tell if you are using external authentication because you connect without providing a user/password combination, and only provide a forward slash to the connect string, (e.g. connect / as sysdba;).

    Check your tnsnames.ora to ensure that the TNS service name points to the correct server and instance name. If you specify an incorrect tnsnames.ora service name, then the user ID and password may not exist in that database

    Regards

    D.Mukunthan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 05, 2009 at 09:41 AM

    Lets clarify some of the answers and what you are doing:

    > MMS51TST:s5tadm 6> brbackup

    you are starting brbackup and you have not specify the user that will connect to the database.

    Therefore, BRBACKUP will try to connect as the database user SYSTEM, as you can see:

    > 'CONNECT system/*******'

    Brconnect tries to connect as user system but it does not know the password of this user, therefore it tries the default password. As you have changed the default password (as it should be) BRBACKU cannot connect because the password is wrong.

    > ORA-01017: invalid username/password; logon denied

    At this point there are no issues with roles, ops$ configuration and so on.

    The solution is "easy", as the other people has already indicated, you only have to start BRBACKUP indicating the user you want to connect with.

    > sqlplus /nolog

    > sql>conn /@SID

    > It's working fine

    OP$ is working fine, then use

    BRBACKUP -u /

    also is possible

    BRBACKUP -u system/<system password>

    and take a look at the documentation for the other parameters that you can use on the command line (please, do not use blindly any recommendation, understand it) The commands given:

    > brbackup -u system/<your system user passowrd > -t online -c -m all -p init<SID>.sap

    > brbackup -u system/password -p init<SID>.sap u2013t offline u2013m all

    are both valid but they do two different things, and you may want to do other thing

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2009 at 11:01 AM

    Login as ora<SID> and try again running the brbackup -c -u / -t offline.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Fidel Vales

      When you execute brbackup just by tiself it will take the default profile and all of the default values defined there.

      Either you change the default values in the profile inti<SID>.sap or you override the values by giving them in the command line.

      Pravin

  • author's profile photo Former Member
    Former Member
    Posted on Oct 07, 2009 at 05:53 AM

    Mahesh Bhai,

    i think you got the solution and its working fine.

    Regards,

    Koushal

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 08, 2011 at 07:00 AM

    Hey Mahesh,

    Close the thread now rey 😊

    The solution of using brbackup with option "-u /" i.e.

    brbackup -u / <other options>

    works absolutely fine

    If you check, this is the option used by SAP if we start the backup through DB13

    Regards,

    Ashutosh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.