How to shutdown DB when in distributed environment? Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to shutdown DB when in distributed environment?

Hybrid View

  1. #1
    Join Date
    Mar 2001
    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

  2. #2
    Join Date
    Mar 2001
    anyone pls look into this

  3. #3
    Join Date
    Apr 2000
    Edison, NJ
    Try this, might work:
    1. exit server manager
    2. set ORACLE_SID=testdb
    3. connect internal (w/o specifying connect string)
    4. shutdown immediate

  4. #4
    Join Date
    Mar 2001
    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

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