1860519 - SAP fails to connect to the database | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1860519 - SAP fails to connect to the database

Symptom

Several errors may bee seen due to the same issue, see below expected behaviour.

  • You are able to tnsping your database instance
  • R3trans -d (x) works with <sid>adm
  • SAP doesn't start with the one of the following errors:

Error 1: Wrong Oracle client version is used (it may happen with any older client version):

M Wed Mar 27 11:05:37 2013
M  ThInit: running on host devsap
M  calling db_connect ...
B  Loading DB library '/usr/sap/<SID>/SYS/exe/run/dboraslib.o' ...
B  Library '/usr/sap/<SID>/SYS/exe/run/dboraslib.o' loaded
B  Version of '/usr/sap/<SID>/SYS/exe/run/dboraslib.o' is "720.00", patchlevel (0.any)
C  Register application info.
C  Oracle client version: 10.2.0.5.0, (dbsl 720 051012, UNICODE[2])
C  Detailed Oracle client (patch) info not available.
C  Oracle instant client is out-of-date or not delivered by SAP.
C  See SAP note 819829 for more info.
C  Nls CharacterSet                      NationalCharSet                   EnvHp            ErrHp            ErrBt          
C    0 UTF16                             AL16UTF16                         0000NULL         0000NULL         0000NULL       
B  ***LOG BY2=> sql error -1     performing CON [dbsh         1246]
B  ***LOG BY0=> OCI returned error code -1. [dbsh         1246]
B  ***LOG BY2=> sql error -1     performing CON [dblink       544]
B  ***LOG BY0=> OCI returned error code -1. [dblink       544]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1483]
M  in_ThErrHandle: 1
M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11309]

Error 2: ORA-12154: TNS:could not resolve service name

C  Register application info.
C  Oracle client version: 11.2.0.2.0, V1, default build, (dbsl 720 220313, UNICODE[2])
C  Installed Oracle client patches:
C  # Patch  9930315      : Created on 18 Nov 2010, 02:00:12 hrs PST8PDT
C  # Patch  10302309     : Created on 23 Nov 2010, 12:10:03 hrs CET
C  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
C  Logon as OPS$-user to get SAPR3's password
C  Connecting as /@<SID> on connection 0 (nls 0) ... (dbsl 720 220313, UNICODE[2])
C  Attaching to database server <SID> (con=0, svchp=114443488, srvhp=114446670)
C     OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154:
C     ORA-12154: TNS:could not resolve the connect identifier specified                                                            
C  *** ERROR => CONNECT failed with sql error '12154'
 [dbsloci.c    15344]
C  SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=12154.
B  ***LOG BV3=> severe db error 12154     ; work process is stopped [dbsh         1241]
B  ***LOG BY2=> sql error 12154  performing CON [dblink       544]
B  ***LOG BY0=> ORA-12154: TNS:could not resolve the connect identifier specified [dblink       544]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1483]
M  in_ThErrHandle: 1
M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11309]

Error 3: ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/<SID>/SYS/exe/run/dboraslib.o") FAILEDD

R3trans -d (-x|-xd) test results in the following error:

This is R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).
2EETW169 no connect possible: "maybe someone set invalid values for
DIR_LIBRARY ('/usr/sap/<SID>/SYS/exe/run') or dbms_type ('ORA')"
R3trans finished (0012).

The trans.log file shows the following:

4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000  trace at level 2 opened for a given file pointer
4 ETW000  [     dev trc,00000]  Fri May 31 04:41:34 2013                                                  63  0.000063
4 ETW000  [     dev trc,00000]  db_con_init called                                                         9  0.000072
4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        24  0.000096
4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000                                                                                                  12  0.000108
4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                  7  0.000115
4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/<SID>/SYS/exe/run/dboraslib.o' ...             28  0.000143
4 ETW000  [    dlux.c  ,00000]  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/<SID>/SYS/exe/run/dboraslib.o") FAILED
4 ETW000                          "Permission denied"  (errno=13,Permission denied)                      404  0.000547
4 ETW000  [    dbcon.c ,00000]  *** ERROR => Couldn't load library '/usr/sap/<SID>/SYS/exe/run/dboraslib.o'
4 ETW000                                                                                                  22  0.000569
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/<SID>/SYS/exe/run') or dbms_type ('ORA')"

Error 4: ORA-01017: invalid username/password; logon denied

This error might happen in case you are using SSFS on your login mechanism. Also the two errors bellow might show up: 

ORA-28000: the account is locked

ORA-28001: the password has expired

These errors may be seen in order occasions than starting the system, like performing a transport or during an upgrade, due to the same issue.


Read more...

Environment

  • SAP Kernel 720
  • Oracle database
  • UNIX or Linux operating system

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

start, fail, database, connection, connectivity, stuck, abort, startup, initializing, crash, db, logon, login, break, passwd, pwd , KBA , BC-DB-ORA-SYS , Database Interface / DBMS for Oracle , BC-CST-STS , Startup Service , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.