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

Thread: How to shutdown DB when in distributed environment?

  1. #1
    Join Date
    Mar 2001
    Posts
    61
    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
    Connected.
    SVRMGR> shutdown immediate
    ORA-00106: cannot startup/shutdown database when connected to a dispatcher
    SVRMGR>

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

  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    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
    Posts
    61
    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