{"id":2025,"date":"2011-03-07T15:04:08","date_gmt":"2011-03-07T20:04:08","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=2025"},"modified":"2011-03-07T15:04:08","modified_gmt":"2011-03-07T20:04:08","slug":"oracle-net8-client-configuration","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=2025","title":{"rendered":"Oracle Net8 Client Configuration"},"content":{"rendered":"<span id=\"Configure_sqlnet.ora\"><h2>Configure sqlnet.ora<\/h2><\/span>\n<p>* Located in $ORACLE_HOME\/network\/admin directory.<br \/>\n* Default directory can be overriden with TNS_ADMIN environment variable. Useful if multiple Oracle homes are present.<\/p>\n<span id=\"Choose_naming_methods\"><h3>Choose naming methods<\/h3><\/span>\n<pre lang=\"txt\">\r\n# Use Oracle naming only\r\nNAMES.DIRECTORY_PATH= (ONAMES)\r\n\r\n# Default, use tnsnames.ora file first, then Oracle names, use host naming last\r\nNAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)\r\n<\/pre>\n<span id=\"Choose_default_domain._\"><h3>Choose default domain. <\/h3><\/span>\n<p>&#8211; Default domain is appended to a service name if it does not contain a dot character.<\/p>\n<pre lang=\"txt\">\r\n# Default domain is world\r\nNAMES.DEFAULT_DOMAIN = world\r\n\r\n# Set default domain to my.com\r\nNAMES.DEFAULT_DOMAIN = my.com\r\n<\/pre>\n<span id=\"Choose_trace_file_location\"><h3>Choose trace file location<\/h3><\/span>\n<p>&#8211; Defaults to $ORACLE_HOME\/network\/trace\/sqlnet.trc<\/p>\n<pre lang=\"txt\">\r\n# Output trace file to \/home\/oracle\/trace\/net8.trc\r\nTRACE_DIRECTORY_CLIENT = \/home\/oracle\/trace\r\nTRACE_FILE_CLIENT = net8.trc\r\n<\/pre>\n<span id=\"Choose_log_file_location\"><h3>Choose log file location<\/h3><\/span>\n<p>&#8211; Defaults to $ORACLE_HOME\/network\/log\/sqlnet.log<\/p>\n<pre lang=\"txt\">\r\nLOG_DIRECTORY_CLIENT = $ORACLE_HOME\/network\/log\r\nLOG_FILE_CLIENT = net8client.log\r\n<\/pre>\n<span id=\"Configure_tnsnames.ora\"><h2>Configure tnsnames.ora<\/h2><\/span>\n<p>* Located in $ORACLE_HOME\/network\/admin directory.<br \/>\n* Default directory can be overriden with TNS_ADMIN environment variable. Useful if multiple Oracle homes are present.<br \/>\n* Syntax<\/p>\n<pre lang=\"txt\">\r\nnet_service_name = \r\n  (DESCRIPTION = \r\n    (ADDRESS = (address_data))\r\n    (CONNECT_DATA = \r\n      (SERVICE_NAME = database_service_name)\r\n      (INSTANCE_NAME = sid)\r\n    )\r\n  )\r\n<\/pre>\n<span id=\"Address_data_syntax\"><h3>Address_data syntax<\/h3><\/span>\n<p>* TCP\/IP<\/p>\n<pre lang=\"txt\">\r\n(PROTOCOL = TCP)(HOST = hostname | ip_address)(PORT = port_num)\r\n\r\n# Example\r\norcl =\r\n  (DESCRIPTION =\r\n    (ADDRESS_LIST =\r\n      (ADDRESS = (PROTOCOL = TCP)(HOST = db.my.com)(PORT = 1521))\r\n    )\r\n    (CONNECT_DATA =\r\n      (SERVICE_NAME = orcl)\r\n    )\r\n  )\r\n<\/pre>\n<p>* Bequeath<br \/>\n&#8211; Client and Server on same machine<br \/>\n&#8211; No need for Net8 listener<br \/>\n&#8211; dedicated server connection only<\/p>\n<pre lang=\"txt\">\r\n(PROTOCOL = BEQ)(PROGRAM = oracle_exe)(ARGV0 = sid_identifier)\r\n(ARGS = '(DESCRIPTION=(LOCAL = YES)(ADDRESS = (PROTOCOL = BEQ)))')\r\n\r\n# oracle_exe: oracle\r\n# sid_identifier: concatenation of oracle_exe and SID, e.g. oracleORCL\r\n<\/pre>\n<p>* IPC<br \/>\n&#8211; Client and server on same machine<br \/>\n&#8211; Still need Net8 listener up and running (bequeath does not need)<\/p>\n<pre lang=\"txt\">\r\n(PROTOCOL = IPC)(KEY = key_name)\r\n\r\n# key_name MUST match listener key_name defined in listener.ora\r\n<\/pre>\n<p>* SPX<br \/>\n&#8211; Novell protocol<\/p>\n<pre lang=\"txt\">\r\n(PROTOCOL = SPX)(SERVICE = spx_service_name)\r\n\r\n# key_name MUST match listener key_name defined in listener.ora\r\n<\/pre>\n<p>* named pipes connections<br \/>\n&#8211; Allows IPC across a Microsoft network<br \/>\n&#8211; Need to install Client for Microsoft Networks<\/p>\n<pre lang=\"txt\">\r\n(PROTOCOL = NMP)(SERVER = server_name)(PIPE = pipe_name)\r\n<\/pre>\n<span id=\"Config_LDAP\"><h2>Config LDAP<\/h2><\/span>\n<span id=\"Create_an_ldap.ora_file_to_contain\"><h3>Create an ldap.ora file to contain<\/h3><\/span>\n<p>* LDAP host and port number<\/p>\n<pre lang=\"txt\">\r\nDIRECTORY_SERVERS = (ldap1.my.com:389:636, ldap2.my.com:389:636)\r\n# port 389 for non-SSL\r\n# port 636 for SSL\r\n<\/pre>\n<p>* Default admin context<\/p>\n<pre lang=\"txt\">\r\nDEFAULT_ADMIN_CONTEXT =\"dc=my, dc=com\"\r\n<\/pre>\n<p>* LDAP server type\/brand<\/p>\n<pre lang=\"txt\">\r\nDIRECTORY_SERVER_TYPE = [OID | AD |NDS]\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Configure sqlnet.ora * Located in $ORACLE_HOME\/network\/admin directory. * Default directory can be overriden with TNS_ADMIN environment variable. Useful if multiple Oracle homes are present. Choose naming methods # Use Oracle naming only NAMES.DIRECTORY_PATH= (ONAMES) # Default, use tnsnames.ora file first, &hellip; <a href=\"https:\/\/jianmingli.com\/wp\/?p=2025\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[90],"tags":[],"class_list":["post-2025","post","type-post","status-publish","format-standard","hentry","category-net8"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-wF","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2025","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2025"}],"version-history":[{"count":1,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2025\/revisions"}],"predecessor-version":[{"id":2026,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2025\/revisions\/2026"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}