I am running oracle on W2K running in distributed environment and trying to shutdown this is the error I get, How to get around??
Second question is I have another 7.3 DB running in dedicated environment can I change that into distributed by just changing the init parameters? or do I have to take extra steps ?
SVRMGR> connect internal/oracle@testdb
SVRMGR> shutdown immediate
ORA-00106: cannot startup/shutdown database when connected to a dispatcher
anyone pls look into this
Try this, might work:
1. exit server manager
2. set ORACLE_SID=testdb
3. connect internal (w/o specifying connect string)
4. shutdown immediate
Thanks Halo that worked !!!
can you also guide me as to how to change 7.3 from dedicated to shared environment.
and is it wise because lot of users are machines and they don't have much of activity but need to maintain a connection.
will changing init will suffice I mean how to create dispatcher service will it be created automatically?
but thanks again for previous help