| Shared Server problem [message #577493] |
Sun, 17 February 2013 09:04  |
morad_dba
Messages: 93
Registered: June 2008
|
Member |
|
|
Dear all,
I configured shared server as follows (server ip : 172.16.50.64)
ALTER SYSTEM SET DISPATCHERS="(PRO=TCP)(DIS=3)";
ALTER SYSTEM SET SHARED_SERVERS = 2;
ALTER SYSTEM SET SHARED_SERVER_SESSIONS = 5;
When I am trying to connect from a client (another machine) it returns errors as
[oracle@R10HOST1 admin]$ sqlplus hr/hr@orcl
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Feb 17 19:13:02 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
I configured client tnsnames.ora file as
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.50.64)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = shared)
(SERVICE_NAME = orcl)
)
)
I can connect to server by dedicated connection from client by tnsnames as
orcl2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.50.64)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = dedicated)
(SERVICE_NAME = orcl)
)
)
Note: I can also connect by using shared connection form server using tnsname but from remote machine can not connect using shared server options.
Pls help me.. to find where is the problem occurred?
Regards,
Morad.
|
|
|
|
| Re: Shared Server problem [message #577495 is a reply to message #577493] |
Sun, 17 February 2013 09:16  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
post results from following SQL
1* select dispatchers, connections, sessions, pool, service from V$DISPATCHER_CONFIG
SQL> /
DISPATCHERS CONNECTIONS SESSIONS POOL SERVICE
----------- ----------- ---------- ---- --------------------------------
1 1022 1022 OFF orclXDB
post results from following OS commands run on DB Server system
lsnrctl status
lsnrctl service
[Updated on: Sun, 17 February 2013 09:16] Report message to a moderator |
|
|
|
| Re: Shared Server problem [message #577496 is a reply to message #577493] |
Sun, 17 February 2013 09:17 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Perhaps begin by eliminating the use of the tnsnames file, can you connect like this:
sqlplus hr/hr@172.16.50.64:1521/orcl:dedicated
sqlplus hr/hr@172.16.50.64:1521/orcl:shared
(please note my use of [code] tags, and use them yourself in future.
[Updated on: Sun, 17 February 2013 09:18] Report message to a moderator |
|
|
|
| Re: Shared Server problem [message #577498 is a reply to message #577495] |
Sun, 17 February 2013 09:51 |
morad_dba
Messages: 93
Registered: June 2008
|
Member |
|
|
select dispatchers, connections, sessions, pool, service from V$DISPATCHER_CONFIG
DISPATCHERS CONNECTIONS SESSIONS POOL SERVICE
----------- ----------- ---------- ---- -------------------------
3 500 1000 BOTH orcl,orcl,orcl_XPT
[oracle@t24testdb7 ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-FEB-2013 21:38:33
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=t24testdb7)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 25-NOV-2012 07:49:03
Uptime 84 days 13 hr. 49 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=t24testdb7)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 4 handler(s) for this service...
Service "orclXDB" has 2 instance(s).
Instance "orcl", status READY, has 0 handler(s) for this service...
Instance "rmancat", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 4 handler(s) for this service...
[oracle@t24testdb7 ~]$ lsnrctl services
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-FEB-2013 21:38:41
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=t24testdb7)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 4 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
"D001" established:8 refused:0 current:1 max:1000 state:ready
DISPATCHER <machine: t24testdb7, pid: 27474>
(ADDRESS=(PROTOCOL=tcp)(HOST=t24testdb7)(PORT=39751))
"D000" established:2 refused:0 current:2 max:1000 state:ready
DISPATCHER <machine: t24testdb7, pid: 12474>
(ADDRESS=(PROTOCOL=tcp)(HOST=t24testdb7)(PORT=5455))
"D002" established:9 refused:0 current:0 max:1000 state:ready
DISPATCHER <machine: t24testdb7, pid: 27476>
(ADDRESS=(PROTOCOL=tcp)(HOST=t24testdb7)(PORT=19703))
Service "orclXDB" has 2 instance(s).
Instance "orcl", status READY, has 0 handler(s) for this service...
Instance "rmancat", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: t24testdb7, pid: 8975>
(ADDRESS=(PROTOCOL=tcp)(HOST=t24testdb7)(PORT=55382))
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 4 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
"D001" established:8 refused:0 current:1 max:1000 state:ready
DISPATCHER <machine: t24testdb7, pid: 27474>
(ADDRESS=(PROTOCOL=tcp)(HOST=t24testdb7)(PORT=39751))
"D000" established:2 refused:0 current:2 max:1000 state:ready
DISPATCHER <machine: t24testdb7, pid: 12474>
(ADDRESS=(PROTOCOL=tcp)(HOST=t24testdb7)(PORT=5455))
"D002" established:9 refused:0 current:0 max:1000 state:ready
DISPATCHER <machine: t24testdb7, pid: 27476>
(ADDRESS=(PROTOCOL=tcp)(HOST=t24testdb7)(PORT=19703))
Regards,
Morad
|
|
|
|
|
|
|
|
| Re: Shared Server problem [message #577520 is a reply to message #577519] |
Mon, 18 February 2013 02:47 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Quote:Pls tell me how to connect to shared server from remote machine... I already have. I'll repeat it:sqlplus hr/hr@172.16.50.64:1521/orcl:shared
|
|
|
|
| Re: Shared Server problem [message #577538 is a reply to message #577512] |
Mon, 18 February 2013 05:16 |
morad_dba
Messages: 93
Registered: June 2008
|
Member |
|
|
If i try to connect by
sqlplus hr/hr@172.16.50.64:1521/orcl:shared
then it returns errors
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Regards,
Morad.
|
|
|
|
|
|
|
|
| Re: Shared Server problem [message #577559 is a reply to message #577550] |
Mon, 18 February 2013 06:28 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
So you do not do what John told you or do this mean it works with John's way but not with tnsnames.ora?
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
