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

Thread: Oracle Help

  1. 11-20-2005, 05:46 PM #1
    freshjada
    freshjada is offline Junior Member
    Join Date
    Nov 2005
    Posts
    1

    Oracle Help

    Hi

    Ive just installed oracle 10g onto my computer and have for afew weeks been playing around and learning SQL.

    Is anyone here able to tell me how I find out the oracle instance name aswell as the Tns name ?

    currently written down from the installation process i have the SID - and the GDN.

    thanks
    Reply With Quote Reply With Quote
  2. 11-20-2005, 08:28 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    select * from v$instance

    and for you the SID = instance name

    define what you mean by tnsname?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width