ORA-00106: cannot startup/shutdown database when connected to a dispatcher
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-00106: cannot startup/shutdown database when connected to a dispatcher

  1. #1
    Join Date
    Aug 2001
    Posts
    267
    I am getting this error while I am trying to shutdown and startup the database remotely having my init.ora file local ..

    ORA-00106: cannot startup/shutdown database when connected to a dispatcher

    What is this dispatcher means.. How to solve this problem . My intention is to start or shutdown database remotely ..I commented the line dispather in my init.ora file and restarted .And tried to shutdown the database remotely
    Raghu

  2. #2
    Join Date
    Aug 2001
    Posts
    75
    You can't start or stop oracle database when connected by MTS dispatcher.
    In your tnsnames.ora , check whether you have SERVER=SHARED entry, change it to SERVER=DEDICATED

    Your tnsnames.ora should have something like this.
    Please note the SERVER=DEDICATED in the below example.
    sales=
    (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
    (CONNECT_DATA=
    (SERVICE_NAME=sales.us.acme.com)
    (SERVER=dedicated)))


    OCP 8i

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