ORA-01017: invalid username/password; logon denied

[mahesh_phegade1]

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

[former_member227283 · Accepted solution]

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

[Former Member]

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

[former_member582060]

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

[Former Member]

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

[Former Member]

Mahesh Bhai,

i think you got the solution and its working fine.

Regards,

Koushal

[Former Member]

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

[former_member204746]

Read SAP note 400241.

[fidel_vales]

>

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

hi,

By default this does not work as you are logging with the ops$ora<sid> and this user must be created manually and is not recommended to use it.

and I wonder why everybody is giving EXACT commands to do "online" or "offline" backups but nobody knows what exactly the OP is trying to do. Canned answer may be not the correct one.

[Former Member]

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

[fidel_vales]

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

[sunny_pahuja2]

Hi,

Check below link:

Thanks

Sunny

[mahesh_phegade1]

HI Sunny

R3trans -dx

This is R3trans version 6.14 (release 700 - 12.06.09 - 15:20:00).

unicode enabled version

R3trans finished (0000).

-Mahesh

[Former Member]

Not sure if this is the root cause, but:

Why are you trying to run brbackup as user system ?

How do you call brbackup?

Instead of 'brbackup -u system/*****' try:

brbackup -u /

[Former Member]

Hi,

BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT system/*******'
ORA-01017: invalid username/password; logon denied

You are using worng command. Please see the below link

You can use command

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

[http://basissap.blogspot.com/2008/06/importanat-database-command-brtool-and.html]

Thanks,

Shambo