DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: default database

  1. #1
    Join Date
    Feb 2001
    Posts
    103
    Hi guys,
    How can i make my database as a default database. I have four databases on my server.. All of the them try to get mounted at the same time. Thatswhy my main database consumes lot of time to get up and running.. I tried making the services manual of other databases. But i want to know how can i make my one database as a default database which will only startup when my machine starts..

    Thanks in advance..
    When the going gets tough, the tough gets going

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    if you changed the services from automatic to manual, your 3 other databases should not startup at boot ...

  3. #3
    Join Date
    Feb 2001
    Posts
    103
    Hi pipo,

    I have already done that. Is there some other way to do it..
    When the going gets tough, the tough gets going

  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    you're under NT, you're using services, your freedom is omre than restricted !!
    the only other way I would see to do that would be to change all services to manual startup, and to use a script at startup which uses oradim to startup the instances that were chosen to be started ...

  5. #5
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    You could use a batch file and the NET START command like:

    NET START OracleServiceTSH1
    NET START Oracle817TNSListener
    NET START Oracle817Agent
    NET START OracleServiceTSH2
    NET START OracleServiceTSH3
    NET START OracleServiceTSH4

    That way the first instance would be running before the 2, 3 and 4 were started.

    This registry key will fire the script when you first log in:

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run]
    "DBSTARTUP"="c:\\mypath\\mydbstartup.bat"

    Obviously you'll need to adjust it to suit you.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

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