cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot connect to SAP

Former Member
0 Kudos

I'm unable to connect to a newly set up instance of SAP. I know that the database is runnning, but it's unclear to me if the server is running or not. SAPGUI will not connect, but I'm pretty sure that's becasue the gateway is not running (checked the ports with netstat). Any suggestions where I should look for information? Thanks

Here's the start output and the logs:

[b47adm@bsntap06 exe]$ startsap ALL

Checking ada db Database

-


ABAP Database is running

Starting SAP Instance SCS01

-


Startup-Log is written to /home/b47adm/startsap_SCS01.log

Instance already running

Starting SAP-Collector Daemon

-


14:01:17 23.06.2008 LOG: Effective User Id is root

***********************************************************************

  • This is Saposcol Version COLL 20.87 640 - V1.12 for Linux

  • Usage: saposcol -l: Start OS Collector

  • saposcol -k: Stop OS Collector

  • saposcol -d: OS Collector Dialog Mode

  • saposcol -s: OS Collector Status

  • The OS Collector (PID 3012) is already running .....

************************************************************************

saposcol already running

Starting SAP Instance DVEBMGS00

-


Startup-Log is written to /home/b47adm/startsap_DVEBMGS00.log

Instance already running

[b47adm@bsntap06 exe]$ more /home/b47adm/startsap_SCS01.log

Trace of system startup/check of SAP System B47 on Mon Jun 23 14:00:47 EDT 2008

Called command: /usr/sap/B47/SYS/exe/run/startsap

Starting SAP Instance SCS01

-


System is already running. Process Id = 5893

(7499) Exiting with Return-Code 1. (Already running)

Instance already running

Starting SAP-Collector Daemon

-


saposcol already running

[b47adm@bsntap06 exe]$ more /home/b47adm/startsap_DVEBMGS00.log

Trace of system startup/check of SAP System B47 on Mon Jun 23 14:01:17 EDT 2008

Called command: /usr/sap/B47/SYS/exe/run/startsap

Starting SAP Instance DVEBMGS00

-


System is already running. Process Id = 6045

(7547) Exiting with Return-Code 1. (Already running)

Instance already running

[b47adm@bsntap06 exe]$

And here's dev_w0

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, M

*

M sysno 00

M sid B47

M systemid 399 (New architecture with Linux)

M relno 6400

M patchlevel 0

M patchno 56

M intno 20020600

M make: single threaded, ASCII, 64 bit

M pid 11672

M

M

M Thu Jun 19 15:01:34 2008

M ***LOG Q01=> tskh_init, WPStart (Workproc 0 1 11672) [thxxhead.c 1131]

M calling db_connect ...

C

C DBADASLIB : version 640.00, patch 0.055 (Make PL 0.56)

C SAPDB shared library (dbadaslib) patchlevels (last 10)

C (0.055) Min. release check of non default connection removed (note 807218)

C (0.055) Statistic data in ST05 corrected (note 807216)

C (0.039) Invalid data of STAD corrected (note 779116)

C (0.039) Do not abort session after -810 (note 780238)

C (0.035) Sapdb_free invalid address (note 766340)

C (0.035) EXPLAIN with non character inputvariables (note 770755)

C (0.032) Sapdb_free invalid address (note 766340)

C (0.032) Abap info for performance montior (note 216208)

C (0.032) SAPDB min. release is 7.4.3 (note 326487)

C (0.031) Set isolation level calls optimized (note 762712)

C

C

C INFO : SQLOPT= -I 0 -t 0 -F SAPDB.11672.pct

C Precompiler Runtime : C-PreComp 7.5.0 Build 032-123-111-699

C Precompiler runtime is SAP DB 7.5.0.032

C Try to connect (DEFAULT) on connection 0 ...

C Attach to SAP DB : Kernel 7.5.0 Build 032-123-111-699

C Database release is SAP DB 7.5.0.032

C INFO : Database 'B47' instance is running on 'bsntap06'

C INFO : SAP DB Packet_Size = 131072

C INFO : SAP DB Min_Reply_Size = 4096

C INFO : SAP DB Comm_Size = 126976

C INFO : DBSL buffer size = 126976

C INFO : SAP DB MaxLocks = 300000

C INFO : Connect to DB as 'SAPB47'

C 00: DB_000 bsntap06-B47, conn=1, since=20080619150134

C ABAP= <unknown> (0)

C Now I'm connected to SAP DB

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 20080

619 150134 bsntap06

C INFO : SAP RELEASE (DB) = 620

M db_connect o.k.

I MtxInit: 0 0 0

M SHM_PRES_BUF (addr: 0x2b94a0273000, size: 4400000)

M SHM_ROLL_AREA (addr: 0x2b95aba0f000, size: 134217728)

M SHM_PAGING_AREA (addr: 0x2b95b3a0f000, size: 67108864)

M SHM_ROLL_ADM (addr: 0x2b94a06a7000, size: 2672386)

M SHM_PAGING_ADM (addr: 0x2b95b7a0f000, size: 656416)

M ThCreateNoBuffer allocated 336144 bytes for 1000 entries at 0x2b9

5b7ab2000

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 7440 bytes (50 server) at 0x2b95be5800

00

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation map

X ES initialized.

B

B Thu Jun 19 15:03:04 2008

B db_con_shm_ini: WP_ID = 0, WP_CNT = 8

B dbtbxbuf: Buffer TABL (addr: 0x2b95bf968100, size: 30000000, end: 0x2b95c160

4480)

B dbtbxbuf: Profile: max_objects = 5000, displace = 1, reorg = 1

B dbtbxbuf: request_unit = 2000, sync_reload = 5, inval_reload = 5

B dbtbxbuf: protect_shm = 0, force_checks = 0

B dbtbxbuf: tsize_retry = 14451456

B ***LOG BB0=> buffer TABL started with length 30000000 bytes [dbtbxbuf

#7 @ 15714] [dbtbxbuf1571 4]

B dbtbxbuf: Buffer TABLP (addr: 0x2b95c1605100, size: 10240000, end: 0x2b95c1fc

9100)

B dbtbxbuf: Profile: max_objects = 500, displace = 1, reorg = 1

B dbtbxbuf: request_unit = 2000, sync_reload = 5, inval_reload = 5

B dbtbxbuf: protect_shm = 0, force_checks = 0

B dbtbxbuf: tsize_retry = 5059776

B ***LOG BB0=> buffer TABLP started with length 10240000 bytes [dbtbxbuf

#7 @ 15714] [dbtbxbuf1571 4]

B dbtbxbuf: Reading TBX statistics:

B dbtbxbuf: 63 object entries precreated

B Layout of EIBUF buffer shared memory:

B 0: 1 * 4 = 4

B 1: 1 * 392 = 392

B 2: 8 * 40 = 320

B 3: 4001 * 56 = 224056

B 4: 2000 * 160 = 320000

B 5: 4001 * 8 = 32008

B 6: 1 * 200 = 200

B 7: 65 * 8 = 520

B 8: 28256 * 128 = 3616768

B Tracing = 0, Shm Protection = 0, Force checks = 0

B dbexpbuf: Buffer EIBUF (addr: 0x2b95c1fca108, size: 4194304, end: 0x2b95c23ca

108)

B ***LOG BB0=> buffer EIBUF started with length 4096k bytes [dbexpbuf

#5 @ 2322] [dbexpbuf2322 ]

B Layout of ESM buffer shared memory:

B 0: 1 * 4 = 4

B 1: 1 * 392 = 392

B 2: 8 * 40 = 320

B 3: 4001 * 56 = 224056

B 4: 2000 * 160 = 320000

B 5: 4001 * 8 = 32008

B 6: 1 * 200 = 200

B 7: 65 * 8 = 520

B 8: 28256 * 128 = 3616768

B Tracing = 0, Shm Protection = 0, Force checks = 0

B dbexpbuf: Buffer ESM (addr: 0x2b95c23cb108, size: 4194304, end: 0x2b95c27cb

108)

B ***LOG BB0=> buffer ESM started with length 4096k bytes [dbexpbuf

#5 @ 2322] [dbexpbuf2322 ]

B Layout of CUA buffer shared memory:

B 0: 1 * 4 = 4

B 1: 1 * 392 = 392

B 2: 8 * 40 = 320

B 3: 3001 * 56 = 168056

B 4: 1500 * 160 = 240000

B 5: 3001 * 8 = 24008

B 6: 1 * 200 = 200

B 7: 193 * 8 = 1544

B 8: 10302 * 256 = 2637312

B Tracing = 0, Shm Protection = 0, Force checks = 0

B dbexpbuf: Buffer CUA (addr: 0x2b95ba88d108, size: 3072000, end: 0x2b95bab7b

108)

B ***LOG BB0=> buffer CUA started with length 3000k bytes [dbexpbuf

#5 @ 2322] [dbexpbuf2322 ]

B Layout of OTR buffer shared memory:

B 0: 1 * 4 = 4

B 1: 1 * 392 = 392

B 2: 8 * 40 = 320

B 3: 4001 * 56 = 224056

B 4: 2000 * 160 = 320000

B 5: 4001 * 8 = 32008

B 6: 1 * 200 = 200

B 7: 81 * 8 = 648

B 8: 28255 * 128 = 3616640

B Tracing = 0, Shm Protection = 0, Force checks = 0

B dbexpbuf: Buffer OTR (addr: 0x2b95c27cc108, size: 4194304, end: 0x2b95c2bcc

108)

B ***LOG BB0=> buffer OTR started with length 4096k bytes [dbexpbuf

#5 @ 2322] [dbexpbuf2322 ]

B ***LOG BB0=> buffer CALE started with length 500000 bytes [dbcalbuf

#1 @ 2206] [dbcalbuf2206 ]

B dbtran INFO (init_connection '<DEFAULT>' [ADABAS D:640.00]):

B max_blocking_factor = 10, max_in_blocking_factor = 254,

B min_blocking_factor = 10, min_in_blocking_factor = 254,

B prefer_union_all = 1, prefer_union_for_select_all = 0,

B prefer_fix_blocking = 0, prefer_in_itab_opt = 1,

B convert AVG = 0, alias table FUPD = 0,

B escape_as_literal = 0, opt GE LE to BETWEEN = 0,

B select * =0x0f, character encoding =SBCS / <none>:-,

B use_hints = abap->0, dbif->0x1, upto->2147483647, rule_in->0,

B rule_fae->0, concat_fae->0, concat_fae_or->0

M

M Thu Jun 19 15:03:06 2008

M PfHIndInitialize: memory=<0x2b95be5fd568>, header=<0x2b95be5fd568>, records=<

0x2b95be5fd598>

M

M Thu Jun 19 15:03:07 2008

M SsfSapSecin: automatic application server initialization for SAPSECULIB

N SsfSapSecin: Looking for PSE in database

N SsfPseLoad: started...(path=/usr/sap/B47/DVEBMGS00/sec, AS=bsntap06, instance

id=00)

N SsfPseLoad: Downloading file /usr/sap/B47/DVEBMGS00/sec/SAPELEARN200.pse (cli

ent: , key: 172011, len: 1348)

N SsfPseLoad: Downloading file /usr/sap/B47/DVEBMGS00/sec/SAPSNCS.pse (client:

, key: 025318, len: 804)

N SsfPseLoad: Downloading file /usr/sap/B47/DVEBMGS00/sec/SAPSSLA.pse (client:

, key: 025401, len: 731)

N SsfPseLoad: Downloading file /usr/sap/B47/DVEBMGS00/sec/SAPSSLC.pse (client:

, key: 025427, len: 973)

N SsfPseLoad: Downloading file /usr/sap/B47/DVEBMGS00/sec/SAPSSLS.pse (client:

, key: 025344, len: 1006)

N SsfPseLoad: Downloading file /usr/sap/B47/DVEBMGS00/sec/SAPSYS.pse (client:

, key: SYSPSE, len: 13997)

N SsfPseLoad: ended (6 of 6 sucessfully loaded, 7 checked...

N MskiCreateLogonTicketCache: Logon Ticket cache created in shared memory.

N MskiCreateLogonTicketCache: Logon Ticket cache pointer registered in shared m

emory.

M rdisp/reinitialize_code_page -> 0

M icm/accept_remote_trace_level -> 0

M rdisp/no_hooks_for_sqlbreak -> 0

S

S Thu Jun 19 15:03:08 2008

S *** init spool environment

S initialize debug system

T Stack direction is downwards.

T debug control: prepare exclude for printer trace

T new memory block 0x19920770

S

S Thu Jun 19 15:03:09 2008

S spool kernel/ddic check: Ok

S using table TSP02FX for frontend printing

S 1 spool work process(es) found

S frontend print via spool service enabled

S printer list size is 150

S printer type list size is 50

S queue size (profile) = 300

S hostspool list size = 3000

S option list size is 30

S intervals: query=50, rescan=1800, global=300 info=120

S processing queue enabled

S creating spool memory service RSPO-RCLOCKS at 0x2b95bab7d060

S doing lock recovery

S setting server cache root

S using server cache size 100 (prof=100)

S creating spool memory service RSPO-SERVERCACHE at 0x2b95bab7d328

S using messages for server info

S size of spec char cache entry: 165024 bytes (timeout 100 sec)

S size of open spool request entry: 1184 bytes

S immediate print option for implicitely closed spool requests is disabled

A

A -PXA--


A PXA INITIALIZATION

A PXA: Fragment Size too small: 36 MB, reducing # of fragments

A System page size: 4kb, admin_size: 5460kb.

A Attached to PXA (address 0x2b95c2dec000, size 150000K)

A abap/pxa = shared protect gen_remote

A PXA INITIALIZATION FINISHED

A -PXA--


A

A ABAP ShmAdm attached (addr=0x2b959ef95000 leng=20955136 end=0x2b95a0391000)

A >> Shm MMADM area (addr=0x2b959f3700b8 leng=260160 end=0x2b959f3af8f8)

A >> Shm MMDAT area (addr=0x2b959f3b0000 leng=16650240 end=0x2b95a0391000)

A RFC Destination> destination bsntap06_B47_00 host bsntap06 system B47 systnr

0 (bsntap06_B47_00)

A RFC Options> H=bsntap06,S=00

A RFC FRFC> fallback activ but this is not a central instance.

A

A RFC rfc/signon_error_log = -1

A RFC rfc/dump_connection_info = 0

A RFC rfc/dump_client_info = 0

A RFC rfc/cp_convert/ignore_error = 1

A RFC rfc/cp_convert/conversion_char = 23

A RFC rfc/wan_compress/threshold = 251

A RFC rfc/recorder_pcs not set, use defaule value: 1

A RFC rfc/delta_trc_level not set, use default value: 0

A RFC rfc/no_uuid_check not set, use default value: 0

A RFC abap/SIGCHILD_default not set, use default value: 0

A RFC Method> initialize RemObjDriver for ABAP Objects

A Hotpackage version: 38

M ThrCreateShObjects allocated 8352 bytes at 0x2b95cc09a000

L Thu Jun 19 15:03:10 2008

L Begin of BtcSysStartRaise

L Raise event SAP_SYSTEM_START with parameter <bsntap06_B47_00 >

L Thu Jun 19 15:03:11 2008

L End of BtcSysStartRaise

M Fri Jun 20 16:00:07 2008

M ThIErrHandle: new stat of W0 is WP_SHUTDOWN

M ThIErrHandle: I'm during shutdown

M PfStatDisconnect: disconnect statistics

M Entering ThSetStatError

C CANCEL rejected, because there is no SQL statement active

M ThIErrHandle: don't try rollback again

M ThIErrHandle: normal shutdown

M PfStatIndInit: Initializing Index-Record

M PfWriteIntoFile: copied shared buf (0 bytes) to local buf

M PfTimeFactor: new value: -14400

M Entering ThReadDetachMode

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

deleted -posted an older log

Edited by: John Doyle on Jun 23, 2008 8:41 PM