Skip to Content

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

 

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.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply