| shared server configuration [message #381799] |
Mon, 19 January 2009 23:16  |
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 #382378 is a reply to message #382019] |
Thu, 22 January 2009 01:21  |
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 #382625 is a reply to message #382547] |
Fri, 23 January 2009 04:34 |
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 #382799 is a reply to message #382798] |
Sat, 24 January 2009 22:24 |
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 |
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 #382805 is a reply to message #382801] |
Sun, 25 January 2009 00:20 |
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 #382815 is a reply to message #382807] |
Sun, 25 January 2009 05:20 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
