2EETW169 no connect possible: "DBMS = ORACLE --- ...

Former Member · ‎05-27-2015

Hi Experts,

Recently I have performed an installation and then mannual restore using control file. Earlier my SID was different but this time I have installed with different SID, but I am facing issues. My SAP is not running with the screen shot attached. I have searched various notes and forums on SCN and SMP but according to it my OPS$ password is wrong. I changed the password several time using brtools but unable to start my SAP. R3trans -d is also returning<0012>, if you want more details, Please reply and provide me solution for my issues.

Thanks in Advance!

Best Regards,

Aditya Maheshwari

Contact 9158376565

former_member185239 · ‎05-27-2015

Hi Aditya,

You are receiving the error ORA-12518: TNS:listener could not hand off cl ient connection.

After the system copy , have you check the SAPUSER table.

Kindly run the below command

SQL>select owner from DBA_TABLES where TABLE_NAME='SAPUSER';

(paste the output)

SQL>create table "OPS$<SID>ADM".SAPUSER (USERID varchar2(256),PASSWD varchar2(256));

(paste the output)

With Regards

Ashutosh Chaturvedi

former_member182657 · ‎05-27-2015

Hi,

Could you share result for query SQL > show parameter processes ; (If DB is in normal mode ),as i doubt the value here is low.

Thanks,

former_member182657 · ‎05-27-2015

Hi,

Issue could be due to shortage of resources here,if possible share the virtual memory size or try to increase if it's low & retry.

Regards,

Former Member · ‎05-27-2015

4 ETW000 r3trans version 6.24 (release 720 - 05.02.15 - 11:52:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 27.05.2015 - 18:03:36

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [ dev trc,00000] Wed May 27 18:03:36 2015

84 0.000084

4 ETW000 [ dev trc,00000] db_con_init called

44 0.000128

4 ETW000 [ dev trc,00000] set_use_ext_con_info(): usage of ssfs switched o

ff (rsdb/ssfs_connect=0)

4 ETW000

61 0.000189

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as bloc

ked for con_name = R/3

4 ETW000

30 0.000219

4 ETW000 [ dev trc,00000] create_con (con_name=R/3)

20 0.000239

4 ETW000 [ dev trc,00000] Loading DB library 'dboraslib.dll' ...

48 0.000287

4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"),

hdl 0, addr 000007FEE8160000

4 ETW000

21397 0.021684

4 ETW000 [ dev trc,00000] using "F:\usr\sap\GRS\SYS\exe\uc\NTAMD64\dbo

raslib.dll" 25 0.021709

4 ETW000 [ dev trc,00000] Library 'dboraslib.dll' loaded

25 0.021734

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dborasl

ib.dll 29 0.021763

4 ETW000 [ dev trc,00000] Version of 'dboraslib.dll' is "720.00", patchlev

el (0.720) 257 0.022020

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dboras

lib.dll 35 0.022055

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbora

slib.dll 40 0.022095

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_S

ET) -> changed=30, tagset=1

4 ETW000

308 0.022403

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLE

TASK) 25 0.022428

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_G

ET) 21 0.022449

4 ETW000 [ dev trc,00000] New connection 0 created

18 0.022467

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISC

ONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , time

out = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000

39 0.022506

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_G

ET) 26 0.022532

4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3)

17 0.022549

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as bloc

ked for con_name = R/3

4 ETW000

28 0.022577

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection:

18 0.022595

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCO

NNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeo

ut = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000

36 0.022631

4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=-1, type=0, env='[default en

v]', usr='[default usr]', kernel dbsl='720')

4 ETW000

117 0.022748

4 ETW000 [ dev trc,00000] dbs/ora/stmt_cache_size = 250

46 0.022794

4 ETW000 [ dev trc,00000] DIR_CLIENT_ORAHOME is not set as profile nor env

. parameter. 304 0.023098

4 ETW000 [ dev trc,00000] Register application info.

96 0.023194

4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.3.0, (dbsl 720 030

315, UNICODE[2]) 76854 0.100048

4 ETW000 [ dev trc,00000] Detailed Oracle client (patch) info not availabl

e. 53 0.100101

4 ETW000 [ dev trc,00000] Default connection: tnsname ='GRS'

24 0.100125

4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchr='AL1

6UTF16', nls=0),uc_ln=2

4 ETW000

50 0.100175

4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) -> rc=0,

env=0D8528F0 (for default NLS hdl)

4 ETW000

74600 0.174775

4 ETW000 [ dev trc,00000] # CharacterSet NCharSet env

hp errhp er2hp bathp

4 ETW000

103 0.174878

4 ETW000 [ dev trc,00000] 0 UTF16 AL16UTF16 0D8

528F0 0D886008 0D887088 0D888108

4 ETW000

45 0.174923

4 ETW000 [ dev trc,00000] NLS env. settings: lang=41004D004500520049004300

41004E00 112 0.175035

4 ETW000 [ dev trc,00000] terr=41004D004500520049004300

4100 29 0.175064

4 ETW000 [ dev trc,00000] char=55005400460031003600

23 0.175087

4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'A

MERICAN_AMERICA.UTF16'

4 ETW000

32 0.175119

4 ETW000 [ dev trc,00000] charset='UTF16', nchrset='AL16UTF16', UNI_ASC=FA

LSE 20 0.175139

4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password

204 0.175343

4 ETW000 [ dev trc,00000] Connecting as /@GRS on connection 0 (nls 0) ...

(dbsl 720 030315, UNICODE[2])

4 ETW000

46 0.175389

4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0): Service svc=0D889F20 crea

ted, rc=0 38 0.175427

4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0,svc=0D889F20): New server h

dl. srv=0D88A0C0 created, rc=0

4 ETW000

65 0.175492

4 ETW000 [ dev trc,00000] Wed May 27 18:03:39 2015

2506021 2.681513

4 ETW000 [ dev trc,00000] check: OCIServerAttach(OCI_DEFAULT) failed with

-1=OCI_ERROR 45 2.681558

4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with SQL

error 12518: 171 2.681729

4 ETW000 [ dev trc,00000] ORA-12518: TNS:listener could not hand off cl

ient connection

4 ETW000

39 2.681768

4 ETW000 [ dev trc,00000] OCIServerAttach(con=0, svc=0D889F20): Error 1251

8 attaching new srv=0D88A0C0 to 'GRS'

4 ETW000

34 2.681802

4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Server handle srv=0D88A0C0

freed. 40 2.681842

4 ETW000 [ dev trc,00000] server_detach(con=0, svc=0D889F20; srv=NULL, sta

le=2) 27 2.681869

4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Service svc=0D889F20 freed

(i=0). 20 2.681889

4 ETW000 [ dev trc,00000] rc=12518 -> Trying to reattach to server 'GRS'

18 2.681907

4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0): Service svc=0D889F20 crea

ted, rc=0 24 2.681931

4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0,svc=0D889F20): New server h

dl. srv=0D88A0C0 created, rc=0

4 ETW000

43 2.681974

4 ETW000 [ dev trc,00000] Wed May 27 18:03:41 2015

2463360 5.145334

4 ETW000 [ dev trc,00000] check: OCIServerAttach(OCI_DEFAULT) failed with

-1=OCI_ERROR 39 5.145373

4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with SQL

error 12518: 122 5.145495

4 ETW000 [ dev trc,00000] ORA-12518: TNS:listener could not hand off cl

ient connection

4 ETW000

38 5.145533

4 ETW000 [ dev trc,00000] OCIServerAttach(con=0, svc=0D889F20): Error 1251

8 attaching new srv=0D88A0C0 to 'GRS'

4 ETW000

32 5.145565

4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Server handle srv=0D88A0C0

freed. 26 5.145591

4 ETW000 [ dev trc,00000] server_detach(con=0, svc=0D889F20; srv=NULL, sta

le=2) 25 5.145616

4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Service svc=0D889F20 freed

(i=1). 21 5.145637

4 ETW000 [dbsloci.c ,00000] *** ERROR => CONNECT failed with SQL error '1251

8' 54 5.145691

4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=12518)

28 5.145719

4 ETW000 [ dev trc,00000] OCIErrorGet() -> SQL error code: 12518

106 5.145825

4 ETW000 [ dev trc,00000] ORA-12518: TNS:listener could not hand off clien

t connection

4 ETW000

32 5.145857

4 ETW000 [ dev trc,00000] ocica() -> SQL error code 12518,12518

19 5.145876

4 ETW000 [ dev trc,00000] SAPUSER error or connect error 99=DBSL_ERR_DB, o

err=12518. 20 5.145896

4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=0, rc=99=DBSL_ERR_D

B 18 5.145914

4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 12518 performing CON

55 5.145969

4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-12518: TNS:listener could not ha

nd off client connection

4 ETW000

28 5.145997

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GE

T) 27 5.146024

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GE

T) 24 5.146048

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_

INFO) 19 5.146067

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAM

E_GET) 85 5.146152

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_

VERSION) 22 5.146174

4 ETW000 [ dev trc,00000] -> 'OCI_10201_SHARE, 11.2.0.3.0'

23 5.146197

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'GRS'"

manumohandas82 · ‎05-27-2015

Hi Aditya ,

Please paste trans.log file

Thanks ,

Manu

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o ra_tnsname

Accepted Solutions (0)

Answers (5)

Answers (5)

Re: 如何使用钻取

Struggling with Filters on Select - Fiori App

Re: How can I save Requirement in Cloud ALM

Re: How can I save Requirement in Cloud ALM

Re: fuzzy search with multiple name fields