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
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.
Click Here to Expand Forum to Full Width