on 10-30-2008 12:05 PM
Hi,
When I install second installation in a same single machine where already One SID installed, first one is goes down.
But Database is working fine.....
Disp+Work.exe status first it goes to Yellow then goes down..
Kernal of First installation is already updated.
Disp+Work.exe ---> Develeoper_Trc detail is following..
-
trc file: "dev_disp", trc level: 1, release: "700"
-
sysno 01
sid TRN
systemid 562 (PC with Windows NT)
relno 7000
patchlevel 0
patchno 159
intno 20050900
make: multithreaded, Unicode, 64 bit, optimized
pid 6360
Thu Oct 30 16:22:26 2008
kernel runs with dp version 237000(ext=110000) (@(#) DPLIB-INT-VERSION-237000-UC)
length of sys_adm_ext is 576 bytes
SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (01 6360) [dpxxdisp.c 1254]
shared lib "dw_xml.dll" version 159 successfully loaded
shared lib "dw_xtc.dll" version 159 successfully loaded
shared lib "dw_stl.dll" version 159 successfully loaded
shared lib "dw_gui.dll" version 159 successfully loaded
shared lib "dw_mdm.dll" version 159 successfully loaded
rdisp/softcancel_sequence : -> 0,5,-1
use internal message server connection to port 3901
Thu Oct 30 16:22:31 2008
WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5403]
MtxInit: 30000 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: VMC (JAVA VM in WP) is not active
DpIPCInit2: start server >ides_TRN_01 <
DpShMCreate: sizeof(wp_adm) 21008 (1616)
DpShMCreate: sizeof(tm_adm) 5912624 (29416)
DpShMCreate: sizeof(wp_ca_adm) 24000 (80)
DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
DpShMCreate: sizeof(comm_adm) 552080 (1088)
DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
DpShMCreate: sizeof(slock_adm) 0 (104)
DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
DpShMCreate: sizeof(file_adm) 0 (72)
DpShMCreate: sizeof(vmc_adm) 0 (1864)
DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000EF60050, size: 6604928)
DpShMCreate: allocated sys_adm at 000000000EF60050
DpShMCreate: allocated wp_adm at 000000000EF62150
DpShMCreate: allocated tm_adm_list at 000000000EF67360
DpShMCreate: allocated tm_adm at 000000000EF673C0
DpShMCreate: allocated wp_ca_adm at 000000000F50ABF0
DpShMCreate: allocated appc_ca_adm at 000000000F5109B0
DpShMCreate: allocated comm_adm at 000000000F5128F0
DpShMCreate: system runs without slock table
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 000000000F599580
DpShMCreate: allocated gw_adm at 000000000F599600
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 000000000F599630
DpShMCreate: allocated wall_adm at 000000000F599640
MBUF state OFF
DpCommInitTable: init table for 500 entries
rdisp/queue_size_check_value : -> off
ThTaskStatus: rdisp/reset_online_during_debug 0
EmInit: MmSetImplementation( 2 ).
MM global diagnostic options set: 0
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 4096 kByte.
Using implementation view
<EsNT> Using memory model view.
<EsNT> Memory Reset disabled as NT default
<ES> 127 blocks reserved for free list.
ES initialized.
J2EE server info
start = TRUE
state = STARTED
pid = 6764
argv[0] = E:\usr\sap\TRN\DVEBMGS01\exe\jcontrol.EXE
argv[1] = E:\usr\sap\TRN\DVEBMGS01\exe\jcontrol.EXE
argv[2] = pf=E:\usr\sap\TRN\SYS\profile\TRN_DVEBMGS01_ides
argv[3] = -DSAPSTART=1
argv[4] = -DCONNECT_PORT=64999
argv[5] = -DSAPSYSTEM=01
argv[6] = -DSAPSYSTEMNAME=TRN
argv[7] = -DSAPMYNAME=ides_TRN_01
argv[8] = -DSAPPROFILE=E:\usr\sap\TRN\SYS\profile\TRN_DVEBMGS01_ides
argv[9] = -DFRFC_FALLBACK=ON
argv[10] = -DFRFC_FALLBACK_HOST=localhost
start_lazy = 0
start_control = SAP J2EE startup framework
DpJ2eeStart: j2ee state = STARTED
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1656]
***LOG Q0K=> DpMsAttach, mscon ( ides) [dpxxdisp.c 11937]
DpStartStopMsg: send start message (myname is >ides_TRN_01 <)
DpStartStopMsg: start msg sent
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
CCMS: start to initalize 3.X shared alert area (first segment).
DpMsgAdmin: Set release to 7000, patchlevel 0
MBUF state PREPARED
MBUF component UP
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1050]
DpMsgAdmin: Set patchno for this platform to 159
Release check o.K.
DpJ2eeLogin: j2ee state = CONNECTED
Thu Oct 30 16:22:36 2008
***LOG Q0I=> NiIRead: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4424]
ERROR => NiIRead: SiRecv failed for hdl 5 / sock 292
(SI_ECONN_BROKEN/10054; I4; ST; 127.0.0.1:4516) [nixxi.cpp 4424]
DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)
DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=6764)
ERROR => DpProcKill: kill failed [dpntdisp.c 371]
DpIJ2eeShutdown: j2ee state = SHUTDOWN
Thu Oct 30 16:23:11 2008
my types changed after wp death/restart 0xbf --> 0xbe
my types changed after wp death/restart 0xbe --> 0xbc
my types changed after wp death/restart 0xbc --> 0xb8
my types changed after wp death/restart 0xb8 --> 0xb0
my types changed after wp death/restart 0xb0 --> 0xa0
my types changed after wp death/restart 0xa0 --> 0x80
DP_FATAL_ERROR => DpWPCheck: no more work processes
DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
NiWait: sleep (10000ms) ...
NiISelect: timeout 10000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:21 2008
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Thu Oct 30 10:53:21 2008
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-
0 DIA 6800 Ended no 1 0 0
1 DIA 6796 Ended no 1 0 0
2 DIA 6760 Ended no 1 0 0
3 DIA 6772 Ended no 1 0 0
4 DIA 6896 Ended no 1 0 0
5 DIA 6848 Ended no 1 0 0
6 UPD 6860 Ended no 1 0 0
7 ENQ 6784 Ended no 1 0 0
8 BTC 6864 Ended no 1 0 0
9 BTC 6892 Ended no 1 0 0
10 BTC 6924 Ended no 1 0 0
11 SPO 6928 Ended no 1 0 0
12 UP2 6908 Ended no 1 0 0
Dispatcher Queue Statistics Thu Oct 30 10:53:21 2008
===========================
--------
+
Typ | now | high | max | writes | reads |
--------
+
NOWP | 0 | 2 | 2000 | 5 | 5 |
--------
+
DIA | 6 | 6 | 2000 | 6 | 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 13
wake_evt_udp_now 0
wake events total 8, udp 6 ( 75%), shm 2 ( 25%)
since last update total 8, udp 6 ( 75%), shm 2 ( 25%)
Dump of tm_adm structure: Thu Oct 30 10:53:21 2008
=========================
Term uid man user term lastop mod wp ta a/i (modes)
RM-T13, U14, , gokul_ggn, 16:22:40, M0, W-1, , 1/0
Workprocess Comm. Area Blocks Thu Oct 30 10:53:21 2008
=============================
Slots: 300, Used: 2, Max: 1
--------
+
id | owner | pid | eyecatcher |
--------
+
0 | DISPATCHER | -1 | WPCAAD000 |
1 | DISPATCHER | -1 | WPCAAD001 |
NiWait: sleep (5000ms) ...
NiISelect: timeout 5000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:26 2008
NiISelect: TIMEOUT occured (5000ms)
DpHalt: shutdown server >ides_TRN_01 < (normal)
DpJ2eeDisableRestart
DpModState: buffer in state MBUF_PREPARED
NiBufSend starting
NiIWrite: hdl 3 sent data (wrt=110,pac=1,MESG_IO)
MsINiWrite: sent 110 bytes
MsIModState: change state to SHUTDOWN
DpModState: change server state from STARTING to SHUTDOWN
Switch off Shared memory profiling
ShmProtect( 57, 3 )
ShmProtect(SHM_PROFILE, SHM_PROT_RW
ShmProtect( 57, 1 )
ShmProtect(SHM_PROFILE, SHM_PROT_RD
DpWakeUpWps: wake up all wp's
Stop work processes
Stop gateway
killing process (6752) (SOFT_KILL)
Stop icman
killing process (6700) (SOFT_KILL)
Terminate gui connections
send SHUTDOWN to REM TM 13
blks_in_queue/wp_ca_blk_no/wp_max_no = 2/300/13
LOCK WP ca_blk 2
return errno (-17) to T13
errormsg without overhead: take mode 0
NiBufIAlloc: malloc NiBufadm, to 0 bytes
try to send 14 to M0
NiBufSend starting
NiIWrite: hdl 5 sent data (wrt=14,pac=1,MESG_IO)
REL WP ca_blk 2
set status of T13 to TM_DISCONNECTED
NiBufISelUpdate: new MODE -- (r-) for hdl 5 in set0
SiSelNSet: set events of sock 292 to: ---
NiBufISelRemove: remove hdl 5 from set0
SiSelNRemove: removed sock 292 (pos=2)
SiSelNRemove: removed sock 292
NiSelIRemove: removed hdl 5
DpDelSocketInfo: del info for socket 5 (type=3)
NiICloseHandle: shutdown and close hdl 5 / sock 292
NiBufIClose: clear extension for hdl 5
dp_tm_adm[13].stat = DP_SLOT_FREE
DpGetSchedule: next schedule 1225364011/669000
DpGetSchedule: no schedule found
DpITmSlotRelease: release slot 13
DpListInsert: insert elem 13 into tmadm_free_list (at begin)
DpListInsert: 188 elems in tmadm_free_list
DpListRemove: remove elem 13 from tmadm_inuse_list
DpListRemove: 13 elems in tmadm_inuse_list
wait for end of work processes
wait for end of gateway
[DpProcDied] Process lives (PID:6752 HANDLE:404)
waiting for termination of gateway ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:27 2008
NiISelect: TIMEOUT occured (1000ms)
Thu Oct 30 16:23:28 2008
[DpProcDied] Process died (PID:6752 HANDLE:404)
wait for end of icman
[DpProcDied] Process lives (PID:6700 HANDLE:412)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:29 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:6700 HANDLE:412)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:30 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:6700 HANDLE:412)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:31 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:6700 HANDLE:412)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:32 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:6700 HANDLE:412)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:33 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:6700 HANDLE:412)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:34 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:6700 HANDLE:412)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:35 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:6700 HANDLE:412)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:36 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:6700 HANDLE:412)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:37 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:6700 HANDLE:412)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=437
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Oct 30 16:23:38 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:6700 HANDLE:412)
[DpProcDied] Process died (PID:6764 HANDLE:388)
DpStartStopMsg: send stop message (myname is >ides_TRN_01 <)
NiIMyHostName: hostname = 'ides'
AdGetSelfIdentRecord: > <
AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0
AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0
DpConvertRequest: net size = 189 bytes
NiBufSend starting
NiIWrite: hdl 3 sent data (wrt=562,pac=1,MESG_IO)
MsINiWrite: sent 562 bytes
send msg (len 110+452) to name -, type 4, key -
DpStartStopMsg: stop msg sent
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 3 recv would block (errno=EAGAIN)
NiIRead: read for hdl 3 timed out (0ms)
DpHalt: no more messages from the message server
DpHalt: send keepalive to synchronize with the message server
NiBufSend starting
NiIWrite: hdl 3 sent data (wrt=114,pac=1,MESG_IO)
MsINiWrite: sent 114 bytes
send msg (len 110+4) to name MSG_SERVER, type 0, key -
MsSndName: MS_NOOP ok
Send 4 bytes to MSG_SERVER
NiIRead: hdl 3 recv would block (errno=EAGAIN)
NiIPeek: peek successful for hdl 3 (r)
NiIRead: hdl 3 received data (rcd=114,pac=1,MESG_IO)
NiBufIIn: NIBUF len=114
NiBufIIn: packet complete for hdl 3
NiBufReceive starting
MsINiRead: received 114 bytes
MSG received, len 110+4, flag 3, from MSG_SERVER , typ 0, key -
Received 4 bytes from MSG_SERVER
Received opcode MS_NOOP from msg_server, reply MSOP_OK
MsOpReceive: ok
MsSendKeepalive : keepalive sent to message server
NiIRead: hdl 3 recv would block (errno=EAGAIN)
Thu Oct 30 16:23:39 2008
NiIPeek: peek for hdl 3 timed out (r; 1000ms)
NiIRead: read for hdl 3 timed out (1000ms)
DpHalt: no more messages from the message server
DpHalt: sync with message server o.k.
detach from message server
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 12283]
NiBufSend starting
NiIWrite: hdl 3 sent data (wrt=110,pac=1,MESG_IO)
MsINiWrite: sent 110 bytes
MsIDetach: send logout to msg_server
MsIDetach: call exit function
DpMsShutdownHook called
NiBufISelUpdate: new MODE -- (r-) for hdl 3 in set0
SiSelNSet: set events of sock 332 to: ---
NiBufISelRemove: remove hdl 3 from set0
SiSelNRemove: removed sock 332 (pos=3)
SiSelNRemove: removed sock 332
NiSelIRemove: removed hdl 3
MBUF state OFF
AdGetSelfIdentRecord: > <
AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0
AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0
AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0
blks_in_queue/wp_ca_blk_no/wp_max_no = 2/300/13
LOCK WP ca_blk 2
make DISP owner of wp_ca_blk 2
DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 16)
MBUF component DOWN
NiICloseHandle: shutdown and close hdl 3 / sock 332
NiBufIClose: clear extension for hdl 3
MsIDetach: detach MS-system
cleanup EM
EsCleanup ....
EmCleanup() -> 0
Es2Cleanup: Cleanup ES2
***LOG Q05=> DpHalt, DPStop ( 6360) [dpxxdisp.c 10484]
Good Bye .....
Please help out.
Thanks in Advance.
Regards,
Gokul Cahndola
Hi,
Have you tried R3trans -d program?
You can do something very easy,
from a command prompt enter
c:\set ORACLE_SID=(one of your oracle SID names)
then go to your SAP executables directory
the execute: C:\R3trans -d
This should end with 000, if it finishes with some other number please open in the same directory where you executed R3trans, open trans.log file with an text editor and paste it here.
If I'm not wrong, when you have two different oracle SID you cannot have an environment variable set like ORACLE_SID, the best is to look for notes about MCOD
good luck
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes Finally I Got the solution.
please check
>r3trans -d To Check Conectivity between Apps and DB Server.
If 000 then its OK- mean connectivity is OK, in this case all work.
when I was installing Second system then tnsname.ora and listner file was creating and privios system entry was removed. DUE to that reasion First one goes down.
Solution:- Both system entry should be Listner and tnsname file. Then Both server will work.
**********THANKS TO "AC"**************
Regards,
Gokul Chandola
please provide SIDs and system numbers for each instance you installed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
TRN ABAP- 01,Java-02 and MAN ABAP-00 and Java-03.
Please give solution what may be the reason.
I have to reinstall otherwise, but I want to solution. This is the 5th time problem SAME.
This should have some solution.
Some time it works, some time not.
Need really help.
Thanks in Adv.
Regards,
Gokul Chandola
Hi Gokul,
I may be late to reply .But your issue seems to be related with database only as you are using Oracle .So after installation of second database you may need to follow SAP Note to maintain listener.ora and tnsnames.ora.
Go through this link [ORACLE DATABASE |http://gagankaushal.blogspot.com/2008/11/installing-two-oracle-databases-on-host.html]problem and follow note also as described there.
Dont go for uninstallation of System...
Regards,
Gagan Deep Kaushal
Dear Gagan Deep Kaushal,
I think you are wrong, cause both database is running fine.
And when I am login through SIDADM user in windows then I can able to login as sqlplus / as sysdba..
mean there is no password required OS user.
Mean database issue is not involved in this case.
I have going for reinstall both SID.
I am facing this frequently, so I have to have resolve this issue.
Thanks,
Gokul Chandola
Hi Gokul,
If you dont have time then you can go for reinstallation.But if you can perform some research then please do it.Have you check r3trans -d for both the databases?I also faced same problem as i am using differnt products on same server.So its nothing like that we can't do it.
Regards,
Gagan Deep Kaushal
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.