Presentation #36576 Oracle9i LDAP: Advanced Configuration of Directory Naming - PowerPoint PPT Presentation

jamar
presentation 36576 oracle9i ldap advanced configuration of directory naming n.
Skip this Video
Loading SlideShow in 5 Seconds..
Presentation #36576 Oracle9i LDAP: Advanced Configuration of Directory Naming PowerPoint Presentation
Download Presentation
Presentation #36576 Oracle9i LDAP: Advanced Configuration of Directory Naming

play fullscreen
1 / 84
Download Presentation
Presentation #36576 Oracle9i LDAP: Advanced Configuration of Directory Naming
111 Views
Download Presentation

Presentation #36576 Oracle9i LDAP: Advanced Configuration of Directory Naming

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Presentation #36576Oracle9i LDAP: Advanced Configuration of Directory Naming Daniel T. Liu Senior Technical consultant First American Real Estate Solutions Date: Wednesday, September 10, 2003 @ 4:30 AM - 5:30 PM Place: Moscone Room 131

  2. Agenda • Net Services Basics • Connecting Methods • OID Basics • Step-by-Step Setup of OID for Names Resolutions • Migrating to OID • Q & A Paper #36576, Daniel T. Liu, FARES

  3. Net Services Basics Paper #36576, Daniel T. Liu, FARES

  4. Net Services In a Nutshell • What is the database instance ? • Instance name (SID) • Where is the database instance ? • Instance address (host, IP address, port) • How to communicate ? • Network language (protocol) Paper #36576, Daniel T. Liu, FARES

  5. Net Services Components • Net Services Client • Net Services Server • Oracle Net • Oracle Net Foundation Layer • Oracle Protocol Support • Listener Paper #36576, Daniel T. Liu, FARES

  6. Client/Server • Net Services Client • Enables client connections to databases across a network. A client-side application sends a request to Oracle Net Services to be transported across the network to the server. • Net Services Server • Enables the listener, through a protocol, to accept connections from client application on the network. Paper #36576, Daniel T. Liu, FARES

  7. Oracle Net • Oracle Net Foundation Layer • Provides a standard method for a client application to establish and maintain communication with the Oracle database server on top of industry-standard network protocol. • Oracle Protocol Support • TCP/IP (with SSL) • Named Pipes • LU 6.2 • VI Paper #36576, Daniel T. Liu, FARES

  8. Oracle Net Paper #36576, Daniel T. Liu, FARES

  9. Listener • A separate process that resides on the server • Receives incoming client connection requests and manages the traffic of these requests to the server • Can listen to one or more databases either on the same system or on different system Paper #36576, Daniel T. Liu, FARES

  10. Listener.ora listener_dallas = (address_list = (address = (protocol = ipc) (key = db1)) (address = (protocol = tcp) (host = dallas.company.com) (port = 1521)) ) sid_list_listener_dallas = (sid_list = (sid_desc = (global_dbname = db1.company.com) (sid_name = db1) (oracle_home = d:\oracle\oracle81) ) ) Paper #36576, Daniel T. Liu, FARES

  11. Making the Connection • Method #1 • Retrieve from user’s memory • Lengthy connect string • Method #2 • Look up in your phone book • tnsnames.ora Paper #36576, Daniel T. Liu, FARES

  12. Making the Connection • Method #3 • Call switchboard • Oracle Names Server • Oracle Internet Directory (LDAP) Paper #36576, Daniel T. Liu, FARES

  13. Method #1: Retrieve From User’s Memory Create a lengthy connect string as follows: connect scott/tiger@ (description= (address = (portocol = tcp) (host=dallas.company.com) (port = 1521) ) (connect_data= (service_name = db1.company.com)) ) Paper #36576, Daniel T. Liu, FARES

  14. Method #2:Retrieve From A Client Machine Local Naming resolves a net service name to a network address using information configure in a local naming configuration file called tnsnames.ora. connect scott/tiger@db1.company.com tnsnames.ora file: db1.company.com (description= (address = (portocol = tcp) (host=dallas.company.com) (port = 1521) ) (connect_data= (service_name = db1.company.com)) ) Paper #36576, Daniel T. Liu, FARES

  15. Method #3:Retrieve From A Central System Central Naming stored the names and address of all database services in a central place on a network. Two popular methods: 1. Oracle Names - Oracle proprietary software to store the service names on a network 2. Directory Naming - clients can use network information stored in a centralized LDAP- compliantdirectory server to access a database service (Oracle Internet Directory) Paper #36576, Daniel T. Liu, FARES

  16. Oracle Internet Directory Basics • Directory • LDAP • Oracle Internet Directory (OID) • OID Terminology • OID Architecture • How Net Services Use A Directory Server Paper #36576, Daniel T. Liu, FARES

  17. Directory • Primarily read-focused • Designed to handle relatively simple transactions on relatively small units of data • Designed to be location-independent • Designed to store information in entries Paper #36576, Daniel T. Liu, FARES

  18. LDAP • LDAP stands for Lightweight Directory Access Protocol • It provides all users and applications in the enterprise with a single, well-defined, standard interface to a single, extensible directory Paper #36576, Daniel T. Liu, FARES

  19. LDAP • It reduces the need to enter and coordinate redundant information in multiple services scattered across the enterprise • Its well-defined protocol and interfaces make it more practical to deploy internet-ready applications that leverage the directory. Paper #36576, Daniel T. Liu, FARES

  20. Oracle Internet Directory (OID) • A general-purpose directory service that enables fast retrieval and centralized management of information • Full-featured LDAP Version 3 compliant directory service • Major Benefits includes: • Scalability • High Availability • Security Paper #36576, Daniel T. Liu, FARES

  21. OID Terminology • Entries • Distinguished Name (DN) • Directory Information Tree (DIT) • Relative Distinguished Name (RDN) • Attributes • Object Classes • Directory Schema • Naming Contexts Paper #36576, Daniel T. Liu, FARES

  22. Directory Information Tree Paper #36576, Daniel T. Liu, FARES

  23. OID Architecture • Oracle Directory Server Instance • OID Monitor • OID Control Utility (OIDCTL) • Oracle9i Database Paper #36576, Daniel T. Liu, FARES

  24. OID Architecture Paper #36576, Daniel T. Liu, FARES

  25. How Net Services Uses A Directory Server Paper #36576, Daniel T. Liu, FARES

  26. Step-By-Step Setup Of Oracle Internet Directory For Names Resolution • Step #1: Planning the Network • Step #2: Installing OID Software • Step #3: Creating OID Repository Database and OID Schema • Step #4: Starting OID Server Paper #36576, Daniel T. Liu, FARES

  27. Step-By-Step Setup Of Oracle Internet Directory For Names Resolution • Step #5: Setting Up Directory Tree (Adding New Entry For Naming Context) • Step #6: Setting Up An Oracle Context • Step #7: Adding Service Names To OID • Step #8: Setting Up The Client Machine Paper #36576, Daniel T. Liu, FARES

  28. Step #1: Planning The Network • Understanding the different version of Oracle Internet Directory Paper #36576, Daniel T. Liu, FARES

  29. Step #1: Planning The Network • Examine Company’s Existing Oracle network environment • List of all the network domains • Oracle database servers within each domain • Oracle instances and listeners running on each server • Number of Oracle Clients Paper #36576, Daniel T. Liu, FARES

  30. Step #1: Planning The Network • Planning the Directory Tree • Single domain called “company.com” • 6 Oracle instances registered Paper #36576, Daniel T. Liu, FARES

  31. Step #2: Installing OID Software • Read the Installation Guide • Prepare the environment • PATH • ORACLE_BASE • ORACLE_HOME • NLS_LANG • PORT 389 is not in use by another process • Mount the CD and bring up the Universal Installer Paper #36576, Daniel T. Liu, FARES

  32. Step #2: Installing OID Software • Choose installation type: • “Management and Integration” option • Then, “Oracle Internet Directory” option • Choose install OID schema on: • An existing database • Or, a new independent database (preferred) • In “Summary” window, review information • Click “Install”, file copy process begins. Paper #36576, Daniel T. Liu, FARES

  33. Step #3: Creating OID Repository Database and OID Schema • The “Configuration Tools” window appears at the end of installation • The Universal Installer will first create and start an OID database instance • Then, it creates OID schema and objects. - $ORACLE_HOME/ldap/admin/newldap.sql • Choose “Exit” and review log file for any installation errors Paper #36576, Daniel T. Liu, FARES

  34. Step #4: Starting OID Server • After successfully completing the installation, the default OID Monitor Daemon and LDAP Server Instance will already be running against OID database instance • To start manually: • oidmon connect=<net_service_name> start • Oidctl connect=<net_service_name> server=oidldapd instance=1 start Paper #36576, Daniel T. Liu, FARES

  35. Paper #36576, Daniel T. Liu, FARES

  36. Paper #36576, Daniel T. Liu, FARES

  37. Paper #36576, Daniel T. Liu, FARES

  38. Paper #36576, Daniel T. Liu, FARES

  39. Paper #36576, Daniel T. Liu, FARES

  40. Paper #36576, Daniel T. Liu, FARES

  41. Paper #36576, Daniel T. Liu, FARES

  42. Paper #36576, Daniel T. Liu, FARES

  43. Paper #36576, Daniel T. Liu, FARES

  44. Paper #36576, Daniel T. Liu, FARES

  45. Paper #36576, Daniel T. Liu, FARES

  46. Step #5: Setting Up Directory Tree • Invoke the Oracle Directory Manager • Type user name and password (orcladmin/welcome) • Create new admin user if needed - Grant “Browse, Add, Delete” access rights • Create the Naming Context • Add new entry “dc=com” • Add new entry “dc=company” under “dc=com” Paper #36576, Daniel T. Liu, FARES

  47. Paper #36576, Daniel T. Liu, FARES

  48. Paper #36576, Daniel T. Liu, FARES

  49. Paper #36576, Daniel T. Liu, FARES

  50. Paper #36576, Daniel T. Liu, FARES