How to find if a SAP Application uses Shared server process ??

[former_member245713]

Hi,

Please find the details below wrt to SAP application:

SAP Release : SAP ECC 6.0

Oracle database Version : 10.2.0.4.0

Can you please tell me how to find if my SAP application with oracle uses Shared server mode or Dedicated server mode for oracle database access??

regards,

Arul S

[Former Member]

when i click the logon variable then i get a form like:

application server name

[fidel_vales]

Hi,

IF you have installed SAP following the instructions of SAP (reading and applying the SAP Manuals and Notes) then you are NOT using shared servers as they are not supported by SAP

I'm also curious, do you have two user names?

OP is T. TCS

3rd post is from Arul Sekar

4rth post is from T. TCS

and it seems that you have not read the answer from Nick S.

If so, you should be able to find it easily.

If you are not able, that is not good and you should go back to the oracle documentation.

Sorry to be "bold", but you should put some effort

[Former Member]

Hello,

Can you fire the command

oraSID>lsnrctl services.

also see the below link. It will help you for sure.

http://my.opera.com/onyxluo/blog/2009/02/11/shared-and-dedicated-servers-in-oracle

Thanks,

Nick S

[Former Member]

Hi Nick,

Thanks for your reply.

I am also pasting the output of "lsnrctl services"

LSNRCTL for HPUX: Version 10.2.0.4.0 - Production

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

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

Services Summary...

Service "R1Q" has 1 instance(s).

Instance "R1Q", status UNKNOWN, has 2 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0

LOCAL SERVER

"DEDICATED" established:269921 refused:0

LOCAL SERVER

The command completed successfully

This looks like dedicated connection with the Oracle database..

Can you please comment on this?

Regards,

Arul S

[former_member245713]

Hi,

Thanks for your reply.

Please find the output of the lsnrctl services below.

nlscuxs0:oraT1P 2> lsnrctl services

LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 06-MAY-2010 05:02:33

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

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

Services Summary...

Service "T1P" has 1 instance(s).

Instance "T1P", status UNKNOWN, has 2 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0

LOCAL SERVER

"DEDICATED" established:296328 refused:0

LOCAL SERVER

The command completed successfully.

Can you please confirm if this is a dedicated connection to the database??

regards,

Arul S

TCSTAM SAP.