TIP: SUM PREP_PRE_CHECK/PROFREAD BRCONNECT ERROR

Search tags:

“BR0301E SQL error -12154”
“ORA-12154: TNS:could not resolve the connect identifier specified”
“brconnect -u -c -f dbstate -RDB”

I have had this a few times now, documenting for future reference:

SUM PREP_PRE_CHECK/PROFREAD Fails for specified oracle SYSTEM user password.

Checking /usr/sap//SUM/abap/log/CHKSYSPWD.LOG

EXECUTING /usr/sap/OL6/SYS/exe/uc/rs6000_64/brconnect -u -c -f dbstate -RDB BR0801I BRCONNECT 7.40 (25) BR0280I BRCONNECT time stamp: 2017-08-15 13:32:41 BR0262I Enter database user name[/password]: BR0280I BRCONNECT time stamp: 2017-08-15 13:32:42 BR0301E SQL error -12154 at location db_connect-3, SQL statement: 'CONNECT SYSTEM/******@OL6' ORA-12154: TNS:could not resolve the connect identifier specified BR0310E Connect to database instance OL6 failed BR0280I BRCONNECT time stamp: 2017-08-15 13:32:42 BR0804I BRCONNECT terminated with errors

This tries to make you believe there is some TNS error.. While this CAN be the case, it is most likely not.

The used BRCONNECT was 7.40 patch 25

USING an older version of BRCONNECT show the reason:

hostnamesap01:ol6adm> brconnect -u // -c -f dbstate -RDB BR0801I BRCONNECT 7.40 (12) BR1301W Error message from rsec5lib: RSecSSFs: SSFS-1400: File "https://learntips.b-cdn.net/oracle/OL6/security/rsecssfs/data/SSFS_OL6.DAT" cannot be opened in mode "rb": Permission denied (errno = 13) [/bas/742_REL/src/krn/rsec/rsecssfs.c 1821] BR1528E Calling a function of library rsec5lib failed at location BrSsBrUsrPwdGet-2, return code -3 BR1301E Error message from rsec5lib: SSFS-1400: File "https://learntips.b-cdn.net/oracle/OL6/security/rsecssfs/data/SSFS_OL6.DAT" cannot be opened in mode "rb": Permission denied (errno = 13) BR1529E Getting BR*Tools user name/password from secure storage /oracle/OL6/security/rsecssfs/data/SSFS_OL6.DAT failed BR0280I BRCONNECT time stamp: 2017-08-15 13:59:42 BR0804I BRCONNECT terminated with errors

VERIFY the current permissions:

hostnamesap01:ol6adm>ls -l /oracle/OL6/security/rsecssfs/data/SSFS_OL6.DAT -rw------- 1 oraol6 dba 3408 Jun 7 09:46 /oracle/OL6/security/rsecssfs/data/SSFS_OL6.DAT 

FIXING the issue: (assuming sidadm is member of dba group)

hostnamesap01:oraol6>chmod 660 /oracle/OL6/security/rsecssfs/data/SSFS_OL6.DAT
 chmod 774 /usr/sap/OL6/SYS/exe/uc/rs6000_64/brconnect

VERIFY this WAS the problem (for sidadm):

hostnamesap01:ol6adm> brconnect -u // -c -f dbstate -RDB BR0801I BRCONNECT 7.40 (12) BR0280I BRCONNECT time stamp: 2017-08-15 14:01:50 BR0342I Database instance OL6 is open BR0280I BRCONNECT time stamp: 2017-08-15 14:01:50 BR0802I BRCONNECT completed successfully

NOW retry the SUM phase – and enjoy.