Oracle 11g OCP Notes (4)--Network services

1. Configure Network Services

1.1 Oracle NET and client-server cases.

1.2 Oracle NET and communication protocols.

1.3 Establish the session.

Linking to a local instance

Name resolution

Start the server process

1.4 Create listeners.

Netca

1.5 Database Registration

Dynamic registration and Static registration

1.6 Techniques for resolving names

3. Name resolution
Session: CONNECT system/****** @service_name;
@service_name need to parse.


(1). Easy Connect (starting with version 10g)
Sql> Connect Scott/[email protected]:1521/service_name;


(2) Local name resolution Tnsname
Tnsname configuration file: $ORACLE _home/network/admin/tnsnames.ora
Include: Service alias, protocol, address, port, service name, or instance name.
The Tnsname configuration can be configured using the NETCA program.
Test Tnsname settings: tnsping service_name


Service1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = hostname) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = db_name.domain.com)
)
)


Service2 =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = hostname) (PORT = 1521))
)
(Connect_data =
(SID = Db_name)
)
)


(3) External name resolution
LDAP Directory server

1.7 Monitoring Manager

Listener configuration file: $ORACLE _home/network/admin/listener.ora
Default listener host 1521 port.

LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = hostname) (PORT = 1521))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
)


The listener can use the NETCA program configuration.
Listener Control Program Lsnrctl:
Start Start listener
Stop Stop Listener
Status Viewing Listener status
Services viewing the services provided by the listener
version viewing the listener version
Reload re-loading the listener
save_config Saving configuration changes to a configuration file Listener.ora
Trace Tracking Listener activity
change_password Setting the listener password
quit exit the listener without saving changes
exit Exit Listener, Save changes
set sets various options, such as tracking and timeouts.
Show Displays the options that have been set for the listener

1.8 Configure the Network service alias.

1.9 FileName and Tnsadmin

There are three files that need to be managed, they are located in Oracle_home/network/admin

environment variable Tns_admin. Specify the location of the three configuration files???????

Note a figure---------------------------------------

1.10 Creating a linked server

2. Shared Server

Oracle 11g OCP Notes (4)--Network services