No connection to database, session terminated

Former Member · ‎08-28-2008

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]

Former Member · ‎08-30-2008

Gentlemen,

Thanks for help, the problem is solved.

Regards,

Ahmed Saber

Former Member · ‎08-30-2008

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

Former Member · ‎08-29-2008

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

Former Member · ‎08-28-2008

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

stefan_koehler · ‎08-28-2008

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

antonio_voce · ‎08-28-2008

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

Let me know

No connection to database, session terminated

Accepted Solutions (0)

Answers (6)

Answers (6)

Re: How can assign in Identity Authentication Serv...

Re: Are there plans to update the Spring framework...

Vendor Invoice Screen 'Payment' tab screen field '...

I have data like Date, Net, Gross. I want to deriv...

Re: Re Generate Co files and data files