Question:
Hi Gurus,
I have a problem with SAP R/3 47 installation on SUN Solaris 8.
disp+work die and SAP don't start.
I attach dev_w0
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "640"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, M
*
M systemid 370 (SUN on SPARC CPU with Solaris 2.2)
M relno 6400
M patchlevel 0
M patchno 21
M intno 20020600
M make: single threaded, ASCII, 64 bit
M pid 8580
M
M
M Thu Oct 5 18:34:44 2006
M ***LOG Q01=> tskh_init, WPStart (Workproc 0 1 8580) [thxxhead.c 1133]
M calling db_connect ...
C Got ORACLE_HOME=/oracle/SIE/920_64 from environment
C Client NLS settings: AMERICAN_AMERICA.WE8DEC
C Logon as OPS$-user to get SAPSIE's password
C Connecting as /@SIE on connection 0 ...
C Attaching to DB Server SIE (con_hdl=0,svchp=103e81798,svrhp=103e83b88)
C Starting user session (con_hdl=0,svchp=103e81798,srvhp=103e83b88,usrhp=103e8d5b8)
C Now I'm connected to ORACLE
C Got SAPSIE's password from OPS$-user
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=103e81798,usrhp=103e8d5b8)
C Now I'm disconnected from ORACLE
C Connecting as SAPSIE/<pwd>@SIE on connection 0 ...
C Starting user session (con_hdl=0,svchp=103e81798,srvhp=103e83b88,usrhp=103e8d5b8)
C Now I'm connected to ORACLE
C Database NLS settings: AMERICAN_AMERICA.WE8DEC
C Database instance SIE is running on ebillas1 with ORACLE version 9.2.0.1.0 since 20061005
B Connection 0 opened
B Wp Hdl ConName ConId ConState TX PRM RCT MAX OPT DateTime DBHost
B 000 000 R/3 000000000 ACTIVE NO YES NO 255 255 20061005183444 ebillas1
M db_connect o.k.
I MtxInit: 0 0 0
M SHM_PRES_BUF (addr: ffffffff76a56000, size: 4400000)
I *** ERROR => shmat(2814,0x0,SHM_RND) (24: Too many open files) [shmux.c 1448]
I *** ERROR => The number of shared memories exceeds the system imposed limit [shmux.c 1449]
I Solution: Put more shared memories into pool with: ipc/shm_psize_<nn> =-<poolkey>
I Increase the pool size with: ipc/shm_psize_<poolkey> =<poolsize>
M *** ERROR => ThShMCreate: ShmCreate SHM_ROLL_AREA_KEY failed [thxxhead.c 2365]
M *** ERROR => ThIPCInit: ThShMCreate [thxxhead.c 1892]
M ***LOG R19=> tskh_init, ThIPCInit ( TSKH-IPC-000001) [thxxhead.c 1361]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: ThIPCInit (step 1, th_errno 17, action 3, level 1) [thxxhead.c 9379]
M
M Info for wp 0
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M rq_info = 0
M tid = -1
M mode = 255
M mode = 255
M len = -1
M rq_id = 65535
M rq_source = 255
M last_tid = 0
M last_mode = 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 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 730]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUM
P failed [thxxtool3.c 246]
M Entering ThSetStatError
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 8580) [dpuxtool.c 322]
--------------------------
Can you help me?
Thanks
Mike
Answer:
read your error messages:
I *** ERROR => shmat(2814,0x0,SHM_RND) (24: Too many open files) [shmux.c 1448]
I *** ERROR => The number of shared memories exceeds the system imposed limit [shmux.c 1449]
I Solution: Put more shared memories into pool with: ipc/shm_psize_<nn> =-<poolkey>
I Increase the pool size with: ipc/shm_psize_<poolkey> =<poolsize>
M *** ERROR => ThShMCreate: ShmCreate SHM_ROLL_AREA_KEY failed [thxxhead.c 2365]
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Answer:
read your error messages:
I *** ERROR => shmat(2814,0x0,SHM_RND) (24: Too many open files) [shmux.c 1448]
I *** ERROR => The number of shared memories exceeds the system imposed limit [shmux.c 1449]
I Solution: Put more shared memories into pool with: ipc/shm_psize_<nn> =-<poolkey>
I Increase the pool size with: ipc/shm_psize_<poolkey> =<poolsize>
M *** ERROR => ThShMCreate: ShmCreate SHM_ROLL_AREA_KEY failed [thxxhead.c 2365]
Snowy...the solution is...........????
RAM 4 GB
Swap:
Memory parameters
swapfile dev swaplo blocks free
/dev/dsk/c0t10d0s1 32,73 16 6295216 6295216
/dati2/swaparea/swap_sap - 16 32767984 32767984
/dati2/EBILL/Work/swaparea/swapfile - 16 25165808 25165808
/etc/system:
set noexec_user_stack=1
set msgsys:msginfo_msgmax=8192
set msgsys:msginfo_msgmnb=16384
set msgsys:msginfo_msgmni=50
set msgsys:msginfo_msgtql=2048
set semsys:seminfo_semmns=16384
set semsys:seminfo_semmni=1024
set semsys:seminfo_semmnu=4096
set semsys:seminfo_semopm=100
set semsys:seminfo_semume=64
set semsys:seminfo_semmsl=2048
set shmsys:shminfo_shmmni=256
set shmsys:shminfo_shmmax=0xffffffffffffffff
set rlim_fd_cur=8192
initSIE.ora
########################################
# (c)Copyright SAP AG, Walldorf #
#######################################
########################################
# PART I, TUNING PARAMETERS #
#######################################
#### SYSTEM GLOBAL AREA BUFFERS
# Total System Global Area = sum(bytes) of all caches
# Variable Size = shared_pool_size (approx.)
# Database Buffers = db_block_buffers * db_block_size
# Redo Buffers = log_buffer
#
# unit of shared_pool_size: bytes
# unit of db_block_buffers: number of cached blocks
# unit of log_buffer: bytes
shared_pool_size = 150000000
# 10% of shared_pool_size
shared_pool_reserved_size = 15000000
log_buffer = 1048576
#### MANAGING SORTS
# A small sort requires sort_area_retained_size in
# memory. Larger sorts are allocating segments in
# PSAPTEMP. They are using sort_area_size in memory.
sort_area_retained_size = 0
sort_area_size = 2097152
#sort_spacemap_size = 512
#### PGA-PARAMETERS
open_cursors = 800
#cursor_space_for_time = true
#### LOCKS
# dml_locks = processes * 50
dml_locks = 2500
enqueue_resources = 8000
#### CPU-PARAMETERS
#spin_count = 200
#_cpu_count = 4
#### TUNING ARCHIVING
#log_archive_buffer_size 127
#log_archive_buffers 4
#### USE VECTOR READ
#use_readv = true
#### OTHER TUNING PARAMETERS
#sequence_cache_entries = 100
#sequence_cache_hash_buckets = 89
####################################
# PART II, CHANGEABLE PARAMETERS #
####################################
#### CONTROL-FILES
# the controlfiles should be mirrored to every new
# database mount point @SAPDATA_HOME@/sapdata<#>
#control_files = @SAPDATA1@/cntrl/cntrlSIE.dbf @SAPDATA2@/cntrl/cntrlSIE.dbf @SAPDATA3@/cntrl/cntrlSIE.dbf
#### AUTOMATICLY STARTED BACKGROUND PROCESSES
log_archive_start = true
#### MANAGING LOG SWITCHES
# checkpoints occur only when switching logs, if
# log_checkpoint_interval * size of OS blocks > size of
# the actual redo log
log_checkpoint_interval = 0
log_checkpoint_timeout = 0
#### PROCESS-PARAMETERS
# The number of allocated semaphores is equal to the
# number of processes
# sessions = 1.2 * processes
#processes = 80
processes = 60
#sessions = 96
sessions = 76
#### AUDITING AND STATISTICS
# sql_trace=TRUE
# audit_trail = true
# db_block_lru_extended_statistics = 1000
# db_block_lru_statistics = true
####################################
# PART III, STATIC PARAMETERS #
#####################################
#### DB-NAME
db_name = SIE
#### DB-BLOCKSIZE
db_block_size = 8192
#### DB-FILES
db_files = 254
#### OPTIMIZER MODE
optimizer_mode = choose
#optimizer_search_limit = 3
#### PATHS / DESTINATIONS / TRACES
# /oracle/SIE/saptrace/background: trace files of the background
# processes
# /oracle/SIE/saptrace/usertrace: trace files of the user processes
# log_archive_dest is a destination, not a path.
# The archivefiles get the name
# /oracle/SIE/oraarch/SIEarch<thread#>_<log#>
background_dump_dest = /oracle/SIE/saptrace/background
user_dump_dest = /oracle/SIE/saptrace/usertrace
core_dump_dest = /oracle/SIE/saptrace/background
log_archive_dest = /oracle/SIE/oraarch/SIEarch
#log_archive_format = %t_%s
#### OTHER
# reduce_alarm only supported on HP
#reduce_alarm = TRUE
#### ORACLE OPS PARAMETER
remote_os_authent = true
transaction_auditing = FALSE
# retention time for RMAN backup information in control file
control_file_record_keep_time = 30
#see SAP note 124361
db_file_multiblock_read_count = 8
log_checkpoints_to_alert = true
hash_join_enabled = false
#### OPTIMIZER MODE
optimizer_index_cost_adj = 10
#### AUDITING AND STATISTICS
timed_statistics = true
compatible = 9.2.0
optimizer_features_enable = 9.2.0
undo_retention = 43200
undo_tablespace = PSAPUNDO
undo_management = AUTO
pga_aggregate_target = 309162147
workarea_size_policy = AUTO
sga_max_size = 250000000
db_cache_size = 150000000
statistics_level = typical
fast_start_mttr_target = 900
control_files = (/oracle/SIE/origlogA/cntrl/cntrlSIE.dbf,/oracle/SIE/sapdata1/system_1/cntrl/cntrlSIE.dbf, /oracle/SIE/saparch/cntrl/cntrlSIE.dbf)
Is it correct?
Answer:
first, try to get a newer kernel, yours is set to work with 2.2...
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Answer:
first, try to get a newer kernel, yours is set to work with 2.2...
Nothing...the error is always:
I *** ERROR => shmat(2814,0x0,SHM_RND) (24: Too many open files) [shmux.c 1448]
I *** ERROR => The number of shared memories exceeds the system imposed limit [shmux.c 1449]
I Solution: Put more shared memories into pool with: ipc/shm_psize_<nn> =-<poolkey>
I Increase the pool size with: ipc/shm_psize_<poolkey> =<poolsize>
M *** ERROR => ThShMCreate: ShmCreate SHM_ROLL_AREA_KEY failed [thxxhead.c 2365]
Answer:
read your error mesage again, it is supplying a possible answer:
Put more shared memories into pool with: ipc/shm_psize_<nn> =-<poolkey>
I Increase the pool size with: ipc/shm_psize_<poolkey> =<poolsize>
NetWeaver ‘04–SAP Web AS for ORACLE certified
Answer:
Review your ipc/shm_psize_<poolkey> =<poolsize> Parameters as stated in the error log. As Snowy says I would upgrade the kernel prior to this as you may require having to adjust various parameters again.
Answer:
check also to run sappfpar to check validity of your SAP profiles.
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Answer:
Thanks snowy and paulkelly.
You are right!
ipc/shm_psize_10 was smaller.
Now...i have DNS problem (Damn...)
*** WARNING => DpNetCheck: NiHostToAddr(www.doesnotexist0170.qqq.nxst) took 10 seconds
Wed Oct 18 17:53:47 2006
*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 75 seconds
***LOG GZZ=> 2 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 3893]MtxInit: -2 0 0
*** ERROR => DpSysAdmExtCreate: ShmCreate (CREATE) [dpxxtool2.c 522]
*** ERROR => dispatcher already running ???? [dpxxtool2.c 523]
*** ERROR => I better EXIT before I do any (more) damage [dpxxtool2.c 525]
Answer:
"2 possible network problems detected - check tracefile and adjust the DNS settings" is normal. But make sure you have the loopback and a DNS name for your server in /etc/hosts.
Answer:
Ok...I have finished the installation.
The problem was:
1: SO kernel patch
2: link language in Sun Solaris
3: memory parameter
Now...I have only 5 days for license..........
Answer:
You mean your temporary license expires in 5 days? Man, it took a long time to resolve your installation issues!
Answer:
this is an internal project.
I work in other projects...
Thanks
Mike