1860519 - SAP fails to connect to the database

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...

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

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

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