OraFAQ Forum: Networking and Gateways » server clause in tnsnames.ora file

Home » RDBMS Server » Networking and Gateways » server clause in tnsnames.ora file (oracle 9.2.0.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

server clause in tnsnames.ora file [message #380069]

Fri, 09 January 2009 00:42

seema.taunk
Messages: 96
Registered: October 2006

Member

Dear all,

I have configured shared server for our 9i database.
But I haven't mentioned server=shared in client side tnsnames.ora file.
Which value will it take?shared or dedicated?
Since for dedicated connection we have to specify server=dedicated clause.
Thanks

Report message to a moderator

Re: server clause in tnsnames.ora file [message #380078 is a reply to message #380069]

Fri, 09 January 2009 01:03

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

http://download.oracle.com/docs/cd/B10500_01/network.920/a96580/mts.htm

Report message to a moderator

Re: server clause in tnsnames.ora file [message #380080 is a reply to message #380069]

Fri, 09 January 2009 01:04

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If shared servers are configured, the default is SHARED (but if you connect as SYS).

Regards
Michel

Report message to a moderator

Re: server clause in tnsnames.ora file [message #380145 is a reply to message #380080]

Fri, 09 January 2009 05:16

seema.taunk
Messages: 96
Registered: October 2006

Member

Thanks for your reply.
We are getting this error when we have added server=shared in tnsnames entry & try to connect to remote server.
ORA -12519 - appropriate service handler not initialized

But if there is not such clause we get dedicated connection.

C:\Documents and Settings\kalepras>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jan 9 16:42:51 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: system@rtrg
Enter password:
ERROR:
ORA-12519: TNS:no appropriate service handler found

Please help.

Report message to a moderator

Re: server clause in tnsnames.ora file [message #380147 is a reply to message #380145]

Fri, 09 January 2009 05:17

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-12519: TNS:no appropriate service handler found
 *Cause: The listener could not find any available service handlers that
 are appropriate for the client connection.
 *Action: Run "lsnrctl services" to ensure that the instance(s) have
 registered with the listener, and are accepting connections

Regards
Michel

Report message to a moderator

Previous Topic:	directory service exception
Next Topic:	change network configurations after installing db & dev suite

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 06 22:51:45 CDT 2026