If SERVICE_NAMES was not set in your parameter file, it will have defaulted to the INSTANCE_NAME suffixed with the DB_DOMAIN. The default for DB_DOMAIN is NULL.
Oracle Networking
■in release 10g Oracle’s network support is limited to:
①TCP
②Named Pipes (or NMP),
③the new Sockets Direct Protocol(or SDP) over InfiniBand high-speed networks.
④The secure sockets variants of these protocols can also be used
⑤All operating systems also have an Inter-Process Communication (or IPC) protocol proprietary to the operating system—this is also available to Oracle Net for local connections where the user process is on the same machine as the server
■Techniques for Name Resolution
①Easy Connect:
SQL> conn gau001/gaudi@192.168.0.100:1521/gaudi
已连接。
②Local Naming：
GAUDI.ap.sony.com=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.0.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gaudi)
)
)
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = serv2.haunting.com)(PORT = 1521))
)
(CONNECT_DATA =
(sid = testdb)
)
)
③Directory Naming
points the user toward an LDAP(the Lightweight Directory Protocol) directory server to resolve aliases.
offers a central repository, the directory server, for all your name resolution details
④External Naming
is conceptually similar to directory naming, but it uses third-party naming services
■Configuring Service Aliases
To launch the Net Manager, run netmgr from a Unix prompt, or on Windows you
will find it on the Start menu.
■Testing Oracle Net Connections
①the Net Manager
②tnsping
************************************************
■Advanced Connection Options
①
ocp10g_net1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora10g_net1.haunting.com)(PORT = 1521))
)
(CONNECT_DATA =
(service_name = ocp10g)
)
)
ocp10g_net2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora10g_net2.haunting.com)(PORT = 1521))
)
(CONNECT_DATA =
(service_name = ocp10g)
Chapter 12: Configuring Oracle Networking
21
PART I
)
)
ocp10g_either =
(DESCRIPTION =
(ADDRESS_LIST =
(load_balance=on)
(failover=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = ora10g_net1.haunting.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ora10g_net2.haunting.com)(PORT = 1521))
)
(CONNECT_DATA =
(service_name = ocp10g)
)
)
②
ocp10g_from_outside =
(DESCRIPTION =
(ADDRESS_LIST =
(source_route=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = firewall.haunting.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ora10g.haunting.com)(PORT = 1521))
)
(CONNECT_DATA =
(service_name = ocp10g)
)
)
