| Младший специалист |
 |
Зарегистрирован:
Чт, сен 07 2006, 14:04
Сообщения: 62
Откуда: Lviv
|
Евгений написал(а): R3Tst пингуется по имени? Проверь с другого хоста. (ping R3Tst) Так же проверь хост БД. Проблема в смене IP адреса. Если не хочешь возиться, поменяй его назад. Желаю удачи.
Пингуется по имени.
Как проверить хост БД?
результат r3trans -d
4 ETW000 r3trans version 6.05 (release 46D - 01.12.04 - 16:23:42).
4 ETW000 ===============================================
4 ETW000
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: r3trans -d
4 ETW000 date&time : 01.06.2007 - 11:58:48
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [developertra,00000] Fri Jun 01 11:58:48 2007 31892 0.031892
4 ETW000 [developertra,00000] db_con_init called 115 0.032007
4 ETW000 [developertra,00000] create_con (con_name=R/3) 107 0.032114
4 ETW000 [developertra,00000] Loading DB library 'dboraslib.dll' ... 118 0.032232
4 ETW000 [developertra,00000] load shared library (dboraslib.dll), hdl 0 38613 0.070845
4 ETW000 [developertra,00000] Library 'dboraslib.dll' loaded 257 0.071102
4 ETW000 [developertra,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 73 0.071175
4 ETW000 [developertra,00000] Version of library 'dboraslib.dll' is "46D.00", patchlevel (0.1973)
4 ETW000 39160 0.110335
4 ETW000 [developertra,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 56 0.110391
4 ETW000 [developertra,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 1057 0.111448
4 ETW000 [developertra,00000] New connection 0 created 72 0.111520
4 ETW000 [developertra,00000] db_con_connect (con_name=R/3) 60 0.111580
4 ETW000 [developertra,00000] find_con found the following connection for reuse:
4 ETW000 44 0.111624
4 ETW000 [developertra,00000] Got ORACLE_HOME=C:\oracle\LTS\817 from environment
4 ETW000 13378 0.125002
4 ETW000 [developertra,00000] -->oci_initialize 10992 0.135994
4 ETW000 [developertra,00000] Got ORACLE_SID=LTS from environment 13208 0.149202
4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
4 ETW000 84 0.149286
4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPR3's password 34 0.149320
4 ETW000 [developertra,00000] Connecting as /@LTS on connection 0 ... 32 0.149352
4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='LTS') 8769 0.158121
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12547 300732 0.458853
4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '12547'
4 ETW000 90 0.458943
4 ETW000 [developertra,00000] Try to connect with default password 36 0.458979
4 ETW000 [developertra,00000] Connecting as SAPR3/<pwd>@LTS on connection 0 ...
4 ETW000 46 0.459025
4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPR3', dbname='LTS')
4 ETW000 44 0.459069
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12547 28307 0.487376
4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '12547'
4 ETW000 70 0.487446
4 ETW000 [developertra,00000] Got ORACLE_SID=LTS from environment 206 0.487652
4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
4 ETW000 80 0.487732
4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPR3's password 31 0.487763
4 ETW000 [developertra,00000] Connecting as /@LTS on connection 0 ... 26 0.487789
4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='LTS') 31 0.487820
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12547 21865 0.509685
4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '12547'
4 ETW000 61 0.509746
4 ETW000 [developertra,00000] Try to connect with default password 25 0.509771
4 ETW000 [developertra,00000] Connecting as SAPR3/<pwd>@LTS on connection 0 ...
4 ETW000 36 0.509807
4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPR3', dbname='LTS')
4 ETW000 34 0.509841
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12547 24686 0.534527
4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '12547'
4 ETW000 64 0.534591
4 ETW000 [dblink ,00627] ***LOG BY2=>sql error 12547 performing CON 70 0.534661
4 ETW000 [dblink ,00627] ***LOG BY0=> 28 0.534689
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'LTS'"
Вот ище лог запуска
---------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "46D"
---------------------------------------------------
Fri Jun 01 11:15:28 2007
relno 4640
patchlevel 0
patchno 2009
intno 0
pid 1328
***LOG Q00=> DpSapEnvInit, DPStart (00 1328) [dpxxdisp.c 921]
Fri Jun 01 11:15:33 2007
*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust your DNS settings [dpxxtool2.c 3132]
MtxInit: -2 0 0
MBUF state OFF
MBUF opmode USE
EmInit: MmSetImplementation( 2 ).
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 1024 kByte.
Using implementation std
<ES> Memory Reset enabled as NT default
<EsNT> EsIUnamFileMapInit: Initialize the memory 168 MB
<ES> 167 blocks reserved for free list.
ES initialized.
***LOG Q0K=> DpMsAttach, mscon ( R3Tst) [dpxxdisp.c 8210]
MBUF set hwid_state to HWID_PENDING
CCMS: Initalizing shared memory of size 10000000 for monitoring segment.
CCMS: start to initalize 3.X shared alert area (first segment).
DpMsgAdmin: Set release to 4640, patchlevel 0
MBUF state PREPARED
MBUF component UP
MBUF set hwid_state to SAP_O_K (V1712289314 )
DpMsgAdmin: Set patchno for this platform to 2009
Release check o.K.
Fri Jun 01 11:16:13 2007
*** ERROR => W0 (pid 1436) died [dpxxdisp.c 10493]
*** ERROR => W1 (pid 1420) died [dpxxdisp.c 10493]
*** ERROR => W2 (pid 1396) died [dpxxdisp.c 10493]
my types changed after wp death/restart 0x1f --> 0x1e
*** ERROR => W3 (pid 1384) died [dpxxdisp.c 10493]
my types changed after wp death/restart 0x1e --> 0x1c
*** ERROR => W4 (pid 1120) died [dpxxdisp.c 10493]
my types changed after wp death/restart 0x1c --> 0x18
*** ERROR => W5 (pid 1472) died [dpxxdisp.c 10493]
*** ERROR => W6 (pid 1020) died [dpxxdisp.c 10493]
my types changed after wp death/restart 0x18 --> 0x10
*** ERROR => W7 (pid 1424) died [dpxxdisp.c 10493]
my types changed after wp death/restart 0x10 --> 0x0
*** DP_FATAL_ERROR => DpEnvCheck: no more work processes
*** DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
killing W0-1436 (SIGUSR2)
*** ERROR => DpWpKill(1436, SIGUSR2) failed [dpxxtool.c 2655]
killing W1-1420 (SIGUSR2)
*** ERROR => DpWpKill(1420, SIGUSR2) failed [dpxxtool.c 2655]
killing W2-1396 (SIGUSR2)
*** ERROR => DpWpKill(1396, SIGUSR2) failed [dpxxtool.c 2655]
killing W3-1384 (SIGUSR2)
*** ERROR => DpWpKill(1384, SIGUSR2) failed [dpxxtool.c 2655]
killing W4-1120 (SIGUSR2)
*** ERROR => DpWpKill(1120, SIGUSR2) failed [dpxxtool.c 2655]
killing W5-1472 (SIGUSR2)
*** ERROR => DpWpKill(1472, SIGUSR2) failed [dpxxtool.c 2655]
killing W6-1020 (SIGUSR2)
*** ERROR => DpWpKill(1020, SIGUSR2) failed [dpxxtool.c 2655]
killing W7-1424 (SIGUSR2)
*** ERROR => DpWpKill(1424, SIGUSR2) failed [dpxxtool.c 2655]
NiWait: sleep (10000 msecs) ...
NiISelect: timeout 10000 ms
Fri Jun 01 11:16:23 2007
NiISelect: TIMEOUT occured(10000 msecs)
dump system status
dump system status
Workprocess Table (long) Fri Jun 01 08:16:23 2007
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-----------------------------------------------------------------------------------------------------------------------
0 DIA 1436 Ended no 1 0 0
1 DIA 1420 Ended no 1 0 0
2 DIA 1396 Ended no 1 0 0
3 UPD 1384 Ended no 1 0 0
4 ENQ 1120 Ended no 1 0 0
5 BTC 1472 Ended no 1 0 0
6 BTC 1020 Ended no 1 0 0
7 SPO 1424 Ended no 1 0 0
Dispatcher Queue Statistics Fri Jun 01 08:16:23 2007
===========================
+------+--------+--------+--------+--------+--------+
| Typ | now | high | max | writes | reads |
+------+--------+--------+--------+--------+--------+
| NOWP | 0 | 1 | 2000 | 1 | 1 |
+------+--------+--------+--------+--------+--------+
| DIA | 3 | 3 | 2000 | 3 | 0 |
+------+--------+--------+--------+--------+--------+
| UPD | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
| ENQ | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
| BTC | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
| SPO | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
| UP2 | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
max_rq_id 7
wake_evt_udp_now 0
wake events total 3, udp 2 ( 66%), shm 1 ( 33%)
since last update total 3, udp 2 ( 66%), shm 1 ( 33%)
Dump of tm_adm structure: Fri Jun 01 08:16:23 2007
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Fri Jun 01 08:16:23 2007
=============================
Slots: 300, Used: 1, Max: 0
+------+--------------+----------+-------------+
| id | owner | pid | eyecatcher |
+------+--------------+----------+-------------+
| 0 | DISPATCHER | -1 | *WPCAAD000* |
NiWait: sleep (5000 msecs) ...
NiISelect: timeout 5000 ms
Fri Jun 01 11:16:28 2007
NiISelect: TIMEOUT occured(5000 msecs)
Switch off Shared memory profiling
DpWakeUpWps: wake up all wp's
killing process (1480) (SOFT_KILL)
[DpProcDied] Process lives (PID:1480 HANDLE:436)
wait for end of gateway
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
Fri Jun 01 11:16:29 2007
NiISelect: TIMEOUT occured(1000 msecs)
[DpProcDied] Process died (PID:1480 HANDLE:436)
NiBufSend starting
NiIWrite: write 458, 1 packs, MESG_IO, handle 3, data complete
MsINiWrite: sent 458 bytes
send msg (len 110+348) to name -, type 4, key -
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 8415]
NiBufSend starting
NiIWrite: write 110, 1 packs, MESG_IO, handle 3, data complete
MsINiWrite: sent 110 bytes
send logout to msg_server
call exit function
DpMsShutdownHook called
NiSelClear: removed hdl 3 from selectset
MBUF state OFF
blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/8
LOCK WP ca_blk 1
make DISP owner of wp_ca_blk 1
put request into queue (reqtype 1, prio LOW, rq_id 9)
MBUF component DOWN
NiBufClose: clear extensions for handle 3
NiBufSetStat: bufstat of hdl 3 changed from OK to OFF
NiICloseHandle: shutdown and close nihandle-socket 3-364
detach MS-system
Fri Jun 01 11:16:30 2007
EsCleanup ....
***LOG Q05=> DpHalt, DPStop ( 1328) [dpxxdisp.c 7093]
Good Bye .....
 |
|
|
Вход
Регистрация
FAQ пользователя
Поиск
