Skip to Content
avatar image
Former Member

No connection to database, session terminated

Hi,

We got "No connection to database, session terminated" while system is up,

This problem happen when Technical guy started for first time a testing backup by VERITAS,

After we got this error we already restart SAP application and Server as well, but nothing is happen disp+work stopped, I already attached u201Cdev_w0u201D log file in message

please advice..

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

B

B Thu Aug 28 15:20:24 2008

B create_con (con_name=R/3)

B Loading DB library 'F:\usr\sap\SOL\DVEBMGS01\exe\dboraslib.dll' ...

B Library 'F:\usr\sap\SOL\DVEBMGS01\exe\dboraslib.dll' loaded

B Version of 'F:\usr\sap\SOL\DVEBMGS01\exe\dboraslib.dll' is "700.08", patchlevel (0.144)

B New connection 0 created

M sysno 01

M sid SOL

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 144

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 148

M

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

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 148) [dpxxdisp.c 1305]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 25168 (1480)

M DpShMCreate: sizeof(tm_adm) 5652128 (28120)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000010F90050, size: 6348592)

M DpShMCreate: allocated sys_adm at 0000000010F90050

M DpShMCreate: allocated wp_adm at 0000000010F92150

M DpShMCreate: allocated tm_adm_list at 0000000010F983A0

M DpShMCreate: allocated tm_adm at 0000000010F98400

M DpShMCreate: allocated wp_ca_adm at 00000000114FC2A0

M DpShMCreate: allocated appc_ca_adm at 0000000011502060

M DpShMCreate: allocated comm_adm at 0000000011503FA0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000001158AC30

M DpShMCreate: allocated gw_adm at 000000001158ACB0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000001158ACE0

M DpShMCreate: allocated wall_adm at 000000001158ACF0

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Thu Aug 28 15:20:25 2008

M ThInit: running on host abyrsolman01

M

M Thu Aug 28 15:20:26 2008

M calling db_connect ...

C Prepending F:\usr\sap\SOL\DVEBMGS01\exe to Path.

C Oracle Client Version: '10.2.0.2.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

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

C Connecting as /@SOL on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 00000000129520C0 000000000A8B7460 000000000A8BCC88

C Attaching to DB Server SOL (con_hdl=0,svchp=000000000A8BCB48,srvhp=0000000012971118)

C Starting user session (con_hdl=0,svchp=000000000A8BCB48,srvhp=0000000012971118,usrhp=000000000A8B7C78)

C Now '/@SOL' is connected (con_hdl 0, nls_hdl 0).

C Got SAPSR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=000000000A8BCB48,usrhp=000000000A8B7C78)

C Now I'm disconnected from ORACLE

C Connecting as SAPSR3/<pwd>@SOL on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 00000000129520C0 000000000A8B7460 000000000A8BCC88

C Starting user session (con_hdl=0,svchp=000000000A8BCB48,srvhp=0000000012971118,usrhp=000000000A8B7C78)

C Now 'SAPSR3/<pwd>@SOL' is connected (con_hdl 0, nls_hdl 0).

C Database NLS settings: AMERICAN_AMERICA.UTF8

C DB instance SOL is running on ABYRSOLMAN01 with ORACLE version 10.2.0.2.0 since AUG 28, 2008, 14:58:10

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20080828 152026 ABYRSOLMAN01

C OCI-call failed with -1=OCI_ERROR

C SQL error 376: 'ORA-00376: file 7 cannot be read at this time

C ORA-01110: data file 7: 'H:\ORACLE\SOL\SAPDATA2\SR3_4\SR3.DATA4''

C *** ERROR => Error 376 in stmt_fetch() from oci_execute_stmt(), orpc=0

[dbsloci.c 12720]

C *** ERROR => ORA-376 occurred when executing SQL stmt (parse error offset=0)

[dbsloci.c 12739]

C sc_p=000000001288E0C0,no=0,idc_p=0000000000000000,con=0,act=1,slen=26,smax=256,#vars=0,stmt=000000000A8DCC20,table=SVERS

C SELECT VERSION FROM SVERS ;

C sc_p=000000001288E0C0,no=0,idc_p=0000000000000000,con=0,act=1,slen=26,smax=256,#vars=0,stmt=000000000A8DCC20,table=SVERS

C prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=0000000000000000,ocistmth_p=000000001297AA58

C IN : cols=0,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=-1,rsize=0,vmax=0,bound=0,iobuf_p=0000000000000000,vda_p=0000000000000000

C lobs=0,lmax=0,lpcnt=0,larr=0000000000000000,lcurr_p=0000000000000000,rret=0

C OUT: cols=1,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=0,upto=-1,rsize=144,vmax=32,bound=1,iobuf_p=0000000007E17720,vda_p=000000000A865010

C lobs=0,lmax=0,lpcnt=0,larr=0000000000000000,lcurr_p=0000000000000000,rret=0

C SELECT VERSION FROM SVERS ;

B ***LOG BZA=> table SVERS does not exist on database [dblink#5 @ 1299] [dblink 1299 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

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

M *

M * LOCATION SAP-Server abyrsolman01_SOL_01 on host abyrsolman01 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Thu Aug 28 15:20:26 2008

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10688

M * COUNTER 1

M *

M *****************************************************************************

M

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 724]

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

M 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 (Workproc 0 148) [dpnttool.c 327]

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Aug 28, 2008 at 01:52 PM

    Yes because Veritas or stop the database or you use the open file option that must be deselected.

    Let me know

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 28, 2008 at 01:59 PM

    Hello Ahmed,

    >C SQL error 376: 'ORA-00376: file 7 cannot be read at this time

    >C ORA-01110: data file 7: 'H:\ORACLE\SOL\SAPDATA2\SR3_4\SR3.DATA4''

    >C *** ERROR => Error 376 in stmt_fetch() from oci_execute_stmt(), orpc=0

    this is the reason why our instance work process is not starting: http://ora-00376.ora-code.com/

    > This problem happen when Technical guy started for first time a testing backup by VERITAS,

    Maybe he has set the datafile to offline or something like that. Pleas check the file status by running this query:

    > shell> sqlplus "/ as sysdba"

    > SQL> SELECT FILE#, STATUS, NAME FROM V$DATAFILE;

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 28, 2008 at 02:12 PM

    Dear Stefan

    First thanks for help,

    I already run the command and get the following result,

    SQL> SELECT FILE#, STATUS, NAME FROM V$DATAFILE;

    FILE# STATUS

    -


    -


    NAME

    -


    1 SYSTEM

    H:\ORACLE\SOL\SAPDATA1\SYSTEM_1\SYSTEM.DATA1

    2 RECOVER

    H:\ORACLE\SOL\SAPDATA1\UNDO_1\UNDO.DATA1

    3 ONLINE

    H:\ORACLE\SOL\SAPDATA1\SYSAUX_1\SYSAUX.DATA1

    FILE# STATUS

    -


    -


    NAME

    -


    4 ONLINE

    H:\ORACLE\SOL\SAPDATA2\SR3_1\SR3.DATA1

    5 ONLINE

    H:\ORACLE\SOL\SAPDATA2\SR3_2\SR3.DATA2

    6 RECOVER

    H:\ORACLE\SOL\SAPDATA2\SR3_3\SR3.DATA3

    FILE# STATUS

    -


    -


    NAME

    -


    7 RECOVER

    H:\ORACLE\SOL\SAPDATA2\SR3_4\SR3.DATA4

    8 ONLINE

    H:\ORACLE\SOL\SAPDATA2\SR3_5\SR3.DATA5

    9 ONLINE

    H:\ORACLE\SOL\SAPDATA2\SR3_6\SR3.DATA6

    FILE# STATUS

    -


    -


    NAME

    -


    10 ONLINE

    H:\ORACLE\SOL\SAPDATA2\SR3_7\SR3.DATA7

    11 ONLINE

    H:\ORACLE\SOL\SAPDATA2\SR3_8\SR3.DATA8

    12 ONLINE

    H:\ORACLE\SOL\SAPDATA2\SR3_9\SR3.DATA9

    FILE# STATUS

    -


    -


    NAME

    -


    13 ONLINE

    H:\ORACLE\SOL\SAPDATA2\SR3_10\SR3.DATA10

    14 ONLINE

    H:\ORACLE\SOL\SAPDATA3\SR3700_1\SR3700.DATA1

    15 ONLINE

    H:\ORACLE\SOL\SAPDATA3\SR3700_2\SR3700.DATA2

    FILE# STATUS

    -


    -


    NAME

    -


    16 ONLINE

    H:\ORACLE\SOL\SAPDATA3\SR3700_3\SR3700.DATA3

    17 ONLINE

    H:\ORACLE\SOL\SAPDATA3\SR3700_4\SR3700.DATA4

    18 ONLINE

    H:\ORACLE\SOL\SAPDATA4\SR3USR_1\SR3USR.DATA1

    FILE# STATUS

    -


    -


    NAME

    -


    19 ONLINE

    H:\ORACLE\SOL\SAPDATA4\SR3DB_1\SR3DB.DATA1

    20 ONLINE

    H:\ORACLE\SOL\SAPDATA4\SR3DB_2\SR3DB.DATA2

    21 ONLINE

    H:\ORACLE\SOL\SAPDATA4\SR3DB_3\SR3DB.DATA3

    21 rows selected.

    SQL>

    Please advice to right action

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 29, 2008 at 08:13 AM

    Hi Antonio Voce,

    Sorry for late response but really Iu2019m not fully aware with viritas functionality but I think as you can see from message history we already knows the problem in some of data file its on offline status and right now we try to bring them on online status,

    Any way Iu2019m very thankful for all of you

    Regards,

    Ahmed Saber

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 30, 2008 at 11:06 AM

    Dear Stefan,

    Sorry for interruption,

    When I try to recover datafile such as u201CH:\ORACLE\SOL\SAPDATA1\UNDO_1\UNDO.DATA1u201D I get the following error,

    SQL> recover datafile H:\ORACLE\SOL\SAPDATA1\UNDO_1\UNDO.DATA1;

    ORA-02236: invalid file name

    Also when I try to bring it in online status I get this error,

    SQL> alter database datafile 'H:\ORACLE\SOL\SAPDATA1\UNDO_1\UNDO.DATA1' online;

    alter database datafile 'H:\ORACLE\SOL\SAPDATA1\UNDO_1\UNDO.DATA1' online

    *

    ERROR at line 1:

    ORA-01113: file 2 needs media recovery

    ORA-01110: data file 2: 'H:\ORACLE\SOL\SAPDATA1\UNDO_1\UNDO.DATA1'

    Please advice.

    Regards

    Ahmed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 30, 2008 at 01:07 PM

    Gentlemen,

    Thanks for help, the problem is solved.

    Regards,

    Ahmed Saber

    Add comment
    10|10000 characters needed characters exceeded