Dispatchers and Shared Server Settings
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Dispatchers and Shared Server Settings

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Dispatchers and Shared Server Settings

    SQL> alter system set shared_servers=3;
    alter system set shared_servers=3
    *
    ERROR at line 1:
    ORA-02097: parameter cannot be modified because specified value is invalid
    ORA-00120: dispatching mechanism not enabled or installed


    SQL> alter system set shared_servers=3 scope=spfile;

    System altered.

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


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


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


    SQL> shutdown immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup
    ORA-00121: SHARED_SERVERS specified without DISPATCHERS

    Do anybody have idea about it?
    Thanx in Advance

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    Sure...it's called read the documentation (Configuring Oracle for the Shared Server) that explains it adequately.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width