Home » RDBMS Server » Networking and Gateways » server clause in tnsnames.ora file (oracle 9.2.0.8)
server clause in tnsnames.ora file [message #380069] Fri, 09 January 2009 00:42 Go to next message
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
Re: server clause in tnsnames.ora file [message #380078 is a reply to message #380069] Fri, 09 January 2009 01:03 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

http://download.oracle.com/docs/cd/B10500_01/network.920/a96580/mts.htm
Re: server clause in tnsnames.ora file [message #380080 is a reply to message #380069] Fri, 09 January 2009 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If shared servers are configured, the default is SHARED (but if you connect as SYS).

Regards
Michel
Re: server clause in tnsnames.ora file [message #380145 is a reply to message #380080] Fri, 09 January 2009 05:16 Go to previous messageGo to next message
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.
Re: server clause in tnsnames.ora file [message #380147 is a reply to message #380145] Fri, 09 January 2009 05:17 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: directory service exception
Next Topic: change network configurations after installing db & dev suite
Goto Forum:
  


Current Time: Sat Dec 10 01:29:24 CST 2016

Total time taken to generate the page: 0.15199 seconds