Home » RDBMS Server » Server Administration » Shared Server problem (Oracle 10g, RHEL)
Shared Server problem [message #577493] Sun, 17 February 2013 09:04 Go to next message
morad_dba
Messages: 72
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 Go to previous messageGo to next message
BlackSwan
Messages: 22790
Registered: January 2009
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 Go to previous messageGo to next message
John Watson
Messages: 4564
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 Go to previous messageGo to next message
morad_dba
Messages: 72
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 #577512 is a reply to message #577498] Sun, 17 February 2013 14:13 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.

Regards
Michel
Re: Shared Server problem [message #577519 is a reply to message #577512] Mon, 18 February 2013 02:43 Go to previous messageGo to next message
morad_dba
Messages: 72
Registered: June 2008
Member


Pls tell me how to connect to shared server from remote machine...
Re: Shared Server problem [message #577520 is a reply to message #577519] Mon, 18 February 2013 02:47 Go to previous messageGo to next message
John Watson
Messages: 4564
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
(though I won't repeat again unless you say "thank you for trying to help"
Re: Shared Server problem [message #577538 is a reply to message #577512] Mon, 18 February 2013 05:16 Go to previous messageGo to next message
morad_dba
Messages: 72
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 #577546 is a reply to message #577538] Mon, 18 February 2013 05:29 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In your sqlnet.ora you must have:
NAMES.DIRECTORY_PATH= (EZCONNECT,TNSNAMES)

Regards
Michel
Re: Shared Server problem [message #577550 is a reply to message #577546] Mon, 18 February 2013 05:41 Go to previous messageGo to next message
morad_dba
Messages: 72
Registered: June 2008
Member


Actually,I want to connect using tnsname to connect to shared server not using Easyconnect, or hostnaming method.

Regards,

Morad..
Re: Shared Server problem [message #577559 is a reply to message #577550] Mon, 18 February 2013 06:28 Go to previous message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: how is segment different from object?
Next Topic: error in re-creation of a datafile
Goto Forum:
  


Current Time: Fri Sep 19 09:27:43 CDT 2014

Total time taken to generate the page: 0.06654 seconds