How to disable clients connecting thru local naming
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: How to disable clients connecting thru local naming

  1. #1
    Join Date
    Oct 2003
    Location
    Sydney
    Posts
    29

    How to disable clients connecting thru local naming

    Hi,
    We have setup oracle names server. Is there anyway i can force all the clients to use only ONAMES for address resolution? I want to block all other requests.

    Thanks
    Manohar

  2. #2
    Join Date
    Oct 2003
    Location
    Sydney
    Posts
    29
    No responses/ ideas on this???
    Well, let me explain my whole case..
    i dont want my users using TNSNAMES for names resolution and come to me saying i am unable to access a particular database if any changes occured. I want all users to use ONAMES first in names.directory_path.
    Also, in a high availability environment, i can specify failover stuff in connection thru ONAMES but users using TNSNAMES not knowing the details can make ordinary connection.
    Is there any way for the Listener to find out how a service name is resolved (using TNSNAMES/ONAMES/HOSTNAME..) and then block certain requests?
    Although its some crazy idea, i just want to know if an option exists!!!

    -mano

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    Here's a crazy idea: get rid of Oracle Names. It is deprecated in 9i. It was buggy to begin with, and it never really went anywhere. Gazillions of people use local naming, very successfully, all the time. You can have all your users use TNS_ADMIN. To make a change (e.g., a database moves to a different server), you change one word in one file. What's your problem with doing that?

  4. #4
    Join Date
    Oct 2003
    Location
    Sydney
    Posts
    29
    Thats a totally crazy stecal idea!!
    Its depricated in 10g not 9i and Oracle provides a clean method to upgrade it to a LDAP based server. And centralized administration has numerous advantages over local naming, and especially in a big organization like ours.
    To make a change, u just change 1 word in 1 file - thats right, but has to be done on every single client.
    what u suggested no solution, rather its like running away.

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by manodba
    Thats a totally crazy stecal idea!!
    Its depricated in 10g not 9i and Oracle provides a clean method to upgrade it to a LDAP based server. And centralized administration has numerous advantages over local naming, and especially in a big organization like ours.
    To make a change, u just change 1 word in 1 file - thats right, but has to be done on every single client.
    what u suggested no solution, rather its like running away.
    Go with what Stecal says, Oracle NAMES is a PITA.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Oct 2003
    Location
    Sydney
    Posts
    29
    I dont understand, but i heard the same from some other sources.
    any particular reason why it is such a PITA?

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by manodba
    I dont understand, but i heard the same from some other sources.
    any particular reason why it is such a PITA?
    Don't u get it, because it doesn't work most of the times, and that's why Oracle itself is deprecating its usage.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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