Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    40

    Unanswered: getting database list

    Is it possible to get a list of database avaliable on a server? I do not mean database by schemas/users, I am referring to the "Host String" you enter when you use sql*plus.

    I know you can do the equilvent in SQL Server by using SQLDMO objects, but I haven't been able to find out how to do this in oracle.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    oratab file.
    Code:
    > cat /var/opt/oracle/oratab
    #
    
    # This file is used by ORACLE utilities.  It is created by root.sh
    # and updated by the Database Configuration Assistant when creating
    # a database.
    
    # A colon, ':', is used as the field terminator.  A new line terminates
    # the entry.  Lines beginning with a pound sign, '#', are comments.
    #
    # Entries are of the form:
    #   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
    #
    # The first and second fields are the system identifier and home
    # directory of the database respectively.  The third filed indicates
    # to the dbstart utility that the database should , "Y", or should not,
    # "N", be brought up at system boot time.
    #
    # Multiple entries with the same $ORACLE_SID are not allowed.
    #
    #
    kod1:/export/oracle/u01/app/oracle/product/9.2.0:Y
    #bck1:/export/oracle/u01/app/oracle/product/9.2.0:N
    Last edited by The_Duck; 01-20-04 at 14:10.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jan 2004
    Posts
    40
    is there a way in windows?

  4. #4
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    in W2K you can check your services

    Start->Settings->Control Panel->Administrative Tools->Services

    There you should see something of the form "OracleService{SID}"
    NOTE: Please disregard the label "Senior Member".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •