OraFAQ Forum: Networking and Gateways » How to set dispatchers parameter

Home » RDBMS Server » Networking and Gateways » How to set dispatchers parameter

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

How to set dispatchers parameter [message #168107]

Tue, 18 April 2006 19:35

Abraham
Messages: 6
Registered: August 2000
Location: New Jersey

Junior Member

Hello Friends,
I am trying to set up Oracle shared server (MTS) on my test installation on linux. I use an spfile, so I want to do an alter system set command with scope=spfile. I get this error. What am I doing wrong?
Thanks for your advice.

SQL> alter system set dispatchers ='(PROTOCOL=TCP)' scope = spfile;
alter system set dispatchers ='(PROTOCOL=TCP)' scope = spfile
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

SQL>

Report message to a moderator

Re: How to set dispatchers parameter [message #168159 is a reply to message #168107]

Wed, 19 April 2006 02:21

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

SQL> alter system set dispatchers='(PROTOCOL=TCP)' scope=spfile;
alter system set dispatchers='(PROTOCOL=TCP)' scope=spfile
                                              *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM


SQL> alter system set dispatchers='(PROTOCOL=TCP)' ;

System altered.

Report message to a moderator

Re: How to set dispatchers parameter [message #168267 is a reply to message #168159]

Wed, 19 April 2006 09:12

Abraham
Messages: 6
Registered: August 2000
Location: New Jersey

Junior Member

It does not work for me. Here is what I get:

SQL> show parameter dispatcher

NAME TYPE VALUE
------------------------------------ ----------- ----------------------------
dispatchers string

SQL> alter system set dispatchers='(PROTOCOL=TCP)';
alter system set dispatchers='(PROTOCOL=TCP)'
*
ERROR at line 1:
ORA-00105: dispatching mechanism not configured for network protocol
(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))

SQL> !oerr ora 105
00105, 00000, "dispatching mechanism not configured for network protocol %s"
// *Cause: Trying to alter the dispatcher's configuration for a network
// protocol that was not specified in the INIT.ORA file.
// *Action: Include the network protocol in the system parameter
// DISPATCHERS in INIT.ORA and re-start the system.

SQL>

Report message to a moderator

Re: How to set dispatchers parameter [message #168581 is a reply to message #168107]

Fri, 21 April 2006 01:10

ramsat
Messages: 49
Registered: November 2005

Member

hai,

in the following
alter system set dispatchers= '(PROTOCOL=TCP) (SERVICE=netdb2XDB)' scope=spfile;

ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

SQL> alter system set dispatchers= '(PROTOCOL=TCP) (SERVICE=netdb2XDB)' ;

System altered.

The above system altered tells u that it is altered in the pfile.

For spfile the command dosent play.

so u create a fpile from spfile do chaanges and open using pfile,
create spfile from pfile
and then shutdown the dba and open the db using spfile.

Thank U
Ramesh

Report message to a moderator

Previous Topic:	ORA-12547: TNS: lost Contact
Next Topic:	Connection problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 07:45:01 CDT 2024