Sap is not getting start

[Former Member]

Hi Friends ,

i have taken a RMAN offline backup , and started the sap but sap is not getting start , Please find the below logs and suggest .

Thanks in Advance .

R3trans -d .

This is R3trans version 6.24 (release 720 - 08.07.13 - 20:13:05 ).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'SID'"

R3trans finished (0012).

Work process log

---------------------------------------------------

trc file: "dev_w0", trc level: 1, release: "720"

---------------------------------------------------

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      00

M sid        SID

M systemid   370 (Solaris on SPARCV9 CPU)

M relno      7200

M patchlevel 0

M patchno    500

M intno      20020600

M make       single threaded, Unicode, 64 bit, optimized

M profile    /usr/sap/SID/SYS/profile/SID_DVEBMGS00_OTLTSQ5CSAP01

M pid        27030

M

M

M Mon Oct  5 03:40:12 2015

M  kernel runs with dp version 139000(ext=120000) (@(#) DPLIB-INT-VERSION-139000-UC)

M  length of sys_adm_ext is 588 bytes

M  ThStart: taskhandler started

M  ThInit: initializing DIA work process W0

M  ***LOG Q01=> ThInit, WPStart (Workp. 0 1 27030) [thxxhead.c   1338]

M

M Mon Oct  5 03:40:13 2015

M  ThInit: running on host OTLTSQ5CSAP01

M  calling db_connect ...

B  Loading DB library '/usr/sap/SID/SYS/exe/run/dboraslib.so' ...

B  Library '/usr/sap/SID/SYS/exe/run/dboraslib.so' loaded

B  Version of '/usr/sap/SID/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.425)

C  Register application info.

C  Oracle client version: 11.2.0.3.0, V1, default build, (dbsl 720 090813, UNICODE[2])

C  Installed Oracle client patches:

C  # Patch  13508485     : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT

C  # Patch Description: Created on 30 Dec 2011, 03:13:30 hrs PST8PDT

C  # Patch  11742262     : Created on  7 Mar 2012, 12:22:41 hrs CET

C  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

C  Logon as OPS$-user to get SAPSR3's password

C  Connecting as /@SIDon connection 0 (nls 0) ... (dbsl 720 090813, UNICODE[2])

C  Attaching to database server SID(con=0, svchp=1092d5198, srvhp=1092d7a20)

C

C Mon Oct  5 03:40:15 2015

C     OCIServerAttach(OCI_DEFAULT) failed with SQL error 12537:

C     ORA-12537: TNS:connection closed

C  *** ERROR => CONNECT failed with sql error '12537'

[dbsloci.c    15455]

C  SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=12537.

B  ***LOG BY2=> sql error 12537  performing CON [dbsh         1246]

B  ***LOG BY0=> ORA-12537: TNS:connection closed [dbsh         1246]

B  ***LOG BY2=> sql error 12537  performing CON [dblink       544]

B  ***LOG BY0=> ORA-12537: TNS:connection closed [dblink       544]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1513]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11422]

M

M  Info for wp 0

M

M    pid = 27030

M    severity = 0

M    status = 0

M    stat = WP_NEW

M    waiting_for = NO_WAITING

M    reqtype = DP_RQ_DIAWP

M    act_reqtype = NO_REQTYPE

M    req.req_info =

M    req.tid = -1

M    req.uid = 4294967295

M    req.mode = 255

M    req.len = 0

M    req.rq_id = 65535

M    req.rq_source =

M    last_tid = 0

M    last_uid = 0

M    last_mode = 0

M    locked semaphores (), locking ()

M    act_cs_count = 1

M    csTrack = 0

M    csTrackRwExcl = 0

M    csTrackRwShrd = 0

M    mode_cleaned_counter = 0

M    control_flag = 0

M    int_checked_resource(RFC) = 0

M    ext_checked_resource(RFC) = 0

M    int_checked_resource(HTTP) = 0

M    ext_checked_resource(HTTP) = 0

M    report = >                                        <

M    action = 0

M    tab_name = >                              <

M    attachedVm = no VM

M

M  ThIErrHandle: current request:

M

M  -IN-- sender_id ?                 tid  -1    wp_ca_blk   -1      wp_id -1

M  -IN-- action    -                 uid  -1    appc_ca_blk -1      type  -

M  -IN-- new_stat  NO_CHANGE         mode 255   len         0       rq_id -1

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   867]

M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  303]

M  ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M  ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M  ThIErrHandle: entering ThSetStatError

M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M  Entering ThReadDetachMode

M  call ThrShutDown (1)...

M  ***LOG Q02=> wp_halt, WPStop (Workp. 0 27030) [dpuxtool.c   327]

Regards ,

B.Prashanth Kumar

[Former Member]

Hello,

Please check below things

1. Check if listener is up and running well.

2. try to ping using tnsping SID of DB

Please share what it shows...

[Laszlo_B]

Hello Kumar,

according to this log excerpt the Oracle connection failes with an "ORA-12537: TNS:connection closed" error.

SAP KBA #1875086 - "Not able to connect to the Oracle database" describes solution posssibilties to this problem.

Best regards,

Laszlo