Brarchive failing due to user issue- command brarchive -u /

[Former Member]

We have done the kernel upgrade recently in this system. But the back up is failing .Please help.

oraead> brarchive -u /
BR0002I BRARCHIVE 7.40 (12)
BR0006I Start of offline redolog processing: aeqesiur.svd 2015-04-01 13:08:57
BR0484I BRARCHIVE log file: /oracle/EAD/saparch/aeqesiur.svd
BR0280I BRARCHIVE time stamp: 2015-04-01 13:08:57
BR0301W SQL error -1017 at location BrDbConnect-3, SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied
BR0310W Connect to database instance EAD failed
BR0280I BRARCHIVE time stamp: 2015-04-01 13:08:57
BR0301W SQL error -1017 at location BrDbConnect-3, SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied
BR0310W Connect to database instance EAD failed
BR0278W Command output of '/oracle/EAD/112_64/bin/sqlplus /nolog < /oracle/EAD/saparch/.aeqesiur.spi':

SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 1 13:08:57 2015

[Johan_sapbasis · Accepted solution]

Hi,

If you have done a kernel upgrade your br* tool permissions is probably incorrect now. If you are on linux you can run saproot.sh with root user or user with root priveleges.

Executing the saproot.sh Script - Java Support Package Manager (OBSOLETE) - SAP Library

Also check your DB user and password in the database it is saying it is incorrect logon details.

ORA-01017: invalid username/password; logon denied

1576837 - ORA-01017: invalid username/password

Kind Regards,

Johan

[Former Member · Accepted solution]

Hi Nicolas,

I have checked both Br* permissions and the Note you provided. But the problem is I am getting an error while I run the command brbackup -u / , so as I know -u / means its  using the OPS$ authentication as OS level.

Could you please tell me how can I set or change password at all place in sequential manner so that the problem can be corrected. I think the NOTE you provided ,our condition shows the Section B issue of the Note.

Thanks.

[Former Member · Accepted solution]

Hello Biswajit,

If you want to update the password for OPS$ user, proceed as follows :

the OPS$ checks for correct schema password in sapuser table,

If you need to insert the password in sapuser table, use the command below

INSERT INTO "OPS$<SID>ADM".SAPUSER VALUES ('SAPSR3', 'password');

If you need to change the schema password, always use brtools for consistency.

You can also try using system user and password to trigger brarchive with the following command

brarchive -u system / password.

Do let me know if this works.

[Former Member · Accepted solution]

Hi ,

I did this in this sequence ,Please check. I hope one restart is required for the step.

Changing the sidadm password and orasid password
========================================
alter user system identified by xxxx2020;
exit
========================================
brconnect -u system/xxxx2020 -f chpass -o sapsr3 -p xxxx2020

INSERT INTO "OPS$EADADM".SAPUSER VALUES ('SAPSR3', 'xxxx2020');
  

[Former Member]

Hi All,

The issue has solved.

The solution of the issue is described earlier as well.

Thanks

Regards,

Biswajit

[Reagan]

A quick question.

What is the kernel version used on the system? I see you are using BR*Tools version 7.40. If you are using 7.40 kernel release then OPS$ is not valid. You should setup SSFS.

If you are on older kernel and using OPS$ then start with the SAP note 400241 - Problems with ops$ or sapr3 connect to Oracle

You should not update the password in the SAPUSER table from the SQL after changing the password using brconnect. This will overwrite the brconnect password change entry in the table.

All you need to do is update the password using brconnect.

For ORA-01031: insufficient privileges error run the sapdba_role.sql script.

Cheers

RB

[Former Member]

HI Reagan,

Thanks for your reply. But I hope now the issue might be different. Can you please check this error.

Here I have used system/xxxx2015 - password.

----------------------------------------------------------------------------------------------------------------------

/oracle/EAD/112_64/dbs/initEAD.utl.archive -u system/xxxxx2015                                                      <
BR0002I BRARCHIVE 7.40 (12)
BR0006I Start of offline redolog processing: aeqfpqyf.svd 2015-04-06 07:58:05
BR0484I BRARCHIVE log file: /oracle/EAD/saparch/aeqfpqyf.svd
BR0477I Oracle pfile /oracle/EAD/112_64/dbs/initEAD.ora created from spfile /oracle/EAD/112_64/dbs/spfileEAD.ora

BR0280I BRARCHIVE time stamp: 2015-04-06 07:58:06
BR0008I Offline redolog processing for database instance: EAD
BR0009I BRARCHIVE action ID: aeqfpqyf
BR0010I BRARCHIVE function ID: svd
BR0048I Archive function: save_delete
BR0011I 3 offline redolog files found for processing, total size 354.715 MB
BR0130I Backup device type: util_file
BR0109I Files will be saved by backup utility at file level
BR0126I Unattended mode active - no operator confirmation required

BR0280I BRARCHIVE time stamp: 2015-04-06 07:58:06
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of '/usr/sap/EAD/SYS/exe/run/backint -u EAD -f backup -i /oracle/EAD/saparch/.aeqfpqyf.lst -t file -p /oracle/EAD/112_64/dbs/initEAD.utl.archive -c':
ANS0102W Unable to open the message repository /usr/bin/EN_US/tsmerp.cat. The American English repository will be used instead.
Unable to open the message repository '/usr/bin/EN_US/tsmerp.cat'.  rc = 610

BR0280I BRARCHIVE time stamp: 2015-04-06 07:58:06
BR0279E Return code from '/usr/sap/EAD/SYS/exe/run/backint -u EAD -f backup -i /oracle/EAD/saparch/.aeqfpqyf.lst -t file -p /oracle/EAD/112_64/dbs/initEAD.utl.archive -c': 2

BR0232E 0 of 3 files saved by backup utility

BR0280I BRARCHIVE time stamp: 2015-04-06 07:58:06
BR0231E Backup utility call failed

BR0016I 0 offline redolog files processed, total size 0.000 MB

BR0007I End of offline redolog processing: aeqfpqyf.svd 2015-04-06 07:58:06
BR0280I BRARCHIVE time stamp: 2015-04-06 07:58:06
BR0005I BRARCHIVE terminated with errors

--------------------------------------------

Thanks

Regards,

Biswajit.

[former_member207186]

Hi,

You can also perform the steps of section 'General checks' of SAP Note 400241 for troubleshooting.

For the simplest and safest way of consistent password change, please check carefully point 5 and 7 of SAP Note 562863 - "FAQ: Logon mechanisms".

You can also refer to SAP KBA 1576837 - "ORA-01017: invalid username/password".

Regards,

Bíborka

[Johan_sapbasis]

Hi,

Access SQLPLUS:

See the status of all your users:

select username, account_Status from dba_users;

Run this is user is locked:

alter user SAPSR3 account unlock;

Run the command again to see now that it is unlocked:

select username, account_status from dba_users;

If you do not know the password at all you will have to change it to a new one as per section C of sap note, note comment about restart:

Solution: Please change the password as follows (SAP must be stopped) to do this, please run the following command

brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

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

Do this only if you are prepared for the system to possibly require a restart!!

If you can access SQLplus to change password to current already existing password i.e. old password (this is if you are sure you know the password but for some reason user us locked)

Check status of user and hash value password:

select username,password from dba_users where username='SAPSR3';

You will get result like this:

USERNAME PASSWORD

-------- ----------------

SAPSR3 F894844C34402B67

Then you set it to old/current password this means no actual change is taken place you are are setting the same password as you already think you know it.

alter user SAPSR3 identified by values 'F894844C34402B67';

Now try again your commands if you set old password it should work.

Kind Regards,

Johan

[Former Member]

Hi ,

I did this in this sequence ,Please check. I hope one restart is required for the step.

Changing the sidadm password and orasid password
========================================
alter user system identified by xxxx2020;
exit
========================================
brconnect -u system/xxxx2020 -f chpass -o sapsr3 -p xxxx2020

INSERT INTO "OPS$EADADM".SAPUSER VALUES ('SAPSR3', 'xxxx2020');
 

[Former Member]

Check this as well. Now I am getting this error.

oraead> brarchive -u sapsr3/xxxx2020
BR0002I BRARCHIVE 7.40 (12)
BR0006I Start of offline redolog processing: aeqevrgi.svd 2015-04-02 05:22:56
BR0484I BRARCHIVE log file: /oracle/EAD/saparch/aeqevrgi.svd
BR0280I BRARCHIVE time stamp: 2015-04-02 05:22:56
BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:
'CONNECT sapsr3/********* AT PROF_CONN IN SYSOPER MODE'
ORA-01031: insufficient privileges
BR0303E Determination of Oracle version failed

BR0007I End of offline redolog processing: aeqevrgi.svd 2015-04-02 05:22:56
BR0280I BRARCHIVE time stamp: 2015-04-02 05:22:56
BR0005I BRARCHIVE terminated with errors.

---------------------------------------------------

SQL> select grantee, granted_role, default_role from dba_role_privs where grantee = 'OPS$EADADM';

GRANTEE                        GRANTED_ROLE                   DEF
------------------------------ ------------------------------ ---
OPS$EADADM                     RESOURCE                       YES
OPS$EADADM                     SAPDBA                         YES
OPS$EADADM                     CONNECT                        YES

---------------------------------------------------------------------------------------------------------------

SQL> select grantee,granted_role,default_role
from dba_role_privs
where grantee = 'SAPSR3';  2    3

GRANTEE                        GRANTED_ROLE                   DEF
------------------------------ ------------------------------ ---
SAPSR3                         SAPCONN                        YES

----------------------------------------------------------------------------------------

Now guide me what should be the issue.

[Former Member]

Hi,

Try with system user instead of schema user

[Former Member]

brbackup -u SYSTEM/xxxx2020
BR0051I BRBACKUP 7.40 (12)
BR0055I Start of database backup: beqevxxl.anf 2015-04-02 06:37:57
BR0484I BRBACKUP log file: /oracle/EAD/sapbackup/beqevxxl.anf
BR0280I BRBACKUP time stamp: 2015-04-02 06:37:57
BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:
'CONNECT SYSTEM/********* AT PROF_CONN IN SYSOPER MODE'
ORA-01031: insufficient privileges
BR0303E Determination of Oracle version failed

BR0056I End of database backup: beqevxxl.anf 2015-04-02 06:37:57
BR0280I BRBACKUP time stamp: 2015-04-02 06:37:57
BR0054I BRBACKUP terminated with errors

==================================================

brbackup -u system/xxxx2020
BR0051I BRBACKUP 7.40 (12)
BR0055I Start of database backup: beqevxvn.anf 2015-04-02 06:37:07
BR0484I BRBACKUP log file: /oracle/EAD/sapbackup/beqevxvn.anf
BR0280I BRBACKUP time stamp: 2015-04-02 06:37:07
BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:
'CONNECT system/********* AT PROF_CONN IN SYSOPER MODE'
ORA-01031: insufficient privileges
BR0303E Determination of Oracle version failed

BR0056I End of database backup: beqevxvn.anf 2015-04-02 06:37:07
BR0280I BRBACKUP time stamp: 2015-04-02 06:37:07
BR0054I BRBACKUP terminated with errors

-----------------------------------------------------------------

please check. I think the issue must be different.

[former_member207186]

Hi,

Regarding this "insufficient privileges" issue, you can also check the SAP Notes

480266 - "Problems with SYSDBA/SYSOPER/INTERNAL connect"

700548 - "FAQ: Oracle authorizations"

562863 - "FAQ: Logon mechanisms"

Regards,

Bíborka

[Former Member]

Hi Soumya,

Can you please tell me the correct LIBPATH , for any system.

env shows me this path :

----------------------------------------

LIBPATH=/usr/lib:/lib:/usr/sap/EAD/SYS/exe/run:/usr/sap/EAD/SYS/exe/rs6000_64:/oracle/client/11x_64/instantclient

----------------------------------

where

sapcontrol -nr 00 -function GetEnvironment, shows...

LIBPATH=/usr/sap/EAD/DVEBMGS00/exe:/usr/lib:/lib:/usr/sap/EAD/SYS/exe/run:/usr/sap/EAD/SYS/exe/rs6000_64:/oracle/client/11x_64/instantclient

Please help me to set the correct environment variable.

[former_member207186]

Hi,

You can check the correct "LIBPATH" and the environment variable settings as per SAP Notes 602843 and 830578.

Regards,

Bíborka

[JamesZ]

Hi ,

let brarchive use system user to perform action. Regarding error ORA-01031, please make sure
ora<sid> and <sid>adm users are in the right os groups as per SAP note 113747.

Best regards,
James