Home » RDBMS Server » Networking and Gateways » shared server configuration (HP UX pa risc 64 bit)
shared server configuration [message #381799] Mon, 19 January 2009 23:16 Go to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Dear all,


I have configured shared server for one of our production database. But still we are getting dedicated connections from some branches.
server os-> hp-ux pa-risc 64 bit
sevrer oracle version- 9.2.0.8

client os- > windows xp sevrice pack2
client oracle version -> 9.2.0.1

we have checked tnsnames.ora file in those machines which are giving dedicated connections, but it doesn't have server clause.

Please guide
Re: shared server configuration [message #381823 is a reply to message #381799] Tue, 20 January 2009 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also check sqlnet.ora

Regards
Michel
Re: shared server configuration [message #381912 is a reply to message #381823] Tue, 20 January 2009 04:44 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
We have checked sqlnet. ora file also. But we didn't find anything problematic in that

Re: shared server configuration [message #381916 is a reply to message #381912] Tue, 20 January 2009 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I also see no problem with the file you didn't post.
Also check TNS_ADMIN variable.

Regards
Michel
Re: shared server configuration [message #382019 is a reply to message #381799] Tue, 20 January 2009 12:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I have configured shared server for one of our production database
I gave up using shared server more than a decade ago due to performance limitations.

The ONLY reason why shared server ever existed is because in the past the memory footprint of Oracle was "large" when compared to available physical memory.

On modern DB servers with multiple GIGABYTES of RAM; the lack of RAM is rarely/never a problem.

If you have performance problems now & hope that shared server will fix them, I expect you'll sorely disappointed if/when you ever get to a 100% shared server implementation.

Good Luck on your Wild Goose chase!
Re: shared server configuration [message #382378 is a reply to message #382019] Thu, 22 January 2009 01:21 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi blackswan,

Thanks for your reply. But OS connections for that database were reduced to 1/5 compared to previous dedicated connections.
Will it decrease cpu utilization? since I am unable to find any reduction in that.
dedicated connections are coming in our database since some machines have service_name entry instaed of sid.
& on server we have 2 services for one instance.( one static & one dynamic with domain name).

Thanks
Re: shared server configuration [message #382547 is a reply to message #381799] Thu, 22 January 2009 21:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Will it decrease cpu utilization?
The ONLY way to decrease CPU utilization, is to ask the DB to do less work.
If/when the workload stays at a given level, it is irrelevant the number of sessions doing the actual processing.

Say you have 50 sessions which consume 1 CPU Units
or have 10 session which consume 5 CPU Units.
If the amount of SQL remains unchanged, the amount of CPU cycles stays at the same (previous) level.
Otherwise the application will respond noticeably slower.

There Is No Such Thing As A Free Lunch (TANSTAAFL)!

Re: shared server configuration [message #382625 is a reply to message #382547] Fri, 23 January 2009 04:34 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Dear all,


At server, Output of lsnrctl services
LSNRCTL for HPUX: Version 9.2.0.8.0 - Production on 23-JAN-2009 10:37:17

Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTO 
=TCP)(HOST=ip)(PORT=6082)(QUEUESIZE=256)))
Services Summary...
Service "eximdb" has 1 instance(s).
  Instance "eximdb", status UNKNOWN, has 1 handler(s) for this  service...
Handler(s):
   "DEDICATED" established:24011 refused:0
   LOCAL SERVER
Service "eximdb.db_exim" has 1 instance(s).
Instance "eximdb", status READY, has 4 handler(s) for this service...
Handler(s):
"D003" established:29311 refused:0 current:52 max:2026 state:ready
DISPATCHER <machine: Aaa, pid: 17536>
(ADDRESS=(PROTOCOL=tcp)(HOST=ip)(PORT=49341))
"D002" established:30411 refused:0 current:51 max:2026 state:ready
DISPATCHER <machine: Aaa, pid: 17528>
(ADDRESS=(PROTOCOL=tcp)(HOST=ip)(PORT=49340))
"D001" established:29851 refused:0 current:51 max:2026 state:ready
DISPATCHER <machine: Aaa, pid: 17519>
(ADDRESS=(PROTOCOL=tcp)(HOST=ip)(PORT=49339))
"D000" established:29241 refused:0 current:51 max:2026 state:ready
DISPATCHER <machine: Aaa, pid: 17505>
(ADDRESS=(PROTOCOL=tcp)(HOST=ip)(PORT=49337))
The command completed successfully.


One service eximdb is static registered & one eximdb.db_exim is dynamic registered. where db_exim is domain name.

So in client tnsnames.ora file, when sid is specified it makes shared connection & when
service_name eximdb is specified it makes dedicated connection.
But when we checked parameters in database, mts_service=eximdb &
service_names=eximdb.db_exim & in

*.DISPATCHERS='(ADDRESS=(PROTOCOL=TCP)(host=ipaddress))(listener=eximdb)(DISPATCHERS=4)(service=eximdb)' we have given service name as eximdb.
Why it is creating new service eximdb.db_exim & not taking eximdb service?

The SERVICE attribute takes precedence over the SERVICE_NAMES parameter. so it should not use service_names=eximdb.db_exim & should use eximdb which we have given in dispatchers string.


Thanks

[Updated on: Fri, 23 January 2009 04:50]

Report message to a moderator

Re: shared server configuration [message #382797 is a reply to message #382625] Sat, 24 January 2009 21:57 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Any help??
Re: shared server configuration [message #382798 is a reply to message #381799] Sat, 24 January 2009 22:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post contents of listener.ora
Re: shared server configuration [message #382799 is a reply to message #382798] Sat, 24 January 2009 22:24 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
LISTENER_db_EXIM =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 6082)(QUEUESIZE=256))
)
)
)

SID_LIST_LISTENER_db_EXIM =
(SID_LIST =
(SID_DESC =
(SDU=32768)
(GLOBAL_DBNAME = eximdb)
(ORACLE_HOME = /oracle/app/oracle/product/9.2)
(SID_NAME = eximdb)
)
)
Re: shared server configuration [message #382800 is a reply to message #381916] Sat, 24 January 2009 22:32 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Sorry Michel,I couldn't post contents of sqlnet.ora file at client side since we don't have access to client machine. But I will try to get it.
When we have checked previously, it contain,
default domain xyz,
& directory_path=tnsnames.


Re: shared server configuration [message #382801 is a reply to message #381799] Sat, 24 January 2009 22:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Post results from
lsnrctl status
lsnrctl status db_EXIM
lsnrctl service db_EXIM

[Updated on: Sat, 24 January 2009 23:11]

Report message to a moderator

Re: shared server configuration [message #382805 is a reply to message #382801] Sun, 25 January 2009 00:20 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
lsnrctl status LISTENER_db_EXIM

LSNRCTL for HPUX: Version 10.2.0.3.0 - Production on 25-JAN-2009 11:50:45

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ip)(PORT=6082)(QUEUESIZE=256)))
STATUS of the LISTENER
------------------------
Alias LISTENER_db_EXIM
Version TNSLSNR for HPUX: Version 9.2.0.8.0 - Production
Start Date 20-JAN-2009 17:24:18
Uptime 4 days 18 hr. 26 min. 27 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/9.2/network/admin/listener.ora
Listener Log File /oracle/app/oracle/product/9.2/network/log/listener_db_exim.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip)(PORT=6082)))
Services Summary...
Service "eximdb" has 1 instance(s).
Instance "eximdb", status UNKNOWN, has 1 handler(s) for this service...
Service "eximdb.db_exim" has 1 instance(s).
Instance "eximdb", status READY, has 4 handler(s) for this service...
The command completed successfully



Output of lsnrctl services I have posted previously.
Re: shared server configuration [message #382807 is a reply to message #382800] Sun, 25 January 2009 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
seema.taunk wrote on Sun, 25 January 2009 05:32
Sorry Michel,I couldn't post contents of sqlnet.ora file at client side since we don't have access to client machine. But I will try to get it.
When we have checked previously, it contain,
default domain xyz,
& directory_path=tnsnames.

Without this and client tnsnames.ora entry nothing can be said.

Regards
Michel

Re: shared server configuration [message #382815 is a reply to message #382807] Sun, 25 January 2009 05:20 Go to previous message
seema.taunk
Messages: 96
Registered: October 2006
Member
Some client tnsnames.ora entry contain service_names=eximdb & from those, we get dedicated connection.
& some client tnsnames.ora entry contain sid=eximdb & from those, we get shared connection. If I change service_name=eximdb.db_exim, we get shared connection since dispatcher is registered with taht service.

My question is, in dispatcher clause we have given service=eximdb.
Why listener is not registering with this service name?
Why new service eximdb.db_exim is created ( where db_exim is domain name) & dispatcher register with that?

[Updated on: Sun, 25 January 2009 05:21]

Report message to a moderator

Previous Topic: SQL NET LOG
Next Topic: ORA-12514: TNS:listener does not currently know of service requested in connect
Goto Forum:
  


Current Time: Thu Mar 28 07:27:26 CDT 2024