Skip to Content
author's profile photo
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • May 27, 2015 at 01:12 PM

    Hi Aditya ,

    Please paste trans.log file

    Thanks ,

    Manu

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    May 27, 2015 at 01:14 PM

    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'"

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    May 27, 2015 at 01:39 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    May 27, 2015 at 01:45 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • May 27, 2015 at 01:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded