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
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 , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.