Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Location
    japan
    Posts
    35

    Red face Unanswered: what means by 'tnsname' and 'listener' in oracle database ?

    Hi to all ,
    I juz hv one question , what means by 'tnsname' and 'listener'
    in oracle database

    Thank to all of u.

  2. #2
    Join Date
    Mar 2004
    Location
    japan
    Posts
    35
    pls. relpy me asap. thank you.

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Although this link may seem off-topic, it explains what you're asking (just look for the relevant bits):

    http://www.fast-track.cc/teas_ft_rac18.htm

    You can find out everything you need to know by typing 'tnsname' & 'listener' into an internet search engine.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Nov 2004
    Posts
    57

    Red face

    In Oracle the listener is a service that runs on your Oracle server that "listens" or handles requests to a given database. A listener can be setup for a single instance "database" or it can be setup to handle all instances "databases" if more than one instance is installed on your server.

    The tnsnames.ora is a file that you'll find in your /network/admin directory that contains information of instances that have a listener running for them. You'll find the same file in the same directory one all of your Oracle clients.

    To connect a client and a server match the tnsnames.ora information in both files.

    I hope that this might help you out.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Just as a side issue. If you had bothered to check google first, you would have seend 47,500 links for "Oracle tnsnames" and 157,000 for "Oracle listener". Please check the quick and available resources before posting here.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  6. #6
    Join Date
    Jan 2004
    Posts
    492
    Tony also gave a great sticky on the top of this forum for expressly this purpose! And FYI in the future, you need to give people more than 5 minutes to answer a thread. For a lot of the people reading the forum, that was well after they had stopped reading for the evening.

    Here is the link to the sticky: http://www.dbforums.com/t1031644.html
    Oracle OCPI (Certified Practicing Idiot)

Posting Permissions

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