brconnect -u / -c -f stats -t all - Throwing error

[Former Member]

HI All,

Please find the below error I am getting from OS level when I am triggering the update stat from OS level.

brconnect -u / -c -f stats -t all
BR0801I BRCONNECT 7.40 (12)
BR0805I Start of BRCONNECT processing: ceqfkhit.sta 2015-04-05 05:45:19
BR0484I BRCONNECT log file: /oracle/XXX/sapcheck/ceqfkhit.sta

BR0280I BRCONNECT time stamp: 2015-04-05 05:45:20
BR0813I Schema owner found in database XXX: SAPSR3*
BR0280I BRCONNECT time stamp: 2015-04-05 05:45:20
BR0301E SQL error -1466 at location BrRsnspaceRXXX-2, SQL statement:
'OPEN curs_101 CURSOR FOR stmt_13'
'SELECT NAMESPACE, NSPACEGEN FROM "SAPSR3".RSNSPACE WHERE ACTIVE = 'X' ORDER BY NAMESPACE'
ORA-01466: unable to rXXX data - table definition has changed

BR0806I End of BRCONNECT processing: ceqfkhit.sta 2015-04-05 05:45:20
BR0280I BRCONNECT time stamp: 2015-04-05 05:45:20
BR0804I BRCONNECT terminated with errors

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

XXXadm> ls -l|grep br

-rwsrwxr--    1 oraXXX   dba        13385793 Mar 17 20:27 brarchive

-rwsrwxr--    1 oraXXX   dba        13542030 Mar 17 20:27 brbackup

-rwsrwxr--    1 oraXXX   dba        15952052 Mar 17 20:27 brconnect

-rwxr-x---    1 XXXadm   sapsys     14249766 Mar 17 20:27 brrecover

-rwxr-x---    1 XXXadm   sapsys      5847113 Mar 17 20:27 brrestore

-rwxr-x---    1 XXXadm   sapsys     16806620 Mar 17 20:27 brspace

-rwxr-x---    1 XXXadm   sapsys      6740867 Mar 17 20:27 brtools

[former_member189797 · Accepted solution]

Hello,

Could you check Note "1498109 - ORA-01466 in BRCONNECT after upgrade to Oracle 11g"
and see if it is applicable to your scenario.

Regards,
Gaurav

[Former Member · Accepted solution]

Hi Gourav,

Thanks for your reply. I have already used this as a correction. But can you please tell me why this is happening. I use this command and its working very fine.

brconnect -u / -c -f stats -t all -NRO (Working fine)

but is there any dependency with brarchive and brbackup as well. Could you please guide me here with brbackup and brarchive with this.

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

where brbackup is throwing this error.

BR0016I 0 offline redolog files processed, total size 0.000 MB
BR0280I BRARCHIVE time stamp: 2015-04-05 06:07:45
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

BR0007I End of offline redolog processing: aeqfkjhz.svd 2015-04-05 06:07:44
BR0280I BRARCHIVE time stamp: 2015-04-05 06:07:45
BR0005I BRARCHIVE terminated with errors

--------------?

you can check out this thread as well. The thread has been opened for this issue only.

http://scn.sap.com/thread/3721804

[former_member207186 · Accepted solution]

Hi,

Have you experienced this "ORA-01466" issue directly after upgrade? This issue may no longer occur after a certain amount of time, but you can also use the workaround described in the suggested SAP Note 1498109. The cause is also described in the note.

Regarding the "invalid username/password" issue, you can also refer to the SAP KBA 1576837 - "ORA-01017: invalid username/password". What is your kernel version? Are you using SSFS?

Regards,

Bíborka

[Former Member · Accepted solution]

Hi Biborka,

Thanks for the reply. As u can see that I have already used the -NRO option.

Now the issue lies in brbackup and brarchive.

Recently we did oracle client and kernel upgrade.

Kernel version - 721EXT. 300 patch level. with oracle client-

11.2.0.3 V2.

So is there any specific parameter forSSFS. How can i check

it.

[former_member182657]

Hi,

Now the issue lies in brbackup and brarchive. 

Are you using SSFS as database connection method ?

So is there any specific parameter for SSFS. How can i check
it.

For this could you share trans.log file from the system.If you're using SSFS as database connection method then you need to follow SAP Note   1764043 - Support for secure storage in BR*Tools

for successful DB connection with brbackup & brarchive commands.

Hope this will help you.

Good luck !!