1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Print out instances and databases

Discussion in 'General' started by alexcol, Aug 19, 2017.

  1. alexcol

    alexcol Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Colombia
    Good evening, I am newbie in Oracle, and i need your help

    Is there any view to print out which instances and database are mounted in in oracle databas server ?

    Thanks for your help in advanced
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,533
    Likes Received:
    362
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    For each database you have:

    V$DATABASE
    V$INSTANCE

    Those cover the database/instance you are currently connected to. If you have multiple databases/instances on a single server you need to go to each one and get the information.

    There is no 'global view' that displays every instance/database on a single server.
     
  3. alexcol

    alexcol Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Colombia
    Thank you very much for your help