ERP & CRM on the same oracle listner

[Former Member]

Hello Experts,

I have installed the ERP & CRM on the same server with the same database instance and listener port number.

And now i am able to run either ERP or CRM, whose sapsystemname is defined in the enviroment variable.

Please tell me, how can i run both the instances simultaneously.

How can i change the listener port number for the already installed ?

Please help.

Thanks,

Abha

[Former Member]

hi Abha

well from what i can gather from your explanation you want to have the listener for the second system running...

plz try this

in addition to changes in listener.ora and tnsnames.ora

1.) start configtool and go to secure store, here also change the listener port.

2.) also in your profile dir , there will be db file

eg for oracle its oracle .... enter here and make the changes to the listener port

surely both your listeners will start with the lsnrctl command

Regards,

shanser

Edited by: Shanser on May 21, 2011 4:23 PM

Edited by: Shanser on May 21, 2011 4:24 PM

[former_member266290]

Hi

You have to adjust the files listener.ora and tnsnames.ora.

Please follow the note [https://service.sap.com/sap/support/notes/98252|https://service.sap.com/sap/support/notes/98252] for the same.

Hope it helps you.

Regards

Vijay

[Former Member]

Hi vijay,

I have tried this, but it didnt work.

I have shown the listner file & tnsname file.Please help me to solve this issue.

LISTENER FILE

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

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

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

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

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

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

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DBA.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DBA)----

---

DBA is database instance

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = HCL1)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = DBA)

(ORACLE_HOME = D:\oracle\DBA\102)

)

)

TNSNAMES FILE

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

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

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

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

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

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

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

DBA.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = HCL1)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = DBA)

(GLOBAL_NAME = DBA.WORLD)

)

)

Thanks,

Abha

[Former Member]

Please go through Note 388866.

Regards

Vinod

[Former Member]

you have to change (PORT = 1527) in both file.

before doing change stop database and listener.

Regards,

Nikunj Thaker

[Former Member]

Hi,

I have tried this but still its not working.....

Is there any other place where i should change the port number?

Thanks,

Abha

[Former Member]

Dear Abha,

How you identified its not working ?

What correction you did ?

Regards.

Nikunj Thaker

[Former Member]

Hi,

1) I have replaced the port number 1527 to 1521 in both the files, its not work.

2) I have entered the one additional port to both the files e.i. 1527 & 1521, its again dont work.

Thanks,

Abha

[Former Member]

and MCOD installation guide...

with Oracle Net Configuration assistant you can configure multiple listeners if needed. now you are accessing the SAME DB with different user IDs. It depends on what kind of landscape you are using.

Go through the mentioned note

Vinod

[Former Member]

<div class="jive-quote">&gt; 1) I have replaced the port number 1527 to 1521 in both the files, its not work.

&gt; 2) I have entered the one additional port to both the files e.i. 1527 &#38; 1521, its again dont work.

</div>

how you traced ?

1. means after changing port listener service not coming up ?

2. how you traced its not listening on new port number ?

Regards,

Nikunj Thaker

[Former Member]

<div class="jive-quote">&gt; 1) I have replaced the port number 1527 to 1521 in both the files, its not work.

&gt; 2) I have entered the one additional port to both the files e.i. 1527 &#38; 1521, its again dont work.

</div>

how you traced ?

1. means after changing port listener service not coming up ?

2. how you traced its not listening on new port number ?

Regards,

Nikunj Thaker

[Former Member]

Hi Nikunj,

After change the port number, I have restart the server, but its not working.

can u please let me know that, how can i trace the listener port and what all activites i should perform to get the system working.

Thanks,

Abha

[Former Member]

execute below comman @ OS level and share output

lsnrctl status

Regards,

Nikunj Thaker

[Former Member]

Hi Nikunj,

After adding the 1 more listner port(1521), I got

Listening Endpoints Summary...

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

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

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HCL1)(PORT=1521)))

ECC ABAP, ECC JAVA & CRM ABAP is working fine but CRM JAVA is not working.

CRM JAVA jcontrol.exe ,Dveloper trace is.

hr 6848] Wed Apr 13 11:39:50 2011

[Thr 6848] ***LOG Q0I=> NiPConnect2: connect (10061: WSAECONNREFUSED: Connection refused) [nixxi.cpp 2835]

[Thr 6848] *** ERROR => NiPConnect2: SiPeekPendConn failed for hdl 0 / sock 548

(SI_ECONN_REFUSE/10061; I4; ST; 10.20.70.210:3905) [nixxi.cpp 2835]

[Thr 6848] *** ERROR => MsIAttachEx: NiBufConnect to HCL1/3905 failed (rc=NIECONN_REFUSED) [msxxi.c 652]

[Thr 6848] *** ERROR => Can't attach to message server (HCL1/3905) [rc = -100]-> terminate [jcntrms.c 374]

[Thr 6848] JControlCloseProgram: started (exitcode = -100)

[Thr 6848] *** ERROR => MsIModState: not_attached [msxxi.c 3838]

[Thr 6848] *** ERROR => Can't modify message server state (state = 7, rc = -3) [jcntrms.c 841]

[Thr 6848] JControlCloseProgram: good bye... (exitcode = -100)

can u please help me to make it working?

Thanks,

Abha

[Former Member]

Hi Abha,

There is no issue with ORACLE Listener.

As i understand you are having Single Oracle Instance.

Why you want to run oracle listener on multiple ports ?

Regards,

Nikunj Thaker

[Former Member]

Hi Nikunj,

I have installed the ECC & CRM on the same database instance, so, they both are not working simultanusly.

Only the sap instance those sapsystemname is mention in the environment variable is working.

To make both the servers working togther. I want to create two ports on the same listener.

Is there any other way to make them work togtherk, then let me know?

Please help, to make the CRM java instance working,after the port change?

Thanks,

Abha

[Former Member]

You have to read the note

check Note 388866 - Multiple Components on One Database - Installation

The concept is

One database will contain the data of all systems

Each SAP system will create its own database schema/database user sap<SID>

Each SAP system will create its own set of tablespaces

So now you have 2 userids which will connect to same database through same listener.

Explain how did/what kind of installation you followed???

Regards

Vinod

Edited by: Vinod Udapudi on Apr 13, 2011 2:59 PM

[Former Member]

Hi Vinod,

We have the single database instance(DBA) and over which we have installed ERP (ABAPJAVA) & CRM(ABAPJAVA), they both have different database files but using the same instance.

After installation only one server is working at a time, due to same listener and to make them work together i have added one more listner port, but after that CRM(JAVA) is not working, else (ERP(ABAP+JAVA) & CRM(ABAP))is working fine.

can u help m to made it working.?

Thanks,

Abha