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/<SID>/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 "/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 "/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.
