Skip to Content
avatar image
Former Member

no connect to database, session terminated

Dear All,

the users(PP, SD and MM) are saying that system is running slow while from last 2 days, some user session automatically terminated and they are getting following msg.

No connection to database, session terminated

all tcode are taking much time for execution while all processes are not in running status in SM50 and i also restarted the system. system was running fine after restart but once again user are getting above error.

System Scenario: there are 2 system PRD Application and Database and SAN is connected to PRD Database server. 150 users are logging on server. while we configured 100 users on PRD application server and 50 on PRD database server(distribution is fine??) .

fyi.... users of PRD Application server are getting above error.

Regards,

Diya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Mar 21, 2011 at 10:04 AM

    Hi,

    You will have to provide more info :

    What are the systems resources?

    Is it a heterogeneous environment ?

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi Mark,

      > DB stats up to date as well as the kernel ?

      here project implemented in 2008 and only SAP_BASIS and SAP_ABA patched update remaining same.

      what is your work process set-up ?

      PRD APP

      ABAP Programs           600000  KB               Dialog             15
      Nametab                  47320  KB               Update (V1)         2
      Generic key tables       99297  KB               Update (V2)         1
      Single key tables        90000  KB               Enqueue             0
      CUA Information          10000  KB               Background          4
      Screens                  14297  KB               Spool               2

      PRD DB

      ABAP Programs           600000  KB               Dialog             12
      Nametab                 145270  KB               Update (V1)         2
      Generic key tables       99297  KB               Update (V2)         1
      Single key tables        90000  KB               Enqueue             1
      CUA Information           8000  KB               Background          3
      Screens                  14297  KB               Spool               2

      >Can you post your init<SID.ora or spfile.ora

      *._OPTIM_PEEK_USER_BINDS=FALSE
      *.background_dump_dest='G:\oracle\PRD\saptrace\background'
      *.compatible='10.2.0'
      *.control_file_record_keep_time=30
      *.control_files='G:\oracle\PRD\origlogA\cntrl\cntlrPRD.dbf','G:\oracle\PRD\origlogB\cntrl\cntrlPRD.dbf','G:\oracle\PRD\sapdata1\cntrl\cntrlPRD.dbf'
      *.core_dump_dest='G:\oracle\PRD\saptrace\background'
      *.db_block_size=8192
      *.db_cache_size=724618444
      *.db_files=254
      *.db_name='PRD'
      *.dml_locks=4000
      *.event='10191 trace name context forever, level 1'
      *.FILESYSTEMIO_OPTIONS='setall'
      *.job_queue_processes=1
      *.log_archive_dest='F:\oracle\PRD\oraarch\PRDarch'
      *.log_buffer=1048576
      *.log_checkpoint_interval=0
      *.log_checkpoints_to_alert=true
      *.open_cursors=800
      *.optimizer_features_enable='10.2.0.1'
      *.pga_aggregate_target=629145600
      *.processes=80
      *.recyclebin='off'
      *.remote_login_passwordfile='exclusive'
      *.remote_os_authent=true
      *.sessions=96
      *.sga_max_size=1449236889
      *.shared_pool_reserved_size=72461844
      *.shared_pool_size=724618444
      *.sort_area_retained_size=0
      *.sort_area_size=2097152
      *.statistics_level='typical'
      *.undo_management='AUTO'
      *.undo_retention=43200
      *.undo_tablespace='PSAPUNDO'
      *.user_dump_dest='G:\oracle\PRD\saptrace\usertrace'
      *.workarea_size_policy='AUTO'
      h

      while I have 16GB on PRD App and 20GB ram on PRD DB server.

      Regards,

  • avatar image
    Former Member
    Mar 22, 2011 at 05:06 AM

    Hi diya,

    Check your data base is up and running when this message is came No connection to database, session terminated

    and check this dev_w* logs.

    Thanks

    Siva

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 22, 2011 at 08:06 AM

    Hi,

    Check free space in oracle tablespaces and db logs in tr. DBACOCKPIT.

    Check buffers in tr. ST02.

    Check sapnote https://service.sap.com/sap/support/notes/534729.

    Best Regards,

    Aleh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi aleh,

      the tablespace of PRD server is

      Tablespace name	   Size(MB)	 Free(MB)	Used(%)	Autoextend	Total size(MB)	Sum of all free fragments(MB)	Total used (%)	#Files	#Segments	#Extents	Status	Contents
      												
      PSAPSR3	153,372.00	18.38	100	YES	180,000.00	26,646.38	85	16	155,052	227,936	ONLINE	PERMANENT
      PSAPSR3700	65,740.00	291.88	100	YES	130,000.00	64,551.88	50	13	801	8,231	ONLINE	PERMANENT
      PSAPSR3USR	30	22.69	24	YES	10,000.00	9,992.69	0	1	72	116	ONLINE	PERMANENT
      PSAPTEMP	6,990.00	6,987.00	0	YES	10,000.00	9,997.00	0	1	0	0	ONLINE	TEMPORARY
      PSAPUNDO	8,860.00	7,676.31	13	YES	10,000.00	8,816.31	12	1	21	432	ONLINE	UNDO
      SYSAUX	1,020.00	32.38	97	YES	10,000.00	9,012.38	10	1	916	2,724	ONLINE	PERMANENT
      SYSTEM	870	17.44	98	YES	10,000.00	9,147.44	9	1	1,212	2,813	ONLINE	PERMANENT

      while last time buffer were showing in red status, so i increased the value of those specific parameters.

      now again some parameters still showing swapped value and i think that may be this is the cause of slow speed.

      Regards,

      Diya

  • avatar image
    Former Member
    Mar 25, 2011 at 09:56 AM

    Hi Diya,

    Tablespace PSAPSR3 seems to be 100% full.Please add datafile .

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 02, 2011 at 05:52 AM

    Thank you all.

    Add comment
    10|10000 characters needed characters exceeded