Find out oracle Server name
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Find out oracle Server name

Hybrid View

  1. #1
    Join Date
    Aug 2001
    Posts
    2
    Hi Everyone,
    I am new to oracle and would like to find out the
    name of a oracle server.How can this be done.

    thank u,

    Ran


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is the OS your oracle server is at:

    1. You can test it through the tnsnames.ora where the host name is your oracle server name and SID name is the name of the instance that you connect to on that server.

    2. You can use the nslookup to see the host name

    3. On the unix you can check through

    uname -a

    Hope one of these would help you.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jan 2001
    Posts
    3,131

    Lightbulb

    SELECT * FROM gobal_name;

    Will give you the DB name, at least in my shop it will.

    In NT try "IPCONFIG /ALL" from a command line, that may work.
    MH

  4. #4
    Join Date
    Aug 2001
    Posts
    2
    HI,
    The OS i am using is Windows 2000.
    Thanks a lot guys.Both your answers where
    very usefull.I really appreciate your help.
    Thank you,

    Regds,
    Ran

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