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

Thread: oratab for NT??

  1. #1
    Join Date
    Aug 2000
    Posts
    163

    Wink

    I a new dba learning/investigating my system.
    How do I find out how many databases and what versions of Oracle they use.
    In Unix you can do find . -name oratab -print. That command will find an oratab file which will list all of the databases, their Oracle versions with their associated ORACLE_HOME directories. Also, it'll show you if the database automaticly starts when the system is booted up.
    Is there such command on NT?

  2. #2
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    In Task Manager, you will see processes by the name of Oracle.exe. Each process is a db on the machine. Use explorer to find out the ORACLE_HOME(S). Services in Control Panel lists the names of the dbs.

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I guess its registry

    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID`s



  4. #4
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    All installed Oracle databases are listed in the NT Services.
    It also shows if the database is in Autostart mode.

    Actually you may be able to create a database without creating NT services; in that case you may look into the NT Registry (run regedit on DOS) or look in the installation in the directory structure like --
    d:\oracle\oradata\sid_name


    - Rajeev


  5. #5
    If you ask me if is it posible create a DB without create Service, I would say no.
    Maybe I'm wrong, I just can't imagine this process.
    :D
    Ramon Caballero, DBA, rcaballe@yahoo.com

  6. #6
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    This should not be possible .
    :D

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