Two systems in a same box

[Former Member]

Hi Gurus,

I have installed a system (DEV) in Windows 2003 and Oracle 10.2.0.4.0. This installation works fine. Now, i wish install a new system (QAS) in the same server, for this i installed again Oracle, other database. When i run the sapinst, choose the new installation for Oracle, but the process installation stops in the step 10 of 47, Configure Oracle server network. The log say

ERROR 2009-07-21 00:06:13.859

CJS-00095 Error return code. DIAGNOSIS: Return code 1 of executable E:\oracle\CPQ\102/bin/lsnrctl indicates an error. SOLUTION: See log file lsnrctl.log for details.

ERROR 2009-07-21 00:06:13.921

CJS-00095 Error return code. DIAGNOSIS: Return code 1 of executable E:\oracle\CPQ\102/bin/lsnrctl indicates an error. SOLUTION: See log file lsnrctl.log for details.

ERROR 2009-07-21 00:06:13.953

FCO-00011 The step StartListener with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraClient|ind|ind|ind|ind|3|0|NW_OraNetworkSrv|ind|ind|ind|ind|1|0|StartListener was executed with status ERROR ( Last error reported by the step :Error return code. DIAGNOSIS: Return code 1 of executable E:\oracle\CPQ\102/bin/lsnrctl indicates an error. SOLUTION: See log file lsnrctl.log for details.).

In the listener log:

LSNRCTL for 64-bit Windows: Version 10.2.0.1.0 - Production on 21-JUL-2009 00:04:36

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=CPQ.WORLD))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=CPQ))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=desarrollo)(PORT=1527))

The command completed successfully

Can you help me please in find solution for this?

thanks in advance

Alberto Gil

[Former Member]

I can´t solved this issue, in a step of the installation the CPD scheme was deleted and the only option was restore a backup.

THANKS TO ALL

[Former Member]

Hi,

CJS-00095 means your services not started automatically.

Manually set ORACLE_SID/ORACLE_SERVICE for one session then try

lsnrctl >start ;if not stated ,then check listener.log.

You can change entry in listener.ora ,tnsnames.ora .file if needed.

still 2nd listener not working then you can configure through netca.

SurendraJain

[markus_doehr2]

> LSNRCTL for 64-bit Windows: Version 10.2.0.1.0 - Production on 21-JUL-2009 00:04:36

10.2.0.1 is not supported. You should have updated 10.2.0.4 before continuing the installation.

Markus

[Former Member]

Hi Gil,

When your doing the 2ns installation , make sure that u have given different port for the new listener for quality and the listener name always mention as LISTENER_CPQ ..This will help us to detect the error.

-Jag

[Former Member]

Hi Gil,

When your doing the 2ns installation , make sure that u have given different port for the new listener for quality and the listener name always mention as LISTENER_CPQ ..This will help us to detect the error.

-Jag

[Former Member]

Try to configure additional listner and give a go.

[Former Member]

Hi,

There are two possiblities I can say

1. The directory is not exists.

2. There should be the permission problem on the E:\oracle\CPQ\102. Please check the folder E:\oracle\CPQ\102 & file E:\oracle\CPQ\102/bin/lsnrctl is permitted to access by user CPQadm & SAPserviceCPQ users.

I will also recommned you to stop SAP DEV instance & its all oracle & SAP services including listener before you start the QA system installation.

After successful installation of SAP you can configure the listerner refering below OSS notes.

98252 Installing two Oracle databases on a host

153835 Starting Multiple tnslsnr on same server

Hope this helps.

Tnx,

Shambo

[Former Member]

Hi Alberto Gil ,

Rather than installing oracle again you can install the other system in the same database (MCOD installation-Multicomponent in one database).

The mcod installation steps are given in installation guide.

Regards

Ashok Dalai

[Former Member]

Hi,

thanks for all,

I follow the step MCOD and launch the QAS installation but, after waiting a long time, in the phase Create Database schema (near 14 hours), in the step Import ABAP stop the installation and the DEV system donu00B4t works. The error in the installation is:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

E:\usr\sap\CPQ\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090722104047

E:\usr\sap\CPQ\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

E:\usr\sap\CPQ\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

E:\usr\sap\CPQ\SYS\exe\uc\NTAMD64\R3load.exe -testconnect

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12154

DbSl Trace: CONNECT failed with sql error '12154'

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12154

DbSl Trace: CONNECT failed with sql error '12154'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12154

DbSl Trace: CONNECT failed with sql error '12154'

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12154

DbSl Trace: CONNECT failed with sql error '12154'

(DB) ERROR: DbSlErrorMsg rc = 99

E:\usr\sap\CPQ\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

E:\usr\sap\CPQ\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090722104123

AND THE ERROR IN THE STARTUP DEV SYSTEM IS:

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 (2000) (SOFT_KILL)

Stop icman

killing process (3668) (SOFT_KILL)

Terminate gui connections

wait for end of work processes

wait for end of gateway

[DpProcDied] Process lives (PID:2000 HANDLE:176)

waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:29 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died (PID:2000 HANDLE:176)

wait for end of icman

[DpProcDied] Process lives (PID:3668 HANDLE:184)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:30 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:3668 HANDLE:184)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:31 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:3668 HANDLE:184)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:32 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:3668 HANDLE:184)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:33 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:3668 HANDLE:184)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:34 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:3668 HANDLE:184)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:35 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:3668 HANDLE:184)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:36 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:3668 HANDLE:184)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:37 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:3668 HANDLE:184)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:38 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:3668 HANDLE:184)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:39 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:3668 HANDLE:184)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:40 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died (PID:3668 HANDLE:184)

[DpProcDied] Process lives (PID:3708 HANDLE:160)

DpHalt: disconnect j2ee listener

DpHalt: wait for end of j2ee server

[DpProcDied] Process lives (PID:3708 HANDLE:160)

waiting for termination of J2EE server ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1053

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 22 10:25:41 2009

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died (PID:3708 HANDLE:160)

DpStartStopMsg: send stop message (myname is >desarrollo_CPD_00 <)

NiIMyHostName: hostname = 'desarrollo'

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=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 -

DpHalt: received 4 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)

Wed Jul 22 10:25:42 2009

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 12710]

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 28 to: ---

NiBufISelRemove: remove hdl 3 from set0

SiSelNRemove: removed sock 28 (pos=3)

SiSelNRemove: removed sock 28

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 = 1/300/32

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 15)

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 3 / sock 28

NiBufIClose: clear extension for hdl 3

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 2380) [dpxxdisp.c 10908]

Good Bye .....

Pleeease help me .... i have a project stop!!

Edited by: Alberto Gil on Jul 22, 2009 11:17 AM

[former_member204746]

ORA-12154 Means problem with the Oracle listener.

try to start your listener:

lsnrctl start

provide listener.ora and tnsnames.ora

[Former Member]

Hi Eric thanks,

I Review the listener and the status is

LSNRCTL> status

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=CPD.WORLD))

STATUS of the LISTENER

-

---

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Produ

ction

Start Date 22-JUL-2009 11:58:27

Uptime 0 days 0 hr. 25 min. 53 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File E:\oracle\CPD\102\network\admin\listener.ora

Listener Log File E:\oracle\CPD\102\network\log\listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\CPD.WORLDipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\CPDipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=desarrollo)(PORT=1527)))

Services Summary...

Service "CPD" has 2 instance(s).

Instance "CPD", status UNKNOWN, has 1 handler(s) for this service...

Instance "cpd", status READY, has 1 handler(s) for this service...

Service "CPD_XPT" has 1 instance(s).

Instance "cpd", status READY, has 1 handler(s) for this service...

The command completed successfully

This is the listener.ora

################

1. Filename......: listener.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = CPD.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = CPD)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = desarrollo)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = CPD)

(ORACLE_HOME = E:\oracle\CPD\102)

)

)

...........................TNSNAMES

################

1. Filename......: tnsnames.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

################

CPD.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = desarrollo)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = CPD)

(GLOBAL_NAME = CPD.WORLD)

)

)

[anindya_bose]

Hi Alberto

Did you edit your listener.ora and tnsname.ora file before second installation?

Have a look at these notes...

https://service.sap.com/sap/support/notes/28392

https://service.sap.com/sap/support/notes/98252

This should answer your queries

Edited by: Anindya Bose on Jul 21, 2009 2:38 PM

[Former Member]

Hi,

when you start new SAP installation on same system dont need to install Oracle software again

just create new database.

For your issue now you just start listener service

Hopt it will work

Regards,

Nitin Salunkhe

[andreas_herzog]

> E:\oracle\CPQ\102

^^ does this directory really exist?

> 64-bit Windows Error: 2: No such file or directory

GreetZ, AH