on 09-17-2011 1:22 PM
Dear All,
After Installation the Test Server , Database : Oracle 10.2.0.1 , OS : Hp Unix 11.11, SAP Appl: ECC 6.0
Database is up , SAP Instance is Started . While login from SAP GUI system shows following Error message.
Partner not reached
Error Number : 10061
Error Text : WSAECONNREFUSED:Connection refused.
Where I have check & correct the above error.
Regards,
Santosh
It seems your system is not started.
Check
dev_disp
dev_w0
in the systems work directory.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi KJ,
After add the parameter in INSTANCE profile but same error observed.
Shall i add this parameter in START profile ?
Regards,
Santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi KJ,
Following logs are received
ERPDEV:t02adm 21> sappfpar check pf = T02_DVEBMGS00_ERPDEV
sappfpar=>sapparam(1c): No Profile used.
sappfpar=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
=============================================================================
== Checking profile: <no_profile>
=============================================================================
***ERROR: Size of shared memory pool 10 too small
================================================================
SOLUTIONS: (1) Locate shared memory segments outside of pool 10
with parameters like: ipc/shm_psize_<key> =0
SOLUTION: Increase size of shared memory pool 10
with parameter: ipc/shm_psize_10 =108000000
***ERROR: Size of shared memory pool 40 too small
================================================================
SOLUTIONS: (1) Locate shared memory segments outside of pool 40
with parameters like: ipc/shm_psize_<key> =0
SOLUTION: Increase size of shared memory pool 40
with parameter: ipc/shm_psize_40 =112000000
Shared memory disposition overview
================================================================
Shared memory pools
Key: 10 Pool
Size configured.....: 19880000 ( 19.0 MB)
Size min. estimated.: 104095554 ( 99.3 MB)
Advised Size........: 108000000 ( 103.0 MB)
Key: 40 Pool for database buffers
Size configured.....: 14250000 ( 13.6 MB)
Size min. estimated.: 108776088 ( 103.7 MB)
Advised Size........: 112000000 ( 106.8 MB)
Shared memories inside of pool 10
Key: 11 Size: 500000 ( 0.5 MB) Factory calender buffer
Key: 12 Size: 6000000 ( 5.7 MB) TemSe Char-Code convert Buf.
Key: 13 Size: 40500000 ( 38.6 MB) Alert Area
Key: 14 Size: 4400000 ( 4.2 MB) Presentation buffer
Key: 16 Size: 22400 ( 0.0 MB) Semaphore activity monitoring
Key: 17 Size: 2672386 ( 2.5 MB) Roll administration
Shared memories inside of pool 40
Key: 42 Size: 7232992 ( 6.9 MB) DB TTAB buffer
Key: 43 Size: 32534392 ( 31.0 MB) DB FTAB buffer
Key: 44 Size: 7958392 ( 7.6 MB) DB IREC buffer
Key: 45 Size: 4886392 ( 4.7 MB) DB short nametab buffer
Key: 46 Size: 20480 ( 0.0 MB) DB sync table
Key: 47 Size: 3073024 ( 2.9 MB) DB CUA buffer
Key: 48 Size: 300000 ( 0.3 MB) Number range buffer
Key: 49 Size: 2769392 ( 2.6 MB) Spool admin (SpoolWP+DiaWP)
Shared memories outside of pools
Key: 1 Size: 2500 ( 0.0 MB) System administration
Key: 2 Size: 4916724 ( 4.7 MB) Disp. administration tables
Key: 3 Size: 13714400 ( 13.1 MB) Disp. communication areas
Key: 4 Size: 503248 ( 0.5 MB) statistic area
Key: 6 Size: 159744000 ( 152.3 MB) ABAP program buffer
Key: 7 Size: 14838 ( 0.0 MB) Update task administration
Key: 8 Size: 67108964 ( 64.0 MB) Paging buffer
Key: 9 Size: 134217828 ( 128.0 MB) Roll buffer
Key: 18 Size: 917604 ( 0.9 MB) Paging adminitration
Key: 19 Size: 30000000 ( 28.6 MB) Table-buffer
Key: 30 Size: 3072 ( 0.0 MB) Taskhandler runtime admin.
Key: 31 Size: 1806000 ( 1.7 MB) Dispatcher request queue
Key: 33 Size: 10240000 ( 9.8 MB) Table buffer, part.buffering
Key: 41 Size: 25010000 ( 23.9 MB) DB statistics buffer
Key: 51 Size: 3200000 ( 3.1 MB) Extended memory admin.
Key: 52 Size: 40000 ( 0.0 MB) Message Server buffer
Key: 54 Size: 4202496 ( 4.0 MB) Export/Import buffer
Key: 55 Size: 8192 ( 0.0 MB) Spool local printer+joblist
Key: 57 Size: 1048576 ( 1.0 MB) Profilparameter in shared mem
Key: 58 Size: 4096 ( 0.0 MB) Enqueue ID for reset
Key: 62 Size: 85983232 ( 82.0 MB) Memory pipes
Key: 63 Size: 409600 ( 0.4 MB) ICMAN shared memory
Key: 64 Size: 4202496 ( 4.0 MB) Online Text Repository Buf.
Key: 65 Size: 4202496 ( 4.0 MB) Export/Import Shared Memory
Key: 1002 Size: 400000 ( 0.4 MB) Performance monitoring V01.0
Key: 58900100 Size: 4096 ( 0.0 MB) SCSA area
Nr of operating system shared memory segments: 28
Shared memory resource requirements estimated
================================================================
Total Nr of shared segments required.....: 28
System-imposed number of shared memories.: 200
Shared memory segment size required min..: 159744000 ( 152.3 MB)
System-imposed maximum segment size......: 1073741824 (1024.0 MB)
Swap space requirements estimated
================================================
Shared memory....................: 738.1 MB
..in pool 10 19.0 MB, 523% used !!
..in pool 40 13.6 MB, 763% used !!
..not in pool: 526.3 MB
Processes........................: 25.9 MB
Extended Memory .................: 4092.0 MB
-
Total, minimum requirement.......: 4856.0 MB
Process local heaps, worst case..: 1907.3 MB
Total, worst case requirement....: 6763.3 MB
Errors detected..................: 2
Warnings detected................: 0
Regardsn
santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Markus.
I have remove rf* logs from /work directory
Followin g is trans.log details
4 ETW000 ================== STEP 1 =====================
4 ETW000 date&time : 20.09.2011 - 17:20:13
4 ETW000 function : CONNECT
4 ETW000 buffersync : YES
4 ETW000 clients : default
4 ETW000 l.s.m. : VECTOR
4 ETW000 commit : 100000
4 ETW000 table cache : dynamic
4 ETW000
4 ETW000 [dev trc ,00000] Disconnecting from ALL connections:
603 0.000603
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ...
96 0.000699
4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=8000000100
a51698,usrhp=8000000100a4e618)
4 ETW000
551 0.001250
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=800000
0100a51698,srvhp=8000000100a53990)
4 ETW000
1183 0.002433
4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE
807 0.003240
4 ETW000 [dev trc ,00000] Disconnected from connection 0
33 0.003273
4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1)
4 ETW000
38 0.003311
4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_t
x=0)
4 ETW000
36 0.003347
4 ETW000 Disconnected from database.
4 ETW000 End of Transport (0000).
4 ETW000 date&time: 20.09.2011 - 17:20:13000 [twdydbacc.c ,00612] i:2
Regards,
Santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Santosh,
Thanks, I know you will get error. Please follow the steps I mentioned and your issue will be resolved.
Add these 2 parameters to your instance profile and repeat sappfpar check. Repeat the steps for START profile, if you have one.
ipc/shm_psize_10 =108000000
ipc/shm_psize_40 =112000000
Thanks,
KJ.
Hi Markus,
In the system dev_w0 and dev_disp logs files are shown old dated. this files are not update.
When I saw ps -ef |grep sap* , no sap services display.
Please reply how to start above services ?
Regards,
Santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Santosh,
Please try the below, it should be quick and easy:
1.) Login as <sid>adm and then issue "cdpro". Stop SAP using "stopsap".
2.) Run "sappfpar check pf=<profile files>". Depending on your NW version, it should be either just DEFAULT and Instance profile files or the Start profile as well.
3.) Make sure that any or all the errors reported by the error is corrected by the IPC parameters.
4.) Run the sappfpar again to ensure there are ZERO errors.
5.) The issue "cleanipc <instance no.> remove". Issue this command for all instances in case of a multi-instance setup.
6.) Kill any orphan'd SAP process running under <sid>adm as owner.
7.) Issue "ipcs | grep <sid>adm". In case there are any seamphores owned by by <sid>adm, remove it using "ipcrm -s|-m <no.>"
8.) When all is clear, issue "R3trans -d".
9.) If the retuen code is 0000, start SAP.
If you face any issue in the steps above, paste the detailed error log.
Thanks,
KJ
Hi Markus.. following is the deatil log for dev_wo
RFC rfc/signon_error_log = -1
RFC rfc/dump_connection_info = 0
RFC rfc/dump_client_info = 0
RFC rfc/cp_convert/ignore_error = 1
RFC rfc/cp_convert/conversion_char = 23
RFC rfc/wan_compress/threshold = 251
RFC rfc/recorder_pcs not set, use defaule value: 1
RFC rfc/delta_trc_level not set, use default value: 0
RFC rfc/no_uuid_check not set, use default value: 0
RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0
RFC Method> initialize RemObjDriver for ABAP Objects
ThrCreateShObjects allocated 13562 bytes at c0000000000f8000
SsfSapSecin: putenv(SECUDIR=/usr/sap/T02/DVEBMGS00/sec): ok
RFC rfc/signon_error_log = -1
RFC rfc/dump_connection_info = 0
RFC rfc/dump_client_info = 0
RFC rfc/cp_convert/ignore_error = 1
RFC rfc/cp_convert/conversion_char = 23
RFC rfc/wan_compress/threshold = 251
RFC rfc/recorder_pcs not set, use defaule value: 1
RFC rfc/delta_trc_level not set, use default value: 0
RFC rfc/no_uuid_check not set, use default value: 0
RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0
RFC Method> initialize RemObjDriver for ABAP Objects
ThrCreateShObjects allocated 13562 bytes at c0000000000f8000
SsfSapSecin: putenv(SECUDIR=/usr/sap/T02/DVEBMGS00/sec): ok
A ** RABAX: level LEV_RX_STANDARD entered.
C *** ERROR => Failed to register application info: orc=24909
[dboci.c 2922]
C *** ERROR => Unregistering application info callback
[dboci.c 2923]
C *** ERROR => ORA-24909 occurred when executing SQL statement (parse error off
set=0)
Regards
Santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You have an issue with your database - you get ORA-24909.
Are you running 10.2.0.1? This version is not supported for installations (and never was). If you run that version I highly suggest you go through the installation guide. You should install the latest patchset and then the latest PSU patches before you start the import of the data.
Markus
Please reply me How to cleanup the worprocess resources ?
Since dev_w0 log size is big so inable to send .
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
dev_wo logs as below :
M Mon Sep 12 14:49:49 2011
M in_ThErrHandle: 1
M ThIErrHandle: new stat of W0 is WP_SHUTDOWN
M ThIErrHandle: I'm during shutdown
M PfStatDisconnect: disconnect statistics
M Entering ThSetStatError
M ThIErrHandle: don't try rollback again
M ThShutDownServer: shutdown server
M PfStatIndInit: Initializing Index-Record
M PfWriteIntoFile: copied shared buf (86664 bytes) to local buf
M PfWriteIntoFile: write 86664 bytes into stat-file
M PfWriteIntoFile: writing Index
M min. start :1315818003/897585
M min. end :1315818003/909170
M max. end :1315819135/701548
M wpid
M tasktypes :49370
M max. resp :1035643
M max. cpu :950000
M max.db
M no. of recs :479
M no. of bytes :86664
M PfFileIndUpd: hyperindex needs to be resorted
M PfWriteIntoFile: updated fileindex for file stat with endtime 1315819135 (12:
9:2011 9:18:55)
M PfWriteIntoFile: updated fileindex
M PfStatIndInit: Initializing Index-Record
M PfWriteIntoFile: wrote buffer to file
M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M Entering ThReadDetachMode
M call ThrShutDown (1)...
B Disconnecting from ALL connections:
B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date
Time DBHost
B 000 000 R/3 000000000 INACTIVE NO YES NO 000 255 255 20110
909 154707 ERPDEV
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=80000001028c2e98,usrhp=80000001028bfdd8
)
C Detaching from DB Server (con_hdl=0,svchp=80000001028c2e98,srvhp=80000001028c
51d8)
C
C Mon Sep 12 14:49:50 2011
C Now I'm disconnected from ORACLE
B Disconnected from connection 0
B statistics db_con_commit (com_total=17518, com_tx=2125)
B statistics db_con_rollback (roll_total=15, roll_tx=4)
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 16676) [dpuxtool.c 259]
Regards,
Santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi. Markus.
Following is the dev_wo , and dev_disp logs
1) cat dev_w0
M Mon Sep 12 14:49:49 2011
M in_ThErrHandle: 1
M ThIErrHandle: new stat of W0 is WP_SHUTDOWN
M ThIErrHandle: I'm during shutdown
M PfStatDisconnect: disconnect statistics
M Entering ThSetStatError
M ThIErrHandle: don't try rollback again
M ThShutDownServer: shutdown server
M PfStatIndInit: Initializing Index-Record
M PfWriteIntoFile: copied shared buf (86664 bytes) to local buf
M PfWriteIntoFile: write 86664 bytes into stat-file
M PfWriteIntoFile: writing Index
M min. start :1315818003/897585
M min. end :1315818003/909170
M max. end :1315819135/701548
M wpid
M tasktypes :49370
M max. resp :1035643
M max. cpu :950000
M max.db
M no. of recs :479
M no. of bytes :86664
M PfFileIndUpd: hyperindex needs to be resorted
M PfWriteIntoFile: updated fileindex for file stat with endtime 1315819135 (12:
9:2011 9:18:55)
M PfWriteIntoFile: updated fileindex
M PfStatIndInit: Initializing Index-Record
M PfWriteIntoFile: wrote buffer to file
M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M Entering ThReadDetachMode
M call ThrShutDown (1)...
B Disconnecting from ALL connections:
B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date
Time DBHost
B 000 000 R/3 000000000 INACTIVE NO YES NO 000 255 255 20110
909 154707 ERPDEV
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=80000001028c2e98,usrhp=80000001028bfdd8
)
C Detaching from DB Server (con_hdl=0,svchp=80000001028c2e98,srvhp=80000001028c
51d8)
C
C Mon Sep 12 14:49:50 2011
C Now I'm disconnected from ORACLE
B Disconnected from connection 0
B statistics db_con_commit (com_total=17518, com_tx=2125)
B statistics db_con_rollback (roll_total=15, roll_tx=4)
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 16676) [dpuxtool.c 259]
2) cat dev_disp
Mon Sep 12 14:50:00 2011
DpStartStopMsg: send stop message (myname is >ERPDEV_T02_00
<)
DpStartStopMsg: stop msg sent
Mon Sep 12 14:50:01 2011
DpHalt: sync with message server o.k.
detach from message server
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 11899]
MBUF state OFF
MBUF component DOWN
cleanup EM
cleanup event management
cleanup shared memory/semaphores
Mon Sep 12 14:50:02 2011
removing request queue
***LOG Q05=> DpHalt, DPStop ( 9695) [dpxxdisp.c 10519]
shutdown completed - server stopped ***
3) Startsap logs
ERPDEV:t02adm 21> startsap
Checking T02 Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
13:43:11 19.09.2011 LOG: Effective User Id is root
********************************************************************
This is Saposcol Version COLL 20.90 700 - v2.05 for HP-UX - 28.7.2
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
Starting collector (create new process)
********************************************************************
saposcol on host ERPDEV started
Running /usr/sap/T02/SYS/exe/run/startdb
Trying to start T02 database ...
Log file: /home/t02adm/startdb.log
T02 database started
/usr/sap/T02/SYS/exe/run/startdb completed successfully
Starting SAP Instance DVEBMGS00
-
Startup-Log is written to /home/t02adm/startsap_DVEBMGS00.log
Instance Service on host ERPDEV started
Instance on host ERPDEV started
Please reply me How to corrct the same?
Regards,
santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check whether the sapdp00 (tcp/3200) port is open on firewall.
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check the database status, R3 trans connectivity, find out the error in trans.log or dev_w0 as mentioned by Markus and then resolve the issue (Or you may paste the ERROR lines from the log file).
Oracle 10.2.0.1
Suggestion - Its not a Recommended/Supported version by SAP, Apply the patch set.
Plan your Oracle upgrade from 10G to 11gR2 as the support for the version 10G is out.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.